ORACLE ERP & APPS TECH

 Step1: Enable tools Menu when new form instance Action Tab: Type: Menu Menu Entry: Special 4 Menu Name: Enter user friendly name seq1: to initialize the global variable to be passed to Concurrent program seq2: to capture the form value to global variable to be passed to Concurrent program Next seq condition to call concurrent program from special menu Action tab: seq1:Assign the form value to the global variable seq2:Call the concurrent program from the tools special menu Navigate to concurrent program definition:  assign default value type as SQL Statement and default value for the parameter required:  select :GLOBAL.XX_G_JOB from dual Output: Opens up the report with the default value of job from the oracle form to concurrent program parameter.

 Script to enable and disable DB Scheduler in Oracle Apps -> To enable DB scheduler BEGIN dbms_scheduler.enable('APPS.REQIMPORT_SCHEDULE'); END; -> To disable DB Scheduler BEGIN dbms_scheduler.disable('APPS.REQIMPORT_SCHEDULE'); END; -> To check status  select owner, job_name, job_action, enabled,state from dba_scheduler_jobs where job_name ='REQIMPORT_SCHEDULE';