Invoking Report Based on Trigger in Oracle Apps


We have a Requirement that to run the Payment Voucher Report when user makes the payment.

Trigger1

So we have a Trigger for the purpose and Trigger is on IBY_PAYMENTS_ALL table. So when a payment is Made this trigger will be initiated.

In the trigger the Concurrent Request will be called and depending on the Operating Unit the Report Layout will change and the request will be submitted. I have attached the script in this Blog. Below is the script.

XX_check_print_trg1

Now you can just Include a Menu in the forms like View Payment Voucher Report Button and then the report comes. This is one way of automating the report invocation.

 

About pacesettergraam

A good and realistic person

Posted on March 23, 2016, in Uncategorized. Bookmark the permalink. Leave a comment.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: