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

Last updated on DECEMBER 15, 2021

Applies to:

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

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