AFter Upgrading from Tools 8.49 Application Release 9.0 to Tools 8.51.13 Application Release 9.1 Onl
After upgrading our application, the online journal edit runs long and the screen will time out.
UPDATE PS_JRNL_LN SET JRNL_LINE_STATUS = '0' WHERE BUSINESS_UNIT = 'HNW' AND
PROCESS_INSTANCE = 1128950 AND LEDGER = 'ACTUALS' AND JRNL_LINE_STATUS =
'a' AND EXISTS ( SELECT 'X' FROM PS_COMB_EXP_TAO4 A, PS_COMB_EXP_TAO4 B
WHERE A.PROCESS_INSTANCE = 1128950 AND A.SETID = 'CORP' AND A.PROCESS_GROUP =
'HNW_ACT_CC' AND A.CHARTFIELD = 'ACCOUNT' AND PS_JRNL_LN.ACCOUNT =
A.RANGE_FROM_30 AND PS_JRNL_LN.JOURNAL_DATE BETWEEN A.EFFDT_FROM AND
The SQL causing the problem is as follows:
GL_JEDIT_0-- 15.49.27 .............(FS_CEDT_ECMB.ValLines.uValRule) (SQL)UPDATE PS_JRNL_LN SET JRNL_LINE_STATUS = '0' WHERE BUSINESS_UNIT = 'HNW' AND
PROCESS_INSTANCE = 1128950 AND LEDGER = 'ACTUALS' AND JRNL_LINE_STATUS =
'a' AND EXISTS ( SELECT 'X' FROM PS_COMB_EXP_TAO4 A, PS_COMB_EXP_TAO4 B
WHERE A.PROCESS_INSTANCE = 1128950 AND A.SETID = 'CORP' AND A.PROCESS_GROUP =
'HNW_ACT_CC' AND A.CHARTFIELD = 'ACCOUNT' AND PS_JRNL_LN.ACCOUNT =
A.RANGE_FROM_30 AND PS_JRNL_LN.JOURNAL_DATE BETWEEN A.EFFDT_FROM AND
0