ETL9.1 TL_PAY_REVRS Failed After Bundle8 With Error - Value Larger Than Specified Precision Allowed. (Doc ID 1439020.1)

Last updated on MARCH 08, 2016

Applies to:

PeopleSoft Enterprise HRMS Time and Labor - Version 9.1 and later
Information in this document applies to any platform.
*** Checked for relevance on 21-Mar-2012 ***


Symptoms

After 9.1 Bundle 8 were applied, the TL_PAY_REVRS program failed with the error:
Stmt #: 1625 Error Position: 883 Return: 1438 - ORA-01438: value larger than specified precision allowed for this column

ENVIRONMENT
----------------------
PeopleSoft HCM 9.1 Bundle #8

ERROR
------------
File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1625 Error Position: 883 Return: 1438 - ORA-01438: value larger than specified precision allowed for this column
Failed SQL stmt:INSERT INTO PS_TL_TA_PAYW_TM4 (PROCESS_INSTANCE, EMPLID, EMPL_RCD, DUR, SEQ_NBR, TASKGROUP, SHIFT_ID, TRC, TL_QUANTITY, CURRENCY_CD, COUNTRY, STATE, LOCALITY, COMP_RATECD, BILLABLE_IND, OVERRIDE_RATE, EST_GROSS, LBR_DIST_AMT, DILUTED_GROSS, CURRENCY_CD2, PAYABLE_STATUS, PAY_SYSTEM, PAYROLL_REQ_NUM, FROZEN_SW, FROZEN_DATE, RECORD_ONLY_ADJ, PUBLISH_SW, ACTUAL_PUB_DATE, OPRID, APPRV_PRCS_DTTM, SOURCE_IND, ORIG_SEQ_NBR, COMPANY, BUSINESS_UNIT, SETID_LOCATION, LOCATION, SETID_DEPT, DEPTID, SETID_JOBCODE, JOBCODE, POSITION_NBR, PRODUCT, CUSTOMER, ACCT_CD, BUSINESS_UNIT_PC, BUSINESS_UNIT_PF, PROJECT_ID, SETID_ACTIVITY, ACTIVITY_ID, RESOURCE_TYPE, SETID_RESOURCE, RESOURCE_CATEGORY, RESOURCE_SUB_CAT, TASK, USER_FIELD_1, USER_FIELD_2, USER_FIELD_3, USER_FIELD_4, USER_FIELD_5, INITIAL_SEQ_NBR, IN_BATCH, TL_RULE_ID, RT_SOURCE) SELECT 1636152 , A.EMPLID, A.EMPL_RCD, A.DUR, A.SEQ_NBR + 482240000000 , A.TASKGROUP, ' ' , A.TRC, A.TL_QUANTITY, A.CURRENCY_CD, A.COUNTRY, A.STATE, A.LOCALITY, A.COMP_RATECD, A.BILLABLE_IND, A.OVERRIDE_RATE, A.EST_GROSS, 0 , 0 , ' ', A.PAYABLE_STATUS, case when A.PAY_SYSTEM_FLG = 'NA' THEN A.PAY_SYSTEM_FLG ELSE ' ' END, 0 , 'N' , TO_DATE(TO_CHAR(SYSDATE,'YYYY-MM-DD'),'YYYY-MM-DD') , 'N' , ' ' , TO_DATE('1900-01-01','YYYY-MM-DD') , ' ' , TO_TIMESTAMP('1900-01-01-','YYYY-MM-DD-HH24.MI.SS.FF') , 'S' , case when A.PAYABLE_STATUS = 'RV' THEN A.ORIG_SEQ_NBR ELSE 0 END, A.COMPANY, A.BUSINESS_UNIT, A.SETID_LOCATION, A.LOCATION, A.SETID_DEPT, A.DEPTID, A.SETID_JOBCODE, A.JOBCODE, A.POSITION_NBR, A.PRODUCT, A.CUSTOMER, A.ACCT_CD, A.BUSINESS_UNIT_PC, A.BUSINESS_UNIT_PF, A.PROJECT_ID, A.SETID_ACTIVITY, A.ACTIVITY_ID, A.RESOURCE_TYPE, A.SETID_RESOURCE, A.RESOURCE_CATEGORY, A.RESOURCE_SUB_CAT, A.TASK, A.USER_FIELD_1, A.USER_FIELD_2, A.USER_FIELD_3, A.USER_FIELD_4, A.USER_FIELD_5, A.INITIAL_SEQ_NBR, A.IN_BATCH, A.TL_RULE_ID, A.RT_SOURCE FROM PS_TL_IPT14 A WHERE A.PROCESS_INSTANCE = 1636152 AND (A.OFFDAY_IND <> 'Y' AND A.RT_SOURCE <> 'AM' OR A.RT_SOURCE = 'AM') AND A.TRC <> ' ' AND A.IN_BATCH = 'Y' AND NOT EXISTS ( SELECT 'X' FROM PS_TL_EXCEPTION X , PS_TL_EXCEPT_DEFN D WHERE X.EMPLID = A.EMPLID AND X.EMPL_RCD = A.EMPL_RCD AND X.DUR = A.DUR AND X.EXCEPTION_STATUS = 'U' AND D.EXCEPTION_ID = X.EXCEPTION_ID AND D.EFFDT=( SELECT MAX(D1.EFFDT) FROM PS_TL_EXCEPT_DEFN D1 WHERE D1.EXCEPTION_ID = X.EXCEPTION_ID AND D1.EFFDT <= A.DUR) AND D.SEVERITY = 'H') AND NOT EXISTS ( SELECT 'X' FROM PS_TL_TA_RUL_OVR B WHERE B.PROCESS_INSTANCE = A.PROCESS_INSTANCE AND B.EMPLID = A.EMPLID AND B.EMPL_RCD = A.EMPL_RCD AND B.DUR = A.DUR)

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