My Oracle Support Banner

Error Occurs When Trying To Navigate To 'Invoice/Item View' in Detail Matching Screen (Doc ID 2995953.1)

Last updated on JANUARY 05, 2024

Applies to:

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


Error occurs when trying to navigate to 'Invoice/Item View' in Detail Matching screen.

"An application error has occurred"

Steps to Recreate:

  1. Create a Purchase Order (PO) for multiple items. Ensure that one of the items has zero cost.
  2. Receive zero cost item partially along with few other items.
  3. Receive all other items fully.
  4. Navigate to Summary Matching -> Detail Matching screen.
  5. Resolve discrepancy for one item which is not having zero cost in PO.
  6. Try to navigate to 'Invoice/Item View' and notice the error:
    "An application error has occurred"
  7. LOGGER_LOGS shows below error:
    "@0PACKAGE_ERROR@1ORA-01476: divisor is equal to zero@2REIM_ONLINE_MATCH_SQL.CREATE_INVC_ITEM_VIEW_WS ORA-01476: divisor is equal to zero"




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

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