My Oracle Support Banner

R12: AP: Payables Open Interface Import Performance Issue and Occasional Errors: REP-1419 / REP-0069 (Doc ID 2769760.1)

Last updated on APRIL 19, 2021

Applies to:

Oracle Payables - Version 12.1.3 to 12.2.10 [Release 12.1 to 12.2]
Information in this document applies to any platform.


The Payables Open Interface Import process (APXIIMPT) exhibits slow performance and occasionally ends with error after running for over a few hours.

The AWR report shows this expensive SQL:

Steps to Reproduce:

1.   From an AP Responsibility

2.   Other>Requests>Run

3.   Select: Payables Open Interface Import - enter necessary parameters

4.   OK, then Submit

5.   Notice performance issue (and occasional error that results)




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.