BIApps 184.108.40.206 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 220.127.116.11 [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