Since older versions of the Oracle eBusiness Suite, named ERP in versions prior to 11i, it has always been made of the profile options.
This is a mechanism to associate an instance (a site in the eBS vocabulary), application, responsibility and / or user, a value that will be operated by the application to provide an ergonomic enriched a default entry, activation of a trace and / or other possible behavior to secure, enhance, facilitated the use of ERP.
For example here is a range of opportunities through some profile options:
– Java Color Scheme: Set the color scheme applicable to panels Forms
– Concurrent:Request Priority: set the priority of a quote from a simultaneous treatment
– SLA: Enable Diagnostics: Enable diagnostic mode during a transaction SLA
– Signon: Audit Level: specifies the level for which the audit of connection is activated
The main difficulty that faces all those involved on the eBS is that there is not an Oracle official document containing all the profile options, and because there are more than 9 000 standard in the application.
Be found in the user guides and implementation of each module reference (rarely exhaustive) list of profile options available.
In fact there is a simple way to find a profile option and an early explanation of its purpose: search the tables where they are stored !
Here is a SQL script that will allow you to generate CSV extraction profile options per module (GL, AP, FA, etc …) and language (US, FR, IT, etc …):
-- Run this script with APPS/APPS by using SQLPlus with the following command line : -- ENV> ...\SQLPLUS APPS/APPS@eBSInstance -- SQL> start ...\fnd_profile_options.sql
SET TERMOUT ON
ACCEPT APPL_PRODUCT_CODE PROMPT 'Enter the Product Code or Application Short Name (AP, FA, PA...): ' ACCEPT LANGUAGE PROMPT 'Enter the language code like US, FR, DE... (none for all languages): '
-- This code build a file .csv with the expected information SPOOL FND_PROFILE_OPTIONS.csv
SET HEADING OFF SET FEEDBACK OFF SET VERIFY OFF SET LINESIZE 900
PROMPT PRODUCT_CODE;APPLICATION_SHORT_NAME;APPLICATION_NAME;LANGUAGE;PROFILE_OPTION_NAME;USER_PROFILE_OPTION_NAME;DESCRIPTION; SELECT FAPP.PRODUCT_CODE ||';'|| FAPP.APPLICATION_SHORT_NAME ||';'|| FAPP_TL.APPLICATION_NAME ||';'|| FPO_TL.LANGUAGE ||';'|| FPO_TL.PROFILE_OPTION_NAME ||';'|| FPO_TL.USER_PROFILE_OPTION_NAME ||';'|| FPO_TL.DESCRIPTION ||';' FROM APPLSYS.FND_PROFILE_OPTIONS FPO, APPLSYS.FND_PROFILE_OPTIONS_TL FPO_TL, APPLSYS.FND_APPLICATION FAPP, APPLSYS.FND_APPLICATION_TL FAPP_TL WHERE FPO_TL.PROFILE_OPTION_NAME = FPO.PROFILE_OPTION_NAME AND FPO.APPLICATION_ID = FAPP.APPLICATION_ID AND FAPP.APPLICATION_ID = FAPP_TL.APPLICATION_ID AND FAPP_TL.LANGUAGE = FPO_TL.LANGUAGE AND UPPER(FAPP.PRODUCT_CODE) LIKE UPPER('%&&APPL_PRODUCT_CODE%') AND UPPER(FPO_TL.LANGUAGE) LIKE UPPER('%&&LANGUAGE%') ORDER BY FAPP.PRODUCT_CODE, FPO_TL.LANGUAGE, FPO_TL.PROFILE_OPTION_NAME /
SPOOL OFF
PROMPT PROMPT The file FND_PROFILE_OPTIONS.csv has been generated, please check it PROMPT Send any comment to noel.schneider@easyteam.fr PROMPT
Here is an example for the FA module and language US:
PRODUCT_CODE | APPLICATION_SHORT_NAME | APPLICATION_NAME | LANGUAGE | PROFILE_OPTION_NAME | USER_PROFILE_OPTION_NAME | DESCRIPTION |
FA | OFA | Assets | US | FA_ANNUAL_ROUND | FA: Annual Rounding | Controls the annual rounding for depreciation |
FA | OFA | Assets | US | FA_ARCHIVE_TABLE_SIZE | FA: Archive Table Sizing Factor | Controls the size of the dynamic archive tables |
FA | OFA | Assets | US | FA_BATCH_SIZE | FA: Batch Size | This is the batchsize used for bulk processing in mass processes. |
FA | OFA | Assets | US | FA_CACHE_USAGE | FA: Cache Sizing Factor | Controls the amount of database information retained in concurrent program for performance improvement |
FA | OFA | Assets | US | FA_CUSTOM_GEN_CCID | FA: Custom Generate CCID | Enables a user to specify a custom routine to generate ccids |
FA | OFA | Assets | US | FA_DEBUG_FILE | FA: Debug Filename | Specify the directory and filename where debug messages should be logged |
FA | OFA | Assets | US | FA_DEFAULT_DPIS_TO_INV_DATE | FA: Default DPIS to Invoice Date | Default DPIS to Invoice Date for Mass Additions |
FA | OFA | Assets | US | FA_DEPRN_OVERRIDE_ENABLED | FA: Enable Depreciation Override | Enable or Disable the feature of Manual Override |
FA | OFA | Assets | US | FA_DEPRN_SINGLE | FA: Deprn Single | Enables a single asset cache or 20 asset cache |
FA | OFA | Assets | US | FADI_ASSET_CREATION_PRIVS | FADI: Create Assets Privileges | Permitted to use the Create Assets feature |
FA | OFA | Assets | US | FADI_ASSET_PI_PRIVS | FADI: Physical Inventory Privileges | Permitted to use the Assets Physical Inventory feature |
FA | OFA | Assets | US | FA_ENABLED_DEPRN_BASIS_FORMULA | FA: Enable Depreciable Basis Rule | Enables or Disables the feature of depreciable basis rule |
FA | OFA | Assets | US | FA_GEN_EXPENSE_ACCOUNT | FA:Generate Depreciation Expense Account | Generate Depreciation Expense Account |
FA | OFA | Assets | US | FA_INCLUDE_NONRECOV_TAX_MASSADDS | FA: Include Nonrecoverable Tax in Mass Addition | Optionally include the non Recoverable Tax amounts as part of the asset value |
FA | OFA | Assets | US | FA_INS_SWISS_BUILDING | FA: Allow Swiss special assets | Allow Swiss special assets for insurance purposes |
FA | OFA | Assets | US | FA_JAPAN_TAX_REFORMS | FA: Japan 2007 Tax Reforms Features | |
FA | OFA | Assets | US | FA_LARGE_ROLLBACK_SEGMENT | FA: Large Rollback Segment Name | Name of the Rollback Segment for Oracle Assets to use for programs that require large rollback space |
FA | OFA | Assets | US | FA_MCP_ALL_COST_ADJ | FA: Mass Copy All Cost Adjustments | Determines whether to copy adjustments if corp and tax costs are out of sync |
FA | OFA | Assets | US | FA_NUM_GENACCTS_REQUESTS | FA: Number of Generate Accounts Parallel Requests | Controls the number of requests to run in parallel |
FA | OFA | Assets | US | FA_NUM_MASSADD_PAR_REQUESTS | FA: Number Mass Addition Parallel Requests | Controls the number of requests that the Mass Additions Post program that can run in parallel |
FA | OFA | Assets | US | FA_NUM_PARALLEL_REQUESTS | FA: Number of Parallel Requests | Controls the number of requests to run in parallel for those Assets programs that can run in parallel |
FA | OFA | Assets | US | FA_PREGEN_ASSET_ACCOUNT | FA: Generate Asset Level Account | FA: Generate Asset Level Account |
FA | OFA | Assets | US | FA_PREGEN_BOOK_ACCOUNT | FA: Generate Book Level Accounts | FA: Generate Book Level Accounts |
FA | OFA | Assets | US | FA_PREGEN_CAT_ACCOUNT | FA: Generate Category Level Accounts | FA: Generate Category Level Accounts |
FA | OFA | Assets | US | FA_PROJ_MAX_EXTENT | FA: Maximum Projection Extent | Specify maxextents of the table fa_proj_interim |
FA | OFA | Assets | US | FA_SECURITY_PROFILE_ID | FA: Security Profile | |
FA | OFA | Assets | US | FA_TAX_ASSET_TYPE_SEGMENT | FA: Tax Asset Type Category Segment for Japanese Depreciable Asset Tax Report | Category Segment Number/Qualifier for the Tax Asset Type of the Japanese Depreciable Asset Tax Report |
FA | OFA | Assets | US | FA_USE_THRESHOLD | FA: Use Threshold | Determines if Depreciation uses nbv_threshold_amount |
FA | OFA | Assets | US | FA_WF_GENERATE_CCIDS | FA: Use Workflow Account Generation | Controls whether account generation will occur through legacy workflow or deferred to SLA ADR rules |
FA | OFA | Assets | US | PRINT_DEBUG | FA: Print Debug | Enables or Disables output of debugging messages |
FA | OFA | Assets | US | TIME_DIAGNOSTIC | FA: Print Timing Diagnostics | Enables or Disables printing of timing information |
It will be observed in the results obtained in the Description column provides an indication, however short, on the subject of the profile option.
I suggest you take the training Oracle Applications 12.x: Fundamentals of the administration system to understand in detail the setting profile options and their creation.