Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 44 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 278 Oracle Analytics and AI News
- 56 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
What subject area or field to display the corrected amount for Service POs in OTBI
We are using the subject area Receiving - Purchase Receipts Real Time to display PO Receipt information. We are using the field Receipt Amount to display the amount received on a Service PO. That is working as expected.
If we correct the Receipt Amount on one of these service POs, we are not seeing the Corrected Receipt Amount in any of the fields available in this subject area.
When we perform a correction the system is displaying the amount of the correction but we are unable to report on that same amount in OTBI subject area.
This is how it is displayed in OTBI. The full amount was corrected out of the system so OTBI shows Receipt Amount of blank and Delivered Qty of 0.
After researching the Lineage, I can find the correction amount in RCV_TRANSACTIONS.Amount column. However, this column is not available in any of the SCM subject areas.
How can we get this amount to show up on OTBI analysis?
Answers
-
Oh no - it is generally difficult to do that as there is a systemic data integrity for the data flow of entered financial amounts.
-5


