Automatch Job Not Processing Invoices Which Are In RMTCH Status (Doc ID 2899124.1)

Last updated on OCTOBER 04, 2022

Applies to:

Goal

Automatch job not processing invoices which are in RMTCH status.

There are about 6500+ invoices that are not getting picked from IM_DOC_HEAD table which are in RMTCH match status.

For example, let us take an order 1234 with an item 567890 with quantity 10. The unit_cost of the item in ordloc.unit_cost is 5. While shipping the same item, it has been received in two different cartons and with different qty as 6 and 4 qty respectively.

Here the shipsku.unit_cost for 6 qty is 5 and unit_cost for the same item for 4 qty is 6. So, this unit_cost different is causing the automatch to not to pick the invoices created against the above order resulting in no cost/qty routing and user is also unable to route the invoice for cost from front end.

Suggested Resolution: We can resolve this issue by taking an RCA from RMS screen for the item and ensure that the shipsku.unit_cost is in sync with ordloc.unit across all the containers. So that the reimautomatch will pick the invoices and match the eligible invoices and also it will route for cost/qty discrepancy.

Kindly let us know the impact on the ReIM/RMS if we consider taking an RCA for the item from RMS screen. Also suggest us if you have any other approaches to resolve the issue.

Solution

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