I-9 Receipt Expiration Report fails after applying Patch 26520001 ORA-12899: value too large for column

(Doc ID 2303539.1)

Last updated on SEPTEMBER 18, 2017

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.

Symptoms

HR_I9_VERIFY failing after patch 26520001 V9.1: FORM I9: 2017 USCIS REVISIONS  

After the Application of Bug Fix 26520001: The I-9 Receipt Expiration Report Fails with an Error .When the length of the Document Title in Sections B and/or C is more than 30 Characters In Length  the process fails because the length xlatlongname field is 30.

 Users should be able to run the I-9 Receipt Expiration Report without any errors


ERROR
-----------------------
ORA-12899: value too large for column "SYSADM"."PS_HR_I9_VRF_TAO"."XLATLONGNAME" (actual: 40, maximum: 30).

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

1. Apply Bug Fix 26520001

2. Navigate to Workforce Administration, Personal Information > Form I-9 > I-9 Receipt Expiration Report. Enter from and thru dates and then click on the Run button.

3. Note the process runs to “No Success”

4. Checking on Status the error is shown:  Stmt #: 1708  Error Position: 227  Return: 12899 - ORA-12899: value too large for column "SYSADM"."PS_HR_I9_VRF_TAO"."XLATLONGNAME"
(actual: 38, maximum: 30)

Failed SQL stmt: INSERT INTO PS_HR_I9_VRF_TAO (PROCESS_INSTANCE ,EMPLID ,I9_EE_SIGN_DT ,XLATLONGNAME ,I9_DOC_TYPE ,SEQ_NO ,NAME ,COMPANY ,HIRE_DT ,I9_UPDATE_DOC_FLG ,I9_EXP_DOC_FLG ,I9_DOC_EXP_DT_A1 ) SELECT 3348003 ,A.EMPLID
,A.I9_EE_SIGN_DT ,B.I9_DOCTITLE_A ,'A' ,'1' ,A.NAME ,A.COMPANY ,A.HIRE_DT ,'N' ,'Y' ,A.I9_DOC_EXP_DT_A1 FROM PS_HR_I9_PERSON A , PS_I9_IAUTH_A_VW B WHERE A.COMPANY LIKE '%' AND A.I9_REVERIFIED_DT IS NULL AND A.I9_DOC_EXP_DT_A1 >= TO_DATE('2017-08-01','YYYY-MM-DD') AND A.I9_DOC_EXP_DT_A1 <= TO_DATE('2017-08-31','YYYY-MM-DD') AND A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_HR_I9_PERSON A1 WHERE A.EMPLID =
A1.EMPLID AND A1.EFFDT <= TO_DATE(TO_CHAR(SYSDATE,'YYYY-MM-DD'),'YYYY-MM-DD')) AND A.I9_DOC_TITLE_A =B.I9_DOC_TITLE_A



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