My Oracle Support Banner

OBIA : Upgraded EBS Records (11i --> 12R) Are Not Fetched By AP ETL Mappings (Doc ID 2633731.1)

Last updated on DECEMBER 03, 2021

Applies to:

Business Intelligence Applications Consumer - Version and later
Information in this document applies to any platform.


Oracle Business Intelligence Applications on : version, DataWarehouse

Trying to bring last 5 years of AP/AR data in the Data warehouse using OBIA out of box mappings.
While doing the reconciliations of AP Supplier Balances with EBS, found that invoices/payments records that were upgraded from 11i --> 12R, are not fetched by OBIA ETL Mappings.
On further checking the SQLs, it's found that there is a filter "UPG_BATCH_ID IS NULL" applied in the mappings which is restricting the records.
Due to this, Supplier balance are not coming correctly for some supplier. 




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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.