Monday, 8 December 2014

Submitting the concurrent program from Tools menu using form personalization

Submitting the concurrent program from tools menu using form personalization

You have an invoice form opened with a particular invoice number and wanted to print the particular invoice from the same from instead of submitting the report request separately. This can be achieved using form personalization and user can able to submit the print program directly from the tools menu.
The solution can be applied at various places like printing a sales order, purchase order etc.
In this example I am putting up the form personalization on invoice transaction form.
Switch to Receivables super user responsibility 
N> transactions->transactions
Then Click on Help from toolbar Help-> diagnostics-> custom code-> personalize
I am rendering Menu first, let’s say Print selected invoice

Then click on actions

Once done save the changes. Come back to personalization form and add menu actions

And click on the action

Here I am setting up the global variable with value and the value is the string construct by which we pass the parameters to a concurrent program so make sure you pass values correctly.
So this is my actual string constuct
=select 'Transaction Number:::'||${item.TGW_HEADER.TRX_NUMBER_MIR.value}||':'||${item.TGW_HEADER.TRX_NUMBER_MIR.value}||'::::::No:No:' from dual
When you submit the form the sting will pass on the value to the concurrent report as 

Once done add new action as built-in and select the type as Launch SRS Form and pass the invoice printing program name there.

Add personalization on FND_FNDRSRUN form (request submission form)

Click on action and pass on the same global variable we defined in earlier stages

Save the personalization.

And come back to invoice form query an invoice number and click on tools and click on the new menu you have added (print selected invoice). Once you clicked on the menu the concurrent request submission form will get opened and you can check the parameters are being passed correctly if not please check the SQL which we have built in earlier stage.

1 comment:

  1. Regards
    Sridevi Koduru (Senior Oracle Apps Trainer
    LinkedIn profile -
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, Oracle Manufacturing, BI Publisher, OAF, ADF, SQL, PL/SQL, D2K at | +91 - 9581017828.