Project Costing > Utilities > Copy Project --- PC_CPY_AELIB ABENDED at Step PC_CPY_AELIB.UptPdTbl.Step01 (SQL) -- RC = 805 (108,524)

(Doc ID 2323884.1)

Last updated on NOVEMBER 13, 2017

Applies to:

PeopleSoft Enterprise FIN Project Costing - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

On : 9.2 version, Projects Utilities

Project Costing > Utilities > Copy Project --- Project Manager effdt rows sql error

When there are more than 1 effdt rows to copy for project_mgr the application issue a unique constraint error.

ERROR
-----------------------
Message 1 : A SQL error occurred. Please consult your system log for details.
Message 2: Process 28717 ABENDED at Step PC_CPY_AELIB.UptPdTbl.Step01 (SQL) -- RC = 805 (108,524)
Message 3: CallAppEngine: Application PC_COPY_AE: AppEngine error. (2,653) FUNCLIB_PC.FUNCLIB_PR.FieldFormula Name:Project_Copy PCPC:13167 Statement:228
Called from:PC_CPY_PROJ_WRK.TEMPLATE_COPY.FieldChange Statement:55

During a CallAppEngine builtin function call, the Application Engine detected an error. The Application Engine log may provide more information.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a Project with project start date as 1/22/2017 and end date of 2/22/2017. Say Proj1 in US004 in demo
2. Add resource to the project KU0006 and check him as project manager for the duration 1/22/2017 till 1/31/2017
3. Add another resource to the project KU0042 and check him as project manager for the duration 2/1/2017 till 2/22/2017
4. Using navigation Project Costing > Utilities > Copy Project, try to copy this project. The above error messages are received.

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