Find Oracle eBusiness Suite Profile Options

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.

Laisser un commentaire

Votre adresse e-mail ne sera pas publiée. Les champs obligatoires sont indiqués avec *