AppsDBA Scripts

December 2, 2022 How to Get Apps Password From Backend

APPS DBAAppsDBA ScriptsInstallations/Configurations-ApplicationsOracle APPS DBAScripts

How to Get Apps Password From Backend STEP 1. First login to Database through Command Prompt sqlplus / as…

November 9, 2017 How to Find Request Group associated for a Program

AppsDBA ScriptsScripts

How to Find Request Group associated for a Program SELECT rg.application_id “Request Group Application ID”, rg.request_group_id “Request Group – Group ID”, rg.request_group_name, rg.description, rgu.unit_application_id, rgu.request_group_id “Request Group Unit – Group ID”, rgu.request_unit_id, cp.concurrent_program_id, …

November 9, 2017 How to Find Scheduled Concurrent Program

AppsDBA ScriptsScripts

How to Find Scheduled Concurrent Program Below Query will Fetch all the details for a scheduled concurrent program. SELECT a.requested_by, a.status_code, a.phase_code, …

October 10, 2017 Query To find the details of the Accounting Flexfield structure

AppsDBA ScriptsConfigurations-GLScripts

SELECT gls.name, idfs.id_flex_num chart_of_accounts_id, idfs.segment_num, idfs.flex_value_set_id, fvs.flex_value_set_name, idfs.application_id, idfs.id_flex_code, idfs.application_column_name, idfs.segment_name, fvs.security_enabled_flag, ( CASE WHEN fvs.validation_type = ‘F’ THEN ‘Table’ WHEN fvs.validation_type = ‘I’ THEN ‘Independent’ WHEN fvs.validation_type = ‘D’ THEN ‘Dependent’ WHEN fvs.validation_type = ‘N’ THEN ‘None’ WHEN fvs.validation_type = ‘P’ THEN ‘Pair’ WHEN fvs.validation_type = ‘U’ THEN ‘Special’ ELSE ‘Unknown Type’ END ) validation_type, ( CASE …