Invoices Cannot Be Posted Due to ADJUSTMENT_PENDING Status on Detail Lines
Last updated on JUNE 04, 2018
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) 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.
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