HRGLOBAL.drv Failed with ORA-01422: Exact fetch returns more than requested number of row spegbfun.ldt (FUNCTION_NAME = GET_GLOBAL_VALUE) (Doc ID 1610836.1)

Last updated on JANUARY 10, 2017

Applies to:

Oracle HRMS (UK) - Version 12.1.3 and later
Information in this document applies to any platform.
Checked for currency 17th December 2015

Goal

HRglobal failed with the following :

/pnoi1i/applmgr/1200/admin/PNOI1I_BALANCE/log/loc_gb_pegbfun_ldt.log
====================================================================

Uploading from the data file /pnoi1i/applmgr/1200/per/12.0.0/patch/115/import/US/loc_gb/pegbfun.ldt
Altering database NLS_LANGUAGE environment to AMERICAN
Dumping from LCT/LDT files (/pnoi1i/applmgr/1200/ff/12.0.0/patch/115/import/fffunction.lct, /pnoi1i/applmgr/1200/per/12.0.0/patch/115/import/US/loc_gb/pegbfun.ldt) to staging tables
Dumping LCT file /pnoi1i/applmgr/1200/ff/12.0.0/patch/115/import/fffunction.lct into FND_SEED_STAGE_CONFIG
Dumping LDT file /pnoi1i/applmgr/1200/per/12.0.0/patch/115/import/US/loc_gb/pegbfun.ldt into FND_SEED_STAGE_ENTITY
Dumped the batch (FUNCTIONS GB CHECK_DESC_AND_SET_GLOBAL_VAR , FUNCTION_PARAMETERS 5 P_INT_MAX_AMT_OUTSTANDING ) into FND_SEED_STAGE_ENTITY
Uploading from staging tables
 Error loading seed data for FUNCTION_PARAMETERS: LEGISLATION_CODE = GB, FUNCTION_NAME = GET_GLOBAL_VALUE, SEQUENCE_NUMBER = 1, PARAMETER_NAME = P_GLOBAL_NAME, ORA-01422: exact fetch returns more than requested number of rows
 

 

Customer created values don't have a legislation_code but do have a business group id.

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