OBIA 11g: Datawarehouse OBIA AP Transactions Are Coming In As Unposted for E-Business 12.1.3 (Doc ID 1602426.1)

Last updated on JANUARY 31, 2017

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.7.1 and later
Business Intelligence Server Enterprise Edition - Version 11.1.1.6.6 and later
Information in this document applies to any platform.

Symptoms

AP transactions that are pulled in from E-Business Suite 12.1.3 are showing as UNPOSTED state . The same transactions in E-Business show that they're POSTED to GL, but when the transactions are pulled in using the Informatica to the Datawarehouse table W_AP_XACT_F they have the UNPOSTED state . We ran the SQL queries that are used by the Informatica for the data load and noticed that the transactions are missing in few of the XLA tables and the detailed document for which are attached. We took a two sample scenarios wherein a AP transaction is coming in as POSTED and UNPOSTED in Datawarehouse.

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