My Oracle Support Banner

Performance Issue With Invoice Validation Program (Doc ID 2444268.1)

Last updated on SEPTEMBER 06, 2018

Applies to:

Oracle Purchasing - Version 12.2.6 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.6 version, Performance

ACTUAL BEHAVIOR
---------------
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

EXPECTED BEHAVIOR
-----------------------
Invoice Validation Program should finish within normal time

STEPS
-----------------------
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

or

1. Log in into EBS >  Inventory Responsibility
2. Go to Requests > Run Receiving Transaction Processor Report

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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