EAP: When Searching on Match Exception Analysis Page, the Information Retrieved Shows Wrong Totals and Details (Doc ID 2978932.1)

Last updated on OCTOBER 12, 2023

Applies to:

Symptoms

The search criteria functionality in the page Match Exception Analysis does not retrieve the correct data.

Steps:

Page Match Exception Analysis does not retrieve/show the correct data. Summary’s a total number of 26 exceptions and in the details a total number of 27 rows.

   1. Navigate to Match Exception Analysis page: Accounts Payable – Review Accounts Payable Info – Vouchers – Match Exception Analysis.

   2. Use the below Search Criteria and Options and click the Search-button:

•  From Year: 2016
•  To Year: 2016
•  From Month: 01-January
•  to Month: 12-December
•  Supplier SetID: SHARE
•  From Supplier ID: SCM0000004

   3. On Exceptions grouped by Supplier, it displays the following details in the results:

•  Total Exceptions 768
•  Total Rules with Exceptions: 3

   4. Click on the Details-icon. It displays the following details in the results:

•  RULE_R500/ Total Exceptions: 371
•  RULE_R950/ Total Exceptions: 371
•  RULE_I100/ Total Exceptions: 26

   5. Click on the Details-icon for the Match Rule ID RULE_I100:

• It shows Total Exceptions of 26.

   6. Click on the hyperlink Details:

• It shows Total Exceptions of 27: 1 row with an exception date of 21-05-2016 and 26 rows with an exception date of 15-12-2016.

Cause

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