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:

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

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