My Oracle Support Banner

Invoices Cannot Be Posted Due to ADJUSTMENT_PENDING Status on Detail Lines (Doc ID 1605384.1)

Last updated on MARCH 02, 2019

Applies to:

Oracle Retail Invoice Matching - Version 13.2.4 to 13.2.7 [Release 13.2]
Information in this document applies to any platform.


In Oracle Retail Invoice Matching (ReIM) found that invoices are stuck in 'MTCH' status and cannot be posted, although the user resolved all discrepancies.  This appears to be due to detail lines in IM_INVOICE_DETAIL.ADJUSTMENT_PENDING ='Y'.   The expected behavior is that invoices should be posted when all discrepancies are resolved and batches are run.

Steps to Reproduce:

1. Create an invoice with cost discrepancies.
2. Run automatch batch.
3. Resolve cost discrepancies using Receiver Cost Adjustment (RCA) reason code.
4. Run reimrollup batch.
5. Notice that in IM_INVOICE_DETAIL table, there is ADJUSTMENT_PENDING ='Y' for item/items.  As result, the invoice is stuck in 'MTCH' status and cannot be posted.




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

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