E-UPD: Can Tax Updates be combined while creating a Change Package from the PUM image? (Doc ID 1957512.1)

Last updated on JANUARY 16, 2015

Applies to:

PeopleSoft Enterprise HRMS Payroll for North America - Version 9.2 and later
Information in this document applies to any platform.
Error while applying Tax Updates 13-A thru 13-F to HCM 9.2

Records remaining: 196
Importing TAXGR_DEFN_TBL
Message Set Number: 200
Message Number: 0
Message Reason: File: Data MoverSQL error. Stmt #: 0 Error Position: 67 Return: 904 - ORA-00904: "PY_MAINT_SOURCE": invalid identifier

Failed SQL stmt: INSERT INTO PS_TAXGR_DEFN_TBL (STATE, LOCALITY, EFFDT, EFF_STATUS, PY_MAINT_SOURCE) VALUES (:1, :2, TO_DATE(:3,'YYYY-MM-DD'), :4, :5) (200,0)
SQL Error. Error Position: 67 Return: 904 - ORA-00904: "PY_MAINT_SOURCE": invalid identifier
INSERT INTO PS_TAXGR_DEFN_TBL (STATE, LOCALITY, EFFDT, EFF_STATUS, PY_MAINT_SOURCE) VALUES (:1, :2, TO_DATE(:3,'YYYY-MM-DD'), :4, :5)
Error: Unable to insert row 1
Error: SQL execute error for TAXGR_DEFN_TBL
Ended: Fri Dec 26 11:21:57 2014
Unsuccessful completion

Goal

 Can multiple tax updates existing in PUM image be combined in a single Change Package to be applied to down-stream environments? (Example 13A through 13F)

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