BIApps 7.9.6.3 EBS 11i - COGS Transactions are Unposted when GL journal import is run in summary mode (Doc ID 1558493.1)

Last updated on JANUARY 08, 2017

Applies to:

Receivables Analytics - Version 7.9.6.3 [AN 1900] and later
Information in this document applies to any platform.
Currency Review 01-Dec-2014

Symptoms

We are implementing Financials Analytics and discover that there are no COGS transactions in any Profitability dashboards.
In the rpd, logical record Fact - Fins - GL Cost of Goods Sold Posted, only POSTED COGS transactions are shown.

However, in the data warehouse (W_GL_COGS_F) all transactions are UNPOSTED. By doing research, we have discovered that in Informatica mapping SDE_ORA_GLCOGSFact the flag DOC_STATUS_ID is used to determined if the transaction is posted or unposted. The field used to determine the posted or unposted flag is called INP_SOURCE_OF_DATA. This field is ALWAYS NULL which causes all transactions to be UNPOSTED. See attachment doc.

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