OBIA 11g: Datawarehouse OBIA AP Transactions Are Coming In As Unposted for E-Business 12.1.3
(Doc ID 1602426.1)
Last updated on DECEMBER 21, 2020
Applies to:Business Intelligence Applications Consumer - Version 22.214.171.124.1 and later
Business Intelligence Server Enterprise Edition - Version 126.96.36.199.6 and later
Information in this document applies to any platform.
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.
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