Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 53 Oracle Analytics and AI Sharing Center
- 25 Oracle Analytics and AI Lounge
- 306 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.4K Oracle Analytics and AI Forums
- 6.6K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 118 Oracle Analytics and AI Trainings
- 22 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
How do you Validate Data in Inventory Receipts Subject Area
We have a requirement to validate the Receipt Line Count metric on SCM - Inventory Receipts Subject Area of FDI against OTBI. As we do not have a pre-built data validation for this Subject Area, We wanted to understand a way to create a validation report on OTBI for this.
As per the Metric Calculation logic provided by Oracle, the above metric is calculated as Count Distinct(Shipment Line Id).
Which Subject Area in OTBI should be used to validate this data?
We have tried creating a report using Receiving - receipts subject area in OTBI, but the count seen in OTBI is quite high compared to FDI (without any filters applied).
Please suggest on this.
Answers
-
Hi @User_6BZ3R,
Please refer to the Oracle documentation for SCM Analytics Data Validation which might be useful.
This guide provides details on validating metrics and may help you reconcile the counts between FDI and OTBI.
Hope this help.
Thank you.
0 -
Hi @Bhaskar Konar I had reviewed the suggested approach and tried building the validation report.
As I mentioned in my Post, we do not have any OOTB data validation available for Inventory Receipts. I have also reviewed the information available regarding the Subject Area on the product document as well. It does not mention anything about the filter on the data shown in the subject area. Any inputs on that will be helpful.0
