My Oracle Support Banner

ETL9.2 - PSARCHIVE Archiving Process Abends When Archiving TL_COMP_DAY_BAL Record (Doc ID 2553050.1)

Last updated on OCTOBER 18, 2019

Applies to:

PeopleSoft Enterprise HCM Time and Labor - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

On : 9.2 version, TL Installation and Setup

PSARCHIVE process errors when archiving TL_COMP_DAY_BAL record using the delivered "TL_CMPBA" template.

ERROR
-----------------------
SQL error. Function: SQL.Execute
  Error Position: 220
  Return: 1841 - ORA-01841: (full) year must be between -4713 and +9999, and not be 0
  Statement: insert into ps_tl_comp_day_hst (psarch_id,psarch_batchnum,emplid,empl_rcd,dur,trc,comp_time_plan,action,date_due,tl_quantity,end_bal,total_paid,taken_total) values (:1,:2,:3,:4,to_date(:5,'yyyy-mm-dd'),:6,:7,:8,to_date(:9,'YYYY-MM-DD'),:10,:11,:12,:13)
  Original Statement: %Insert(:1)

Fatal SQL error occurred. (2,125) PSARCHIVE.ROWBASED.GBL.default.1900-01-01.Step001.OnExecute PCPC:3099 Statement:51
Process 6743821 ABENDED at Step PSARCHIVE.ROWBASED.Step001 (PeopleCode) -- RC = 24 (108,524)
Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s


STEPS TO RECREATE ISSUE
-------------------------------
The issue can be reproduced at will with the following steps:
1. Enter the Following Run control parameters
  *Archive Template:"TL_CMPBA"
  Selective Criteria-TL_COMP_DAY_BAL
  Row Based Processing , Commit Freq - 200,000
  Audit Row Count
2. Run the process


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
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.