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

Symptoms

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