My Oracle Support Banner

BIApps 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 [AN 1900] and later
Information in this document applies to any platform.
Currency Review 01-Dec-2014


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.




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

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