My Oracle Support Banner

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

Last updated on MARCH 13, 2019

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.


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.