, ,

Know license applications

Know license applications:-
——————————-
Lot many times we would not be known if the client has the specific application license or not.

We can ask the client is one way. If you have access to the back-end for the production Instance. Then you could know with following query. This is the Other way. 

All the applications which are Installed status are license one.

SELECT application_name
, application_short_name
,DECODE (status, ‘I’, ‘Installed’, ‘S’, ‘Shared’, ‘Not Installed’) status
, a.application_id
,i.patch_level
FROM fnd_application_all_view a
, fnd_product_installations i
WHERE a.application_id = i.application_id 
ORDER BY 1;

/by
, ,

FlexFields

Flexfields stores main Information of the Organizations. We have many flexfields in different modules.

Note:- The following Flexfields are avilable in the 11.5.8 Oracle Application Version.
—–

You may find more flexfield in the new Oracle apps versions.

To check all the Flexfield avilable for your Oracle Apps version, use the Flexfield Query

Application Name
Flex-field Name
Application Description
CRL Financials Assets
Super Group
CRL Financials – Assets
CRL Financials Assets
Group Asset
CRL Financials – Assets
Oracle Advanced Service Online
AHL Route
Oracle Advanced Service Online
Oracle Advanced Service Online
AHL Operation
Oracle Advanced Service Online
Oracle Assets
Location Flexfield
Oracle Assets
Oracle Assets
Category Flexfield
Oracle Assets
Oracle Assets
Asset Key Flexfield
Oracle Assets
Oracle General Ledger
Accounting Flexfield
Oracle General Ledger
Oracle Human Resources
Soft Coded KeyFlexfield
Oracle Human Resources
Oracle Human Resources
Job Flexfield
Oracle Human Resources
Oracle Human Resources
Grade Flexfield
Oracle Human Resources
Oracle Human Resources
CAGR Flexfield
Oracle Human Resources
Oracle Human Resources
Competence Flexfield
Oracle Human Resources
Oracle Human Resources
Item Contexts Keyflex
Oracle Human Resources
Oracle Human Resources
Personal Analysis Flexfield
Oracle Human Resources
Oracle Human Resources
Position Flexfield
Oracle Human Resources
Oracle Inventory
System Items
Oracle Inventory
Oracle Inventory
Sales Orders
Oracle Inventory
Oracle Inventory
Item Categories
Oracle Inventory
Oracle Inventory
Account Aliases
Oracle Inventory
Oracle Inventory
Item Catalogs
Oracle Inventory
Oracle Inventory
ORACLE_SERVICE_ITEM_FLEXFIELD
Oracle Inventory
Oracle Inventory
Stock Locators
Oracle Inventory
Oracle Payroll
People Group Flexfield
Oracle Payroll
Oracle Payroll
Bank Details KeyFlexField
Oracle Payroll
Oracle Payroll
Cost Allocation Flexfield
Oracle Payroll
Oracle Public Sector Budgeting
PSB Position Flexfield
Oracle Public Sector Budgeting
Oracle Receivables
Territory Flexfield
Oracle Receivables
Oracle Receivables
Sales Tax Location Flexfield
Oracle Receivables
Oracle Receivables
ARTA-Receipt Prof Ident
Oracle Receivables
Oracle Training Administration
Training Resources
Oracle Training Administration
/by
, ,

QUERY FOR FINDING REQUEST GROUP

SELECT fa.application_short_name,
       frg.request_group_name,
       fe.execution_file_name,
       fe.executable_name
  FROM fnd_request_group_units frgu,
       fnd_concurrent_programs fcp,
       fnd_request_groups frg,
       fnd_executables fe,
       fnd_application fa
 WHERE     frgu.request_unit_id = fcp.concurrent_program_id
       AND frgu.request_group_id = frg.request_group_id
       AND fe.executable_id = fcp.executable_id
       AND FRG.application_id = fa.application_id
       AND fe.executable_name = ‘XX_PC_PURCHASE’;
/by