Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 216 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations 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