APXIIMPT: Payables Open Interface Import Rejects Invoices Due To 'Invalid Assignment' (Doc ID 1073953.1)

Last updated on APRIL 18, 2017

Applies to:

Oracle Payables - Version: 11.5.0 and later   [Release: 11.5.0 and later ]
Information in this document applies to any platform.
Payables Open Interface Import Rejecting INVOICES

Symptoms

When running Payables Open Interface Import some invoices are rejected due to 'document sequencing' issue. The error appearing on log is as follows:

ERROR
--------

(Import_invoice 6.3) Get Doc Sequence
(Get Doc Sequence 1) Get Profile value for Sequencial Numbering
------------> l_seq_num_profile = P
(Get Doc Sequence 2) Seq Num is enabled
(Get Doc Sequence 5) Use Default Category, Seq:Always
------------> l_doc_category_code = STD INV
(Get Doc Sequence 6) Valid Category:Check if valid Sequence assigned
(Get Doc Sequence 6) Reject:Invalid Sequence assignment
(Insert Rejections 1) Insert into AP_INTERFACE_REJECTIONS, REJECT CODE:INVALID A
SSIGNMENT
------------------> l_invoice_status = N l_seqval = l_dbseqnm = l_dbseqid =
(Import_invoice 8.1) Change the invoice status to REJECTING
(Change_invoice_status 1) Change 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