BIApps 22.214.171.124 EBS 11i - COGS Transactions are Unposted when GL journal import is run in summary mode
Last updated on JANUARY 08, 2017
Applies to:Receivables Analytics - Version 126.96.36.199 [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.
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