My Oracle Support Banner

Slow Response When Defining Payables Option For New/Existing OU (Doc ID 2250910.1)

Last updated on JULY 27, 2018

Applies to:

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

Goal

Slow response when defining payables option for new OU.
Click on the check box “When Payment clears” or click to uncheck the check box, user need wait a long time (more than one minute)

Costly Sql:
===============

SQL ID: fjad09fby550q Plan Hash: 3349429583

SELECT COUNT (*)
FROM
XLA_EVENTS XE , XLA_TRANSACTION_ENTITIES XTE WHERE XE.APPLICATION_ID =200
AND XTE.APPLICATION_ID = 200 AND XE.ENTITY_ID = XTE.ENTITY_ID AND
ROWNUM = 1

call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 50.28 66.08 403151 403379 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 50.29 66.09 403151 403379 0 1

 

Solution

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
Goal
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.