My Oracle Support Banner

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 MARCH 31, 2019

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.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.