E-AD: Application Designer Crashes when Building Large Projects (Doc ID 2011787.1)

Last updated on NOVEMBER 07, 2016

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.54 and later
Information in this document applies to any platform.

Symptoms

On : 8.54.08 version, Application Designer

Application Designer Crashes

When using the build and execute script option in application designer the program aborts and closes unexpectedly. The issue is most commonly observed with larger projects, i.e. over 1000 records.
The build logs all seem to have index errors like the one show below.

ERROR
-----------------------
Error: The handle is invalid.
Error: CA_ACCTG_LN_PC - SQL Error. Error Position: 53 Return: 1408 - ORA-01408: such column list already indexed
 CREATE INDEX PSACA_ACCTG_LN_PC ON PS_CA_ACCTG_LN_PC (PROCESS_INSTANCE, BUSINESS_UNIT_PC, PROJECT_ID, ACTIVITY_ID, ACCOUNT, DEPTID, PRODUCT, FUND_CODE, PROGRAM_CODE, BUDGET_REF, AFFILIATE, AFFILIATE_INTRA1, CHARTFIELD1) TABLESPACE PSINDEX STORAGE (INITIAL 40000 NEXT 100000 MAXEXTENTS UNLIMITED PCTINCREASE 0) PCTFREE 10 PARALLEL NOLOGGING


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Open a large project in Application Designer.
2. Build the records in the project selecting the build and execute script option.
3. The program aborts and closes unexpectedly.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot use the Build script and execute option in Application Designer.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms