Hrglobal.drv error The INPUT_VALUE_ID Value Does Not Exist As Of The Effective Date (Doc ID 2151858.1)

Last updated on JUNE 21, 2016

Applies to:

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

Symptoms

On  : 12.1.3 Rup 8 version, Patch Application Issues

When attempting to Run Hrglobal.drv,
the following error occurs.

ERROR
-----------------------
Uploading from the data file /ebsappovsea/EBSOVSEA/apps/apps_st/appl/pay/12.0.0/patch/115/import/US/loc_sg/pysgbalfeed.ldt
Altering database NLS_LANGUAGE environment to AMERICAN
Dumping from LCT/LDT files (/ebsappovsea/EBSOVSEA/apps/apps_st/appl/pay/12.0.0/patch/115/import/pyseedbf.lct(120.0.12010000.10), /ebsappovsea/EBSOVSEA/apps/apps_st/appl/pay/12.0.0/patch/115/import/US/loc_sg/pysgbalfeed.ldt) to staging tables
Dumping LCT file /ebsappovsea/EBSOVSEA/apps/apps_st/appl/pay/12.0.0/patch/115/import/pyseedbf.lct(120.0.12010000.10) into FND_SEED_STAGE_CONFIG
Dumping LDT file /ebsappovsea/EBSOVSEA/apps/apps_st/appl/pay/12.0.0/patch/115/import/US/loc_sg/pysgbalfeed.ldt into FND_SEED_STAGE_ENTITY
Dumped the batch (PAY_BALANCE_FEEDS_F Additional Earnings Ineligible For CPF Calc Earnings ineligible for CPF , PAY_BALANCE_FEEDS_F Saver Premium Amount Saver Premium Contribution Pay Value SG 2002/10/01 ) into FND_SEED_STAGE_ENTITY
Uploading from staging tables
 Error loading seed data for PAY_BALANCE_FEEDS_F: BALANCE_NAME = IR21_E6, ELEMENT_NAME = CDAC Community Fund, INPUT_VALUE_NAME = Pay Value, BUSINESS_GROUP_NAME = , LEGISLATION_CODE = SG, EFFECTIVE_START_DATE = 0001/01/01, EFFECTIVE_END_DATE = 4712/12/31, ORA-20001: Invalid ID

The INPUT_VALUE_ID value does not exist as of the effective date.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Apply R12.1 HRMS Rup 8
2. Apply Datainstall for Global and SG
3. Run Hrglobal.drv

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