My Oracle Support Banner

IM_PARTIALLY_MATCHED_RECEIPTS And IM_RECEIPT_ITEM_POSTING Updated Incorrectly (Doc ID 2749366.1)

Last updated on FEBRUARY 22, 2021

Applies to:

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

Symptoms

On : 19.0.009 version, Configuration

You observe when there is more than one invoice for the same shipment and when the second invoice is matched with split receipt and cost resolution for the item partially matched as part of the first invoice, it updates SHIPSKU and IM_RECIPT_ITEM_POSTING tables with incorrect data.

When that same item is unmatched on the second invoice, it updates SHIPSKU and IM_PARTIALLY_MATCHED_RECIPTS tables incorrectly.


The issue can be reproduced at will with the following steps:
  1.Create first invoice for a master PO
  2.Match it against the receipt for the child PO - ensure one item is completely matched and others partially matched
  3.Note that shipsku, im_partailly_matched_receipts and im_receipt_item_posting tables are updated correctly.
  4.Create Invoice with cost discrepancy for one open item and cost and qty discrepancy for the other items.
  5.Detail match the second invoice and resolve the cost discrepancy for the item with only cost issue.
  6.Until now the shipsku, im_partially_matched and im_receipt_item_posting are updated correctly.
  7.Proceed to resolve the qty discrepancy by split receipt and cost next using the resolution action.
  8.Observe that the shipsku and im_receipt_item_posting tables are updated incorrectly.
  9.If you proceed with the next item for resolution, you will observe the message box "Another user has updated this...." box appears.
10.Unmatch item. Observe shipsku is updated incorrectly and im_partially_matched_receipts deleted



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


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