My Oracle Support Banner

Sql Error In App Engine HRS_DA_APPLN (Doc ID 2434154.1)

Last updated on AUGUST 13, 2018

Applies to:

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

Symptoms

On : 9.2 version, Job / Personal Information

Application engine HRS_DA_APPLN is failing in step 05 because the field PS_NAMES.NAME_DISPLAY has a length of 50. the program is trying to insert into field PS_HRS_DAAPLN_STG2.MANAGER_NAME having a length of 30.


ERROR
-----------------------

File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1725 Error Position: 2584 Return: 12899 - ORA-12899: value too large for column "SYSADM"."PS_HRS_DIV_OV_STG2"."MANAGER_NAME" (actual: 31, maximum: 30)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Ensure that the manager of the Job Opening has a name longer than 30 characters.
2. Go to Careers as external applicant and apply for that job opening filling out the diversity information.
3. Run the Refresh Diversity Analytics report.
4. HRS_DA_APPLN application engine runs to No Success with the error above in the log file.



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!


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