PC_INTEREST ABENDED At Step PC_INTEREST.PROCESS.Step01 (SQL) -- RC = 805 (108,524)

(Doc ID 2332032.1)

Last updated on DECEMBER 04, 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, Batch

PC_INTEREST - ABENDED at Step PC_INTEREST.PROCESS.Step01 (SQL) -- RC = 805 (108,524)

When testing the PC_INTEREST process, ABENDED at Step PC_INTEREST.PROCESS.Step01 (SQL) -- RC = 805 (108,524)
Failed SQL stmt: INSERT INTO PS_PROJ_INT_BU_TMP.

This is unique constraint error

Attached are the log files.
I have reviewed the some docs with same error but different errors.

Please advise

ERROR
-----------------------
PC_INTEREST - ABENDED at Step PC_INTEREST.PROCESS.Step01 (SQL) -- RC = 805 (108,524)

When testing the PC_INTEREST process, ABENDED at Step PC_INTEREST.PROCESS.Step01 (SQL) -- RC = 805 (108,524)
Failed SQL stmt: INSERT INTO PS_PROJ_INT_BU_TMP.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

0. Define period Calculation Factor for 2016 and 2017 calendar years for monthly calendar 01.

Each period will have 2 rows

For example Period 1 of 2016 will have 2 rows

From date 01/01/1900 till 12/31/2015 Period Factor 1
From date 01/01/2016 till 1/31/2016 Period Factor 0.5

Period 2 of 2016 will have 2 rows

From date 01/01/1900 till 1/31/2016 Period Factor 1
From date 02/01/2016 till 2/29/2016 Period Factor 0.5

and so on for both 2016 and 2017 years.

2. Create a Project and Activity with Start and end date of 01/01/2015 till 12/31/2017. Allow Interest Calculation for the Project.
3. Have project Status to have Interest Calculation factor of 1. Since the effective date gets populated as system date. Inorder to mimic the issue update the dates to past date of 01/01/2015. So effective assuming this project was created on 1/1/2015
4. Add a transaction for $1000 with transaction and accounting date as 19 Jul 2016.
5. Run PC_INTEREST for Fiscal year 2016/period 1 through Fiscal year 2017/period 12.
6. The process abends with the above error.

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