Creating EBS Reports that need to set Inventory Organization First

In Oracle EBS there are several reports that run specifically in an inventory organization context. Please refer to the inventory on hand report below.

If you want to achieve this functionality the way to do this is to create a custom function as shown below:

This custom function basically calls out to the form Run Reports as shown below.

The parameters to be passed to this function are :

REQUEST_GROUP_CODE="INV_TRX_REPORTS" TITLE="INV:INV_TRANSACTION_REPORTS" REQUEST_GROUP_APPL_SHORT_NAME="INV" USE_ORG="Y"

The elements of interest are REQUEST_GROUP_CODE which should be the request group code of your custom request group and USE_ORG="Y" which would launch the change organization form as shown in the first image.

Comments