My Oracle Support Banner

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

Last updated on JULY 11, 2022

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

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
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.