Deploy Patch .22516105:R12.PER.B Error When Applying Hrglobal.drv (Doc ID 2111906.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle HRMS (Singapore) - Version 12.1.3 and later
Information in this document applies to any platform.

Goal

 On : 12.1 HRMS RUP8 version,
Test environment

After applying patch .22516105:R12.PER.B Error hrglobal.drv fails.

ERROR
-----------------------
Uploading from staging tables
Error loading seed data for PAY_USER_COLUMN_INSTANCES_F: B_USER_TABLE_NAME = CPF_SCHEDULE_1, B_LEGISLATION_CODE = SG, B_USER_COLUMN_NAME = AGE11_EE_A, B_LEGISLATION_CODE = SG, ORA-01422: exact fetch returns more than requested number of rows
Error loading seed data for PAY_USER_COLUMN_INSTANCES_F: B_USER_TABLE_NAME = CPF_SCHEDULE_10, B_LEGISLATION_CODE = SG, B_USER_COLUMN_NAME = AGE11_EE_A, B_LEGISLATION_CODE = SG, ORA-01422: exact fetch returns more than requested number of rows

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run HRGLOBAL

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