ERS9.2: Error "Process XXX ABENDED at Step RS_CACHE_AD.MAIN.ResDate (PeopleCode) -- RC = 24 (108,524)" Received While Running RS_CACHE_AD AE Program When Standard Hours = 1 In Update Employee Data
(Doc ID 3040579.1)
Last updated on AUGUST 12, 2024
Applies to:
PeopleSoft Enterprise FIN Resource Management - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
Symptoms
When attempting to run RS_CACHE_AD AE Program, the following error occurs.
File: /vob/peopletools/src/pspcm/pcmobuf.cppSQL error. Stmt #: 6812 Error Position: 0 Return: 604 - ORA-00604: error occurred at recursive SQL level 1 ORA-01013: user requested cancel of current operation
Failed SQL stmt: INSERT INTO PS_RS_WORNGE_TAO (PROCESS_INSTANCE,EMPLID,EFFDT_FROM,EFFDT_TO,EMPL_STATUS,STD_DAY_PERCENT) VALUES (:1,:2,TO_DATE(:3,'YYYY-MM-DD'),TO_DATE(:4,'YYYY-MM-DD'),:5,:6)
SQL error. Function: Record.Insert
Error Position: 0
Return: 604 - ORA-00604: error occurred at recursive SQL level 1 ORA-01013: user requested cancel of current operation
Statement: INSERT INTO PS_RS_WORNGE_TAO (PROCESS_INSTANCE,EMPLID,EFFDT_FROM,EFFDT_TO,EMPL_STATUS,STD_DAY_PERCENT) VALUES (:1,:2,TO_DATE(:3,'YYYY-MM-DD'),TO_DATE(:4,'YYYY-MM-DD'),:5,:6)
Original Statement: %Insert(:1)
Fatal SQL error occurred. (2,125) FUNCLIB_RS.DETERMINE_FIT.FieldFormula Name:CalcResRange PCPC:21579 Statement:390
Called from:FUNCLIB_RS.DETERMINE_FIT.FieldFormula Name:SetupResourceStandWorkDays Statement:586
Called from:FUNCLIB_RS.DETERMINE_FIT.FieldFormula Name:BuildEmployeeCacheForScheduledTask Statement:745
Called from:FUNCLIB_RS.DETERMINE_FIT.FieldFormula Name:UpdateOptCalendar Statement:822
Called from:RS_CACHE_AD.MAIN.GBL.default.1900-01-01.ResDate.OnExecute Statement:6
Process 20758379 ABENDED at Step RS_CACHE_AD.MAIN.ResDate (PeopleCode) -- RC = 24 (108,524)
Failed SQL stmt: INSERT INTO PS_RS_WORNGE_TAO (PROCESS_INSTANCE,EMPLID,EFFDT_FROM,EFFDT_TO,EMPL_STATUS,STD_DAY_PERCENT) VALUES (:1,:2,TO_DATE(:3,'YYYY-MM-DD'),TO_DATE(:4,'YYYY-MM-DD'),:5,:6)
SQL error. Function: Record.Insert
Error Position: 0
Return: 604 - ORA-00604: error occurred at recursive SQL level 1 ORA-01013: user requested cancel of current operation
Statement: INSERT INTO PS_RS_WORNGE_TAO (PROCESS_INSTANCE,EMPLID,EFFDT_FROM,EFFDT_TO,EMPL_STATUS,STD_DAY_PERCENT) VALUES (:1,:2,TO_DATE(:3,'YYYY-MM-DD'),TO_DATE(:4,'YYYY-MM-DD'),:5,:6)
Original Statement: %Insert(:1)
Fatal SQL error occurred. (2,125) FUNCLIB_RS.DETERMINE_FIT.FieldFormula Name:CalcResRange PCPC:21579 Statement:390
Called from:FUNCLIB_RS.DETERMINE_FIT.FieldFormula Name:SetupResourceStandWorkDays Statement:586
Called from:FUNCLIB_RS.DETERMINE_FIT.FieldFormula Name:BuildEmployeeCacheForScheduledTask Statement:745
Called from:FUNCLIB_RS.DETERMINE_FIT.FieldFormula Name:UpdateOptCalendar Statement:822
Called from:RS_CACHE_AD.MAIN.GBL.default.1900-01-01.ResDate.OnExecute Statement:6
Process 20758379 ABENDED at Step RS_CACHE_AD.MAIN.ResDate (PeopleCode) -- RC = 24 (108,524)
Steps:
1.- Log into the FSCM Online Application as a Resource Management User
2.- Navigate to: Set Up Financials/Supply Chain > Common Definitions > Resource Search > Setup RM Cache Administration
3.- Create a new Run Control ID with all needed criteria
4.- Launch the RS_CACHE_AD AE Program
5.- Confirm that the RS_CACHE_AD AE Program has abended in Error Message
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |