OBIA: PAYABLES_ORG_WID Loaded As 0 For All Records In W_AP_BALANCE_F

(Doc ID 2216201.1)

Last updated on MARCH 29, 2017

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.10.1 and later
Information in this document applies to any platform.

Symptoms

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 11.1.1.10.1. with the source system as Fusion (Public Cloud).

Cause

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