12.1.3:APXINWKB:Performance Issue When Querying Invoices by Voucher Number (Doc ID 2045864.1)

Last updated on JULY 13, 2017

Applies to:

Oracle Payables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On :  12.1.3 version, Install Patching & Upgrade issue

ACTUAL BEHAVIOR  
---------------
Invoice Workbench Page is taking more time to open  

Invoice Workbench Page is taking to much time (more than 5 mins)to open while searching thru Voucher No. By giving the Invoice No. its working fine and opens in a Minute.

EXPECTED BEHAVIOR
-----------------------
There should not be any performance issue when querying by voucher number

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. open invoice work bench
2..click on the find icon
3.enter the voucher number and click on find and the it takes more than 5 mins to retrieve the details.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot find the invoice details.

Changes

After application of patch :19918503:R12.AP.B

Cause

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