My Oracle Support Banner

Payables Open Interface Import Program Taking Very Long Time Finish. (Doc ID 3068626.1)

Last updated on JANUARY 22, 2025

Applies to:

Oracle Payables - Version 12.1.2 and later
Information in this document applies to any platform.

Symptoms

Payables Open Interface Import Program takes very long time to finish.

It used to complete in 1 Hr, but now it takes 5-6 Hr to complete.

Log file of the concurrent execution shows the following:

+---------------------------------------------------------------------------+
 Payables: Version : 12.2
 Copyright (c) 1998, 2013, Oracle and/or its affiliates. All rights reserved.
 APXIIMPT: Payables Open Interface Import
 +---------------------------------------------------------------------------+
 Current system time is 08-OCT-2024 12:44:03
 +---------------------------------------------------------------------------+

+-----------------------------
| Starting concurrent program execution...
+-----------------------------
Arguments
------------
p_source='VDOTREFUND'
p_batch_name='N/A'
------------

 APPLLCSP Environment Variable set to :
 Current NLS_LANG, NLS_NUMERIC_CHARACTERS and NLS_SORT Environment Variables are :
 American_America.UTF8
 '.,'
 BINARY
 Enter Password:
 MSG-00000: 13593 invoice(s) were created during the process run
 MSG-00000: 79011 invoice(s) were fetched during the process run
 MSG-00000:  summarize flagN
 MSG-00883: After Repport Trigger: Setting the Org Context to Multiple

Report Builder: Release 10.1.2.3.0 - Production on Tue Oct 8 12:44:08 2024
Copyright (c) 1982, 2005, Oracle.  All rights reserved.

+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
No completion options were requested.
Output file size:
55749223
 +---------------------------------------------------------------------------+
 Concurrent request completed successfully
 Current system time is 08-OCT-2024 17:30:31
 +---------------------------------------------------------------------------+

Notice the highlighted lines.  The execution started at 12:44:03 and ended at 17:30:31; almost 5 hours to process 79000 records.


Steps to reproduce:

  1. Populate the Payables Open Interface tables (AP_INVOICES_INTERFACE, and AP_INVOICE_LINES_INTERFACE) with records to import.
  2. Log into Oracle Applications using a Payables responsibility.
  3. Open tghe Standard Request Submission (SRS) screen
    (N) Other > Requests > Run
  4. Find/Select/Submit the Payable Open Interface Import program.
  5. Wait until program completion; 5-6 hrs later.

Changes

Issue noticed after upgrade from R12.1 to R12.2

Cause

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
Changes
Cause
Solution
References


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