My Oracle Support Banner

Invoice Stuck in MTCH Status if There Are 2 Cost Adjustments With Different Cost for the Same Item (Doc ID 2493544.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Retail Invoice Matching - Version 14.1.2 and later
Information in this document applies to any platform.

Symptoms

Invoice stuck with MTCH state if there are 2 Cost adjustments with different cost for the same item.

Steps To recreate:

  1. Create a Purchase Order (PO) with an item (Say : Quantity = 88 units, unit cost = 7.56) .
  2. Ship & Receive the PO.
  3. Create two invoices with cost discrepancy (Invoice 1: Quantity=44 units, unit_cost =3 , Invoice 2: Quantity = 44units, unit_cost=3.5).
  4. Resolve the invoice 1 with Split receipt and cost resolution by applying RCA.
  5. Resolve the invoice 2 with another RCA.
  6. Run reimrollup  it just updated only one invoice with im_invoice_detail.ADJUSTMENT_PENDING='N', another invoice left with Y. 
  7. Run reimposting batch.
  8. Invoice 2 is stuck in MTCH status and not posted.

Changes

 

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