OBIA 11g: Datawarehouse OBIA AP Transactions Are Coming In As Unposted for E-Business 12.1.3
Last updated on JANUARY 31, 2017
Applies to:Business Intelligence Applications Consumer - Version 126.96.36.199.1 and later
Business Intelligence Server Enterprise Edition - Version 188.8.131.52.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.
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