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

Last updated on APRIL 03, 2017

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

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