Setup Performance Issue: Open/Close Form (ARXSUMPS.fmb) has Performance Issues - Cannot Close AR Period
(Doc ID 783867.1)
Last updated on JUNE 14, 2018
Applies to:Oracle Receivables - Version 126.96.36.199 and later
Information in this document applies to any platform.
Form:ARXSUMPS.FMB - Open/Close Accounting Periods
When trying to close AR Period, the application hangs and period cannot be closed.
Responsibility: Receivables Manager
Navigation: Control > Accounting > Open/Close Periods
Review of TKPROF shows the following problematic statement:
DUAL WHERE EXISTS (SELECT /*+ ORDERED USE_NL(sys_org gld ct) */'x' FROM
(SELECT ORG_ID FROM AR_SYSTEM_PARAMETERS_ALL WHERE SET_OF_BOOKS_ID = :b1
AND ACCOUNTING_METHOD != 'CASH' ) SYS_ORG,RA_CUST_TRX_LINE_GL_DIST_ALL GLD,
RA_CUSTOMER_TRX_ALL CT WHERE GLD.ACCOUNT_CLASS = 'REC' AND
GLD.LATEST_REC_FLAG = 'Y' AND GLD.ACCOUNT_SET_FLAG = 'Y' AND GLD.GL_DATE
BETWEEN :b2 AND :b3 AND CT.CUSTOMER_TRX_ID = GLD.CUSTOMER_TRX_ID AND
CT.COMPLETE_FLAG = 'Y' AND :b4 = 'ACCRUAL' AND GLD.ORG_ID =
SYS_ORG.ORG_ID AND CT.ORG_ID = GLD.ORG_ID AND ROWNUM = 1 )
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!