GP: Unable to Run Non Rule Package Record Import due to SQL Error on INSERT INTO PS_GP_COUNTRY

(Doc ID 2043881.1)

Last updated on DECEMBER 16, 2015

Applies to:

PeopleSoft Enterprise HCM Global Payroll Core - Version 9.1 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Unable to run non-rule package Record Import due to SQL error on INSERT INTO PS_GP_COUNTRY.

An error is being generated when trying to Record Import a ‘Non Rule Package’ from the Configuration instance to Development instance.  On comparing the Record Export and Record Import files, it is seen that data is exported from GP_NRP_CNTRY_VW and imported into GP_COUNTRY.  GP_NRP_CNTRY_VW has 9 fields and GP_COUNTRY has 10 fields.  The only difference is the field GP_PYE_SOVR_OPTN,

The GP Update 2012-B up to 2015-B have been recently applied in both instances.  As part of GP Update 2015-A, the table GP_COUNTRY has a newly added field GP_PYE_SOVR_OPTN.
However GP_NRP_CNTRY_VW does not include the field GP_PYE_SOVR_OPTN.


STEPS
--------
The issue can be reproduced at will with the following steps:
1. Apply the Patch 17592420 (GLOBAL PAYROLL 9.1 UPDATE 2015-A).
2. Notice the error mentioned above.

Changes

Apply Patch 17592420.

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