We can find current execution stage of any PL/SQL code from table GV$SQLTEXT_WITH_NEWLINES but we need its session ID. If that PL/SQL code belongs to… Read More »Long Running Programs – SQL Query to Find Current Execution Stage of a Concurrent Request
SELECT fcr.request_id , fcpt.user_concurrent_program_name || NVL2(fcr.description, ‘ (‘ || fcr.description || ‘)’, NULL) conc_prog , fu.user_name requestor , fu.description requested_by , fu.email_address , frt.responsibility_name requested_by_resp… Read More »SQL Query to Find Scheduled Concurrent Programs List
/******************************************************* *PURPOSE: SQL Query to find DFF Structure from backend* *AUTHOR: Shailender Thallam * *******************************************************/ SELECT apps.application_name "Application", d_flex.title "DFF Title", d_flex.application_table_name "Table Name", d_flex.context_user_override_flag… Read More »SQL Query to Find DFF Structure from backend
To migrate an XMLP report we need below 4 objects LDT file for Concurrent Program LDT file for XMLP Template and Data Definition XML Data… Read More »FNDLOAD and XDOLoader to Migrate XMLP reports
/******************************************** *PURPOSE: To Delete Lookup or Lookup Code * *AUTHOR: Shailender Thallam * *********************************************/ SET serveroutput ON; — DECLARE CURSOR cur_lkp_values IS SELECT lookup_type,… Read More »PL/SQL Script to Delete Lookup or Lookup Code
To run a unix based shell script as a concurrent program, the executable of the concurrent program should be registered as a ‘Host’ program. The… Read More »What is Host Program? How to create Host Program? and What is .Prog file?
Trace file is not in a understandable format, but to make it easier to understand and readable Oracle has provided a utility TKPROF. Syntaxt to… Read More »What is TKPROF? How to run TKPROF?
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 /************************************************************ *PURPOSE: To change/reset… Read More »PL/SQL Script to Reset User Password from Backend
This article tells you the process of generating trace for a concurrent program which will be helpful for debugging. Step 1: Enable trace for a… Read More »How to Generate Trace for a Seeded or Custom Concurrent Program/Report?
A field “Operating Unit Mode” is present in the Concurrent Program definition when viewed through OA Framework pages. Query to check this option from back-end:… Read More »How to set ORG_ID for MOAC Enabled Concurrent Programs while Submitting from Backend