OBIA: PAYABLES_ORG_WID Loaded As 0 For All Records In W_AP_BALANCE_F
(Doc ID 2216201.1)
Last updated on SEPTEMBER 19, 2018
Applies to:Business Intelligence Applications Consumer - Version 184.108.40.206.1 and later
Information in this document applies to any platform.
W_AP_BALANCE_F table is loaded with 0 in PAYABLES_ORG_WID field for all the records.
In addition to this the same field (PAYABLES_ORG_WID) is loaded with 0 in W_AP_XACT_F for all the reconciled records.
The below 2 queries are returning zero records.
SELECT * FROM W_AP_BALANCE_F WHERE PAYABLES_ORG_WID <> 0;
SELECT * FROM W_AP_XACT_F WHERE PAYABLES_ORG_WID <> 0 AND GL_RECONCILED_ON_DT IS NOT NULL;
Impacted Reports: Top 10 Suppliers by Overdue Amounts, Payables ->Overview (DPO Gauge) have zero records
To give a background, we are implementing OBIA 220.127.116.11.1. with the source system as Fusion (Public Cloud).
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