EPY: HCM 9.0 Bundle 17 ORA-01400: cannot insert NULL into ("SYSADM"."PS_TAXGR_DEFN_TBL"."PY_MAINT_SOURCE") (Doc ID 1986039.1)

Last updated on OCTOBER 06, 2015

Applies to:

PeopleSoft Enterprise HCM Payroll for North America - Version 9 and later
PeopleSoft Enterprise HCM Human Resources - Version 9 and later
Information in this document applies to any platform.

Symptoms

HCM 9.0/8.51.16 version, Applying Bundle #17 and current on tax updates through 15-A

When attempting to run bn862987_01.dms through Change Assistant,
the following error occurs.

ERROR
-----------------------
Importing TAXGR_DEFN_TBL

 Message Set Number: 200
 Message Number: 0
 Message Reason: File: Data MoverSQL error. Stmt #: 0 Error Position: 0 Return: 1400 - ORA-01400: cannot insert NULL into ("SYSADM"."PS_TAXGR_DEFN_TBL"."PY_MAINT_SOURCE")
Failed SQL stmt:INSERT INTO PS_TAXGR_DEFN_TBL (STATE, LOCALITY, EFFDT, EFF_STATUS) VALUES (:1, :2, TO_DATE(:3,'YYYY-MM-DD'), :4) (200,0)
SQL Error. Error Position: 0 Return: 1400 - ORA-01400: cannot insert NULL into ("SYSADM"."PS_TAXGR_DEFN_TBL"."PY_MAINT_SOURCE")

INSERT INTO PS_TAXGR_DEFN_TBL (STATE, LOCALITY, EFFDT, EFF_STATUS) VALUES (:1, :2, TO_DATE(:3,'YYYY-MM-DD'), :4)

SQL Error. Error Position: 0 Return: 0 -

Error: SQL unable to commit transaction for TAXGR_DEFN_TBL

Ended: Wed Feb 25 19:17:41 2015

Unsuccessful completion

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