My Oracle Support Banner

R12 AP: Create Accounting (XLAACCPB) Is Taking A Long Time (More Than 45 Hours) (Doc ID 1627143.1)

Last updated on JULY 30, 2018

Applies to:

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

Symptoms

On : 12.1.3 version,

Performance problem with the Create Accounting program.
It takes a long time to finish (45 hours )



The following SQL statements take most of time:


SQL_ID = 5t39uchjqpyfm
BEGIN xla_accounting_pkg.unit_processor_batch(:errbuf, :rc, :A0, :A1, :A2, :A3, :A4, :A5, :A6, :A7, :A8, :A9, :A10, :A11, :A12, :A13, :A14); END;


SQL_ID aqkb8rtt1m2q7
UPDATE AP_INVOICE_DISTRIBUTIONS_ALL AID SET AID.POSTED_FLAG = 'S' ,
LAST_UPDATED_BY = FND_GLOBAL.USER_ID , LAST_UPDATE_DATE = SYSDATE ,
LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID WHERE AID.ACCOUNTING_EVENT_ID = :B1

 

SQL_ID = 3btwyhtxjrasg

SELECT MAX(ACCOUNTING_EVENT_ID)
FROM
( SELECT MAX(APH.ACCOUNTING_EVENT_ID) ACCOUNTING_EVENT_ID
FROM AP_PAYMENT_HISTORY_ALL APH , AP_INVOICE_PAYMENTS_ALL AIP ,
XLA_EVENT_TYPES_B XET , XLA_EVENT_TYPES_B XET_REL , XLA_EVENTS XE , XLA_EVENTS_GT XGT
WHERE AIP.INVOICE_ID = :B2 AND APH.CHECK_ID = AIP.CHECK_ID
AND XE.EVENT_ID = APH.ACCOUNTING_EVENT_ID AND XET.EVENT_TYPE_CODE = :B1
AND XET_REL.EVENT_CLASS_CODE = XET.EVENT_CLASS_CODE
AND XET_REL.EVENT_TYPE_CODE = XE.EVENT_TYPE_CODE AND XGT.EVENT_ID = XE.EVENT_ID
AND XET.APPLICATION_ID = 200 AND XET_REL.APPLICATION_ID = 200
AND XE.APPLICATION_ID = 200 AND APH.POSTED_FLAG = 'S' AND NOT EXISTS
( SELECT 'reversed event'
FROM AP_PAYMENT_HISTORY_ALL APH_REV
WHERE NVL(APH_REV.RELATED_EVENT_ID, APH_REV.ACCOUNTING_EVENT_ID) =
NVL(APH.RELATED_EVENT_ID, APH.ACCOUNTING_EVENT_ID)
AND APH_REV.REV_PMT_HIST_ID IS NOT NULL)
UNION
SELECT MAX(APPH.ACCOUNTING_EVENT_ID) ACCOUNTING_EVENT_ID
FROM AP_PREPAY_HISTORY_ALL APPH, XLA_EVENTS_GT XGT
WHERE XGT.EVENT_ID = APPH.ACCOUNTING_EVENT_ID
AND APPH.POSTED_FLAG = 'S' AND APPH.INVOICE_ID = :B2
AND APPH.INVOICE_ADJUSTMENT_EVENT_ID IS NOT NULL
AND NOT EXISTS
( SELECT 'reversed event'
FROM AP_INVOICE_DISTRIBUTIONS_ALL AID_REL
WHERE AID_REL.INVOICE_ID = APPH.INVOICE_ID
AND AID_REL.ACCOUNTING_EVENT_ID = APPH.RELATED_PREPAY_APP_EVENT_ID
AND AID_REL.REVERSAL_FLAG = 'Y'))

 

 

 

 

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
Cause
Solution


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