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

Last updated on AUGUST 17, 2016

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.

Symptoms

In Oracle Retail Invoice Matching (ReIM) 13.2.4, we find 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.

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