Query to check concurrent program type and Executable name

 select fcptl.concurrent_program_id,fcptl.user_concurrent_program_name,fcptl.description,fcp.Concurrent_program_name,flv.meaning execution_method,fe.execution_file_name
 from
 apps.fnd_concurrent_programs_tl fcptl,
 apps.fnd_concurrent_programs fcp,
 apps.fnd_executables fe,
 apps.fnd_lookup_values flv
 where fcptl.concurrent_program_id = fcp.concurrent_program_id
 and fcp.executable_id = fe.executable_id
 and fe.execution_method_code = flv.lookup_code
 and fcptl.language = 'US'
 and flv.language = 'US'
 and flv.lookup_type='CP_EXECUTION_METHOD_CODE'
 and fcptl.user_concurrent_program_name = '< Cong Program Name>';

Comments

Post a Comment

Popular posts from this blog

R12: PPR Detailed Troubleshooting Guide

R12: Detailed Troubleshooting Guide for AUTOSELECT Issues: When PPR Does Not Select Expected Invoices How Invoices are Selected in a PPR: There are two ways a user can submit the Payment Process Request (PPR) Program. 1. Through the Submit Payment Process Request (PsrPG) OA Framework page This does not require a Payment Process Request Template. Navigation: AP Responsibility > Payments : Entry > Payments Manager Payment Process Requests tab Submit Single Request button From the parameters entered on this page, the OA Framework will insert the data into the following selection criteria tables (AP_INV_SELECTION_CRITERIA_ALL, AP_LE_GROUP, AP_OU_GROUP, AP_CURRENCY_GROUP, AP_PAY_GROUP) Once the Data is inserted into the above selection criteria tables, it submits the Payment Process Request Program concurrent program - This causes the AP_AUTOSELECT_PKG.SELECT_INVOICES procedure to be called. 2. As a Concurrent Request This requires a Payment Process Request Templa...
Read more

Oracle Applications - How to Bounce Services(Forms, Concurrent Mgr, Application Tier etc)

This post gives you a handy information on bouncing the services in eBusiness Suite Applications 11i/R12 Steps to Bounce ----------------- 1. Login to your unix box 2. Set the environment by running the env file present in $APPL_TOP        #cd $APPL_TOP        #ls *.env        #. <env_name>_<host_name>.env 3. Go to $ADMIN_SCRIPTS_HOME  (In 11i, Use $COMMON_TOP/admin/scripts)        #cd $ADMIN_SCRIPTS_HOME        4. Here you will see a list of files and based on the need you will have to run various scripts as given below      4.1. Bounce All Services ( Note the 'dot' after the # sign in the commands below and above)                           ...
Read more