Performing RUA in ReIM Not Updating RMS and IM_INVOICE_DETAIL.ADJUSTMENT_PENDING Remains 'Y' (Doc ID 2244916.1)

Last updated on MARCH 21, 2017

Applies to:

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

Symptoms


Performing a receiver unit adjustment (RUA) in ReIM is not updating RMS, and IM_INVOICE_DETAIL.ADJUSTMENT_PENDING remains 'Y'.



Steps to Reproduce:
1. Create an order for 3 items
     Item A- 4
     Item B - 1
     Item C- 12
2. Approve the PO
3. Ship and receive the following quantities:
      Ship
     ======
     Item A- 4
     Item B- 1
     Item C- 1

      Receive
    ========
     Item A- 4
     Item B- 0
     Item C- 0
4. Create a manual invoice for the original order quantity, which was 17.
5. Enter the invoice detail for all of the items.
6. Run Automatch- the invoice is in 'Unresolved Match' status.
7. Resolve the quantity discrepancy in favor of the invoice for item C. Choose RUA as the reason code. Specify -12 and the receipt.
8. Resolve the other item with discrepancy write-off (DWO).
9. The IM_RESOLUTION_ACTION table now shows 2 lines.
10. The invoice is in matched status.
11. Run Reimrollup. Notice that the RUA is not rolled up by the job.


Changes

 

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