Does PO_REQUISITION_LINES_ALL.MODIFIED_BY_AGENT_FLAG Affect The Purchase Requisition Amount?
(Doc ID 1312442.1)
Last updated on AUGUST 03, 2020
Applies to:Business Intelligence Applications Consumer - Version 188.8.131.52 [AA 1830] and later
Procurement and Spend Analytics - Version 184.108.40.206 [AA 1830] and later
Information in this document applies to any platform.
On: Oracle BI Applications 220.127.116.11 (Procurement and Spend Analytics)
With source system: Oracle e-Business Suite R12.1.1
For User Acceptance Testing (UAT), the Business Users extracted Purchase Requisition data from the Oracle e-Business Suite (EBS) source system to compare it with the reports / data in Oracle BI Applications (OBIA).
It was observed that the Requisition Amounts were different / did not match ... and the discrepancy / difference was found to be for / with any Requisition where PO_REQUISITION_LINES_ALL.MODIFIED_BY_AGENT_FLAG was 'Y' in the EBS source system.
Such records in the EBS are not considered by OBIA when calculating Requisition Amounts. For example:
See the SDE mappings set DELETE_FLG to 'Y' in the Staging Fact Tables whenever the MODIFIED_BY_AGENT_FLAG = 'Y':
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document