My Oracle Support Banner

11i/R12: AP: Payables Open Interface Import Rejects Invoices Due To 'Invalid Assignment' (Doc ID 1073953.1)

Last updated on AUGUST 07, 2024

Applies to:

Oracle Payables - Version 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
And by checking the import tables, the category is NULL.


The error appearing on log is as follows:

 

(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


Or, for R12.,  it can be also returned as a rejection:

Rejection Code: Invalid Assignment sequence assigned to
Specified document category.

 

Steps
Log into Oracle Applications using a Payables responsibility.
Populate the interface tables to import some invoices
Run the concurrent program
Get the rejection code on the related invoices

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
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.