ETL 9.2: TL_PG_STAGE Fails With "...Numeric Value Out Of Range" Error. (Doc ID 1634356.1)

Last updated on FEBRUARY 08, 2016

Applies to:

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

Symptoms

On : 9.2 version, Technical

When attempting to run the report Stage Data for Pivot Grids,
the following error occurs.

ERROR
-----------------------
File: E:\pt85308b-retail\peopletools\src\pspcm\pcmobuf.cppSQL error. Stmt #: 5574 Error Position: 0 Return: 8601 - [Microsoft][SQL Server Native Client 10.0]Numeric value out of range (SQLSTATE 22003) 0
Failed SQL stmt: INSERT INTO PS_TL_ABS_TEMP2 (EMPLID,EMPL_RCD,PIN_TAKE_NUM,BGN_DT,END_DT,SEQNO,BEGIN_DAY_HRS,BEGIN_DAY_HALF_IND,END_DAY_HRS,END_DAY_HALF_IND,ALL_DAYS_IND,OPRID,WF_STATUS,MANAGER_APPR_IND) VALUES (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14)

SQL error. Function: Record.Insert

  Error Position: 0

  Return: 8601 - [Microsoft][SQL Server Native Client 10.0]Numeric value out of range (SQLSTATE 22003) 0


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to Time & Labor>Reports>Interactive Reports>Stage Data for Pivot Grids
2. Got the error


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot run the report.

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