R12_AP: Process Payables Open Interface APXIIMPT Fails With ORA-20001 While Importing Transactions With Prepayment (Doc ID 1944935.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

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

Symptoms

When attempting to the Payables Open Interface APXIIMPT process for an invoice with a prepayment application and the prepayment invoice has the same invoice number as a cancelled invoice for the same supplier for a different site, the following error occurs:

Get prepay_invoice_id
(Check Prepayment Info 1) Call Check Prepayment Function.
ORA-20001:
v_check_prepay_info<-AP_IMPORT_VALIDATION_PKG.v_check_invoice_validation<-Import
_invoices<- Before Report Trigger
(Check Invoice Validation 14) Check for Prepayment Info.
v_check_invoice_validation<-Import_invoices<- Before Report Trigger
(Import_invoice 17.1) Change the invoice status to REJECTING

 

Cause

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