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.


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:
     Item A- 4
     Item B- 1
     Item C- 1

     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.




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