- SQL Query to findout Executable, Concurrent Program and its Parameters . . .
fcp concurrent_program_name "Short Name" , fat application_name , fl meaning execution_method , fe execution_file_name ,
- Query to find Concurrent Program Details based on Program Name
Query to find Concurrent Program Details based on Program Name Query to find Concurrent Program Details based on Program Name Home; My Oracle Ace Journey; Oracle; _Oracle DBA fe execution_file_name FROM apps fnd_concurrent_programs fcp, apps fnd_concurrent_programs_tl fcpt, apps fnd_executables fe, I am an Oracle Ace Pro Featured Post Guided Project Cycle to Practice EBS Implement, Build and Upgrade from 12 1 to 12 2 (Learn By Doing)
- Queries for Oracle EBS Concurrent Request
SELECT child request_id AS child_request_id, parent request_id AS parent_request_id, cp user_concurrent_program_name AS report_name, child actual_start_date AS start_time, child actual_completion_date AS completion_time, DECODE (child phase_code, 'C', 'Completed', 'R', 'Running', 'P', 'Pending', 'I', 'Inactive', child phase_code) AS
- Query to get the executable details for the concurrent program or . . .
In this we can pass either the user concurrent program name (or) executable file name so that fetching of data takes place based on the parameter passed to the query SQL Query: SELECT fcp user_concurrent_program_name, fcp concurrent_program_name, fe executable_id, fe execution_file_name FROM fnd_concurrent_programs_vl fcp , fnd_executables fe
- Query to extract seeded custom reports from Oracle EBS
What is the query to extract seeded custom reports (concurrent requests - long name of the program) from Oracle EBS containing also the last run time of that request and the responsibility (from which program is run)?
- Query to find executable file details of concurrent program by passing . . .
One such query is to find the concurrent program details like its executable file name In order to reduce this tedious task, please use below query and keep it handy SELECT user_concurrent_program_name, description, concurrent_program_name,EXECUTION_FILE_NAME , fe EXECUTION_METHOD_CODE, fcp * FROM fnd_concurrent_programs_vl fcp, fnd
- DBA Queries for Checking Concurrent Requests and Programs
SELECT b concurrent_queue_name, c user_concurrent_program_name FROM FND_CONCURRENT_QUEUE_CONTENT a, fnd_concurrent_queues b, fnd_concurrent_programs_vl c WHERE a queue_application_id = 283 and a concurrent_queue_id = b concurrent_queue_id and a type_id = c concurrent_program_id order by decode(INCLUDE_FLAG, ‘I’, 1, 2), type_code; –Query 8
- SQL query to get concurrent program details in Oracle Apps
Use the below query to get BU Name, Legal Entity Ledger Information of Customer Site in Oracle Fusion ERP: SELECT hp party_id, hca cust_account_id, hps party_site_id, hcas cust_acct_site_id, hcsu site_use_id, hl location_id, hp party_number, hp party_name, hca account_number, hps party_site_number, hcsu site_use_code, hcsu primary_flag, hl
|