OBIA 11g Released_Amt in W_PURCH_AGREEMENT_LINE_F Needs to Account For cancelled_amt
Last updated on MAY 09, 2016
Applies to:Business Intelligence Applications Consumer - Version 220.127.116.11.1 to 18.104.22.168.2 [Release 11g]
Information in this document applies to any platform.
On : 22.214.171.124.1 version, DataWarehouse
You are seeing in the Interface PLP_PurchaseAgreementLineFact_PurchaseScheduleLine_SQ_W_PURCH_SCHEDULE_LINE the calculation for the column Released_Amt is as follows:
The calculation for released amount is sum of line amount from purchase schedule line fact.
Problem is this doesn’t consider the cancelled_amt associated with the W_PURCH_SCHEDULE_LINE_F.
What should happen is to subtract the cancelled amount when you calculate release amount.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms