How to run a report in a multi org environment for all orgs at one stroke Typically, to run for a single org, in the before report trigger, user_exit FND GETPROFILE is used. What if the report at a single run has to generate data for all offices.

  • Interview Candidate
  • 2
  • 2756

Showing Answers 1 - 2 of 2 Answers

PREM

  • Oct 30th, 2006
 

IN THE CONCURRENT PROGRAMM FORM OR WINDOW U HAVE "COPY TO' OPTION AT THE BOTTOM LEFT. CLICK THAT OPTION AND THE SAME REPORT CAN ATTACH TO OTHER ORGANIZATIONS REPEAT IT FOR MULTI ORGANIZATIONS.

  Was this answer useful?  Yes

vipulgosai

  • Apr 25th, 2008
 

Hi,

Use Base table instead of multi-org table. Mean to say...
use AP_INVOICEs_All instead of AP_INVOICE(view) as AP_INVOICE is multi-org view and it fetch rows based on org_id.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions