GPES: UPG Data Conversion Fails At Step UPG_GPES91.HCGESO02.Step01

(Doc ID 1926741.1)

Last updated on FEBRUARY 29, 2016

Applies to:

PeopleSoft Enterprise HCM Global Payroll Spain - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

On : 9.2 version, General

UPG data conversion fails at step UPG_GPES91.HCGESO02.Step01

We realized that new fields AFI_COLECT_FLG_ESP and AFI_COLLECTIVE_ESP are not being populated in sql insert/select at UPG_GPES91.HCGESO02.Step01. We need an urgent workaround / upg fix for that

ERROR
-----------------------
File: e:\pt85308b-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1623 Error Position: 0 Return: 1400 - ORA-01400: cannot insert NULL into ("HRPREP"."PS_WKF_CNT_AFI_ESP"."AFI_COLECT_FLG_ESP")


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run upgrade from 9.1 to 9.2
2. Execute the Conversion task 5-10-3
3. Got the error

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot move forward with the upgrade.

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