Oracle Transactional Business Intelligence

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

What subject area or field to display the corrected amount for Service POs in OTBI

Incorrect Answer
19
Views
1
Comments

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.

image.png

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.

image.png

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

  • Syamantak Saha
    Syamantak Saha Rank 5 - Community Champion
    edited Sep 6, 2025 2:40PM

    Oh no - it is generally difficult to do that as there is a systemic data integrity for the data flow of entered financial amounts.