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 laterInformation 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:
(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 |