How to parse field / column value from oracle form to concurrent program parameter input and enable tools menu to call program
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.