DBMS_UTILITY.GET_TIME – Oracle Database API to Calculate Elapsed Time

DBMS_UTILITY is utility package in Oracle which provides sub-programs to analyze table, format stack, get CPU time, table to comma and comma to table conversion. Let’s check GET_TIME sub-program which returns the time in millisecond. DBMS_UTILITY.GET_TIME Oracle dbms_utility.get_time returns current time in millisecond. Divide it by 100 to get time in seconds. This API is helpful …

DBMS_UTILITY.GET_TIME – Oracle Database API to Calculate Elapsed Time Read More »

Master-Child Concurrent Program Using FND_CONC_GLOBAL in Oracle Apps

Let’s see how to design concurrent program which spawns multiple child concurrent programs. The master program waits till all child programs are complete.Oracle provides built-in package FND_CONC_GLOBAL and FND_REQUEST to achieve parent-child program using PL/SQL. FND_CONC_GLOBAL.SET_REQ_GLOBALS – sets the value of the REQUEST_DATA global variable. conc_status – Status of concurrent program like ‘PAUSED’, ‘RUNNING’ request_data …

Master-Child Concurrent Program Using FND_CONC_GLOBAL in Oracle Apps Read More »