Configuring BI Reports
To import and configure the BI reports in Oracle Supply Chain Management:
1. Navigate to Tools > Reports & Analytics.
2. Click Browse Catalog.
3. In the Folders section, navigate to the required directory.
Example: /Custom/SCMWACS/Inv Adj, /Custom/SCMWACS/Inv Adj/Data Model
Note: Make sure that the user has rights to access the folder.
The BI report path should be configured in the “item.adjust.bipreport” property in the OUTL-BRT-WACS_ERPSCM_ConfigProps Oracle Integration Cloud lookup, along with the file name.
Example: /Custom/SCMWACS/Inv Adj/ERPSCM_InvAdjReport_WACS.xdo
The proposed order to import the files in Oracle Supply Chain Management is as follows:
• ERPSCM_InvAdjQry_WACS.xdm.catalog
• ERPSCM_InvAdjReport_WACS.xdo.catalog
Note: ERPSCM_InvAdjQry_WACS.xdm.catalog has to be unarchived at /Custom/SCMWACS/Inv Adj/Data Model folder and ERPSCM_InvAdjReport_WACS.xdo.catalog has to be unarchived at /Custom/SCMWACS/Inv Adj folder.
4. From the list of tasks related to the selected folder, select Unarchive.
5. Click Browse and select the “ERPSCM_InvAdjQry_WACS.xdm.catalog” archived file to unarchive.
6. Select None and Inherit from the respective Replace and ACL drop-down lists.
7. Click OK.
8. Repeat the steps 5 and 6 to unarchive the “ERPSCM_InvAdjReport_WACS.xdo.catalog” file.
9. Verify the following BI report artifacts are imported successfully:
• ERPSCM_InvAdjQry_WACS.xdm.catalog
• ERPSCM_InvAdjReport_WACS.xdo.catalog
10. Similarly, import the following BI reports:
File Name
Unarchive Location
OIC Config Property Name
OIC Config Property Value
ERPSCM_InvZeroQntyAdjReport_WACS.xdo.catalog
/Custom/SCMWACS/Inv Adj
item.adjust.bipreport
/Custom/SCMWACS/Inv Adj/ERPSCM_InvAdjReport_WACS.xdo
ERPSCM_InvZeroQntyAdjQry_WACS.xdm.catalog
/Custom/SCMWACS/Inv Adj/Data Model
 
 
ERPSCM_CategoryItemReport_WACS.xdo.catalog
/Custom/SCMWACS/Inv Item
wacs.item.bipreport
/Custom/SCMWACS/Inv Item/ERPSCM_CategoryItemReport_WACS.xdo
ERPSCM_Category_Item_WACS.xdm.catalog
/Custom/SCMWACS/Inv Item/Data Model
 
 
ERPSCM_TransferOrderReport_WACS.xdo.catalog
/Custom/SCMWACS/Transfer Orders
transfer.order.bipreport
/Custom/SCMWACS/Transfer Orders/ERPSCM_TransferOrderReport_WACS.xdo
ERPSCM_GetTransferOrder_WACS.xdm.catalog
/Custom/SCMWACS/Transfer Orders/Data Model