R12: AP: Invoice Online Validation Performance Issue. Taking About 3 Minutes to Validate a Single invoice Using APXINWKB Form
(Doc ID 2668394.1)
Last updated on JANUARY 29, 2024
Applies to:
Oracle Payables - Version 12.1.3 and laterInformation in this document applies to any platform.
Invoice Online Validation Performance Issue. Taking About 3 Minutes to Validate a Single invoice Using APXINWKB Form
Symptoms
On : 12.1.3 and Later
Navigate to Invoice Workbench (APXINWKB).
Create an invoice or query an existing invoice
Click on Actions --> Validate
Below SQL was taking long to execute:
SQL ID: 2sz6grmykj5uh
SELECT T.ENTITY_CODE, T.SOURCE_ID_INT_1, T.SOURCE_ID_INT_2, T.SOURCE_ID_INT_3,
T.SOURCE_ID_INT_4, T.SOURCE_ID_CHAR_1, T.SOURCE_ID_CHAR_2,
T.SOURCE_ID_CHAR_3, T.SOURCE_ID_CHAR_4
FROM
XLA_EVENTS E, XLA_TRANSACTION_ENTITIES T, PSA_BC_XLA_EVENTS_GT P WHERE
P.EVENT_ID = E.EVENT_ID AND E.ENTITY_ID = T.ENTITY_ID
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 51.48 51.75 670917 671953 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 51.48 51.75 670917 671953 0 1
Was spending long time calling the package PSA_BC_XLA_PVT
psa.plsql.psavbcxb.psa_bc_xla_pvt.Budgetary_Control Accounting Mode is FUNDS_CHECK
psa.plsql.psavbcxb.psa_bc_xla_pvt.Budgetary_Control Number of rows in psa_bc_xla_events_gt table Prior to PA/GMS API 1
psa.plsql.psavbcxb.psa_bc_xla_pvt.Budgetary_Control Now invoking the PA_GMS_INTEGRATION_API
psa.plsql.psavbcxb.psa_bc_xla_pvt.pa_gms_integration_api pa_gms_integration_api invoked
psa.plsql.psavbcxb.psa_bc_xla_pvt.pa_gms_integration_api Invoke PA Integration API if PA is enabled
Changes
NONE
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 |