Error in Summary Matching Screen is Not Relevant When Resolving the Discrepancy Through Summary Match Screen, Having the Receipt's Item with Zero Unit_cost
(Doc ID 2432294.1)
Last updated on AUGUST 16, 2018
Applies to:Oracle Retail Invoice Matching - Version 16.0.1 and later
Information in this document applies to any platform.
While resolving the discrepancy through summary match screen, when having the receipt's item with 0 unit_cost, summary matching screen popup's error which is not descriptive.
@PACKAGE_ERROR@1ORA-01476: divisor is equal to zero@2REIM_OI_SQL.FETCH_COST_EVENT_INFO.
Steps To Recreate :
1. Create Purchase Order (PO).
2. Create Receipt with 0 unit cost for one of the item.
3. Create invoice with discrepancies and execute the Automatch batch .
4. Go to the summary match screen,detail match and check the item with 0 unit cost in receipt then the attached error will popup.
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