OBIA: PAYABLES_ORG_WID Loaded As 0 For All Records In W_AP_BALANCE_F
Last updated on MARCH 29, 2017
Applies to:Business Intelligence Applications Consumer - Version 220.127.116.11.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 18.104.22.168.1. with the source system as Fusion (Public Cloud).
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