Oracle Apps Techno Functional................

1. Query to get List of Custom Concurrent Programs SELECT   DISTINCT fcp.user_concurrent_program_name "Concurrent Program Name", fa.application_name, fcp.concurrent_program_name conc_short_name, decode( fef.execution_method_code, 'H','Host', 'I', 'PLSQL Stored Procedure', 'P', 'Report', 'L', 'SQL Loader', 'Q','SQL*Plus', 'A','Spawned', 'K','Java Concurrent Program', 'B','Request Set Stage Function', 'S','Immediate', 'J','Java Stored Procedure', 'M','Multi-Language Function', fef.execution_method_code) "execution method", fef.executable_name, fcp.description "Concurrent Program Description", fef.executable_name"Executable Name", fef.description "Executable Description", fef.execution_file_name , fcp.enabled_flag ,FCP.CREATION_DATE     FROM ...

                                                        usage of $FLEX$ T his article illustrates the usage of $FLEX$ with an example. $FLEX$ is a special bind variable that can be used to base a parameter value on the other parameters (dependent parameters) Syntax  –     :$FLEX$.Value_ Set_Name Value_Set_Name  is the name of value set for a prior parameter in the same parameter window that you want your parameter to depend on. Some scenarios where $FLEX$ can be used: Example1: Say you have a concurrent program with the below 2 parameters which are valuesets : Parameter1 is Deparment Parameter2 is Employee name Let’s say there are 100 deparments and each deparment has 200 employees.  Therefore we have 2000 employees altogether. If we  display all department names in the valueset of parameter1...

The main use of enabling trace for a concurrent program comes during performance tuning. By examining a trace file, we come to know which query/queries is/are taking the longest time to execute, there by letting us to concentrate on tuning them in order to improve the overall performance of the program. The following is an illustration of how to Enable and View a trace file for a Concurrent     Program. Navigation: Application Developer–>Concurrent–>Program Check the Enable Trace Check box. After that go to that particular Responsibility and run the Concurrent Program. Check that the Concurrent Program has been completed successfully. The trace file by default is post fixed with oracle Process_id which helps us to identify which trace file belongs to which concurrent request. The below SQL Query returns the process_id of the concurrent request: Select oracle_process_id from fnd_concurrent_requests where request_id=’2768335′ (This query displa...