Performance Issue With Invoice Validation Program
(Doc ID 2444268.1)
Last updated on JULY 27, 2020
Applies to:Oracle Purchasing - Version 12.2.6 and later
Oracle Inventory Management - Version 12.2.8 to 12.2.8 [Release 12.2]
Information in this document applies to any platform.
On : 12.2.6 version, Performance
Performance issue with Invoice Validation Program and Receiving Transaction Processor
We are facing Performance Issue with Invoice Validation Program, We have 5 child requests for invoice validation program and all are running long more than 5 hrs when we have verified with our internal Team below query is causing for long run,please
SELECT POL.PO_LINE_ID FROM PO_LINES_MERGE_V POL WHERE POL.PO_LINE_ID
= ( SELECT POLL.PO_LINE_ID FROM PO_LINE_LOCATIONS_MERGE_V POLL WHERE
POLL.LINE_LOCATION_ID = :B2 AND POLL.DRAFT_ID = :B1 ) AND
POL.DRAFT_ID = :B1
Invoice Validation Program should finish within normal time
The issue can be reproduced at will with the following steps:
1. Log in into EBS > Payables Responsibility
2. Go to Requests > Submit Invoice Validation Program
1. Log in into EBS > Inventory Responsibility
2. Go to Requests > Run Receiving Transaction Processor Report
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