GP AM Facing Error while Migrating Absence Package from 9.0 To 9.2 (Doc ID 1982829.1)

Last updated on FEBRUARY 25, 2015

Applies to:

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

Goal

We are facing an error while migrating non-rule package of a Country from PeopleSoft 9.0 to PeopleSoft 9.2.
PFB error :-

Importing GP_ABS_SS_CNTRY
File: Data MoverSQL error. Stmt #: 0 Error Position: 0 Return: 1400 - ORA-01400: cannot insert NULL into ("SYSADM"."PS_GP_ABS_SS_CNTRY"."ALLOW_TIME_ENTRY")
Failed SQL stmt: INSERT INTO PS_GP_ABS_SS_CNTRY (COUNTRY, EFFDT, EFF_STATUS, ENTLMNT_ACCRUAL_PD, ACC_FROM_DATE_FLAG, ACC_TO_DATE_FLAG, TAKE_UK1_FLAG, TAKE_UK2_FLAG, TAKE_UK3_FLAG, TAKE_UK4_FLAG, TAKE_UK5_FLAG, TAKE_UK6_FLAG, LEAVE_HIST_IND, DFLT_HIST_DT_FLAG, DAYS_BEFORE, DAYS_AFTER, REQUESTED_BY_FLAG, DURATION_FLAG, FCST_BAL_FLAG, FCST_REQ_FLAG, FCST_FROM_DT_FLAG, FCST_TO_DT_FLAG, FCST_UK1_FLAG, FCST_UK2_FLAG, FCST_UK3_FLAG, FCST_UK4_FLAG, FCST_UK5_FLAG, FCST_UK6_FLAG, DELETE_OPTN) VALUES (:1, TO_DATE(:2,'YYYY-MM-DD'), :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29)
Error: SQL unable to commit transaction for GP_ABS_SS_CNTRY
Ended: Tue Feb 03 11:51:04 2015
Unsuccessful completion
 

Solution

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