My Oracle Support Banner

Hrglobal Fails with ORA-20001: Only one balance in a legislation can be the 'Remuneration' balance (Doc ID 2752379.1)

Last updated on FEBRUARY 16, 2021

Applies to:

Oracle Payroll - Version 12.1 and later
Information in this document applies to any platform.

Symptoms

Problem Statement:

When attempting to apply hrglobal, following error occurs.

Error loading seed data for PAY_BALANCE_TYPES: BALANCE_NAME = <BALANCE_NAME>, BUSINESS_GROUP_NAME = , LEGISLATION_CODE = <LEGISLATION_CODE>, ORA-20001: Only one balance in a legislation can be the 'Remuneration' balance

Sample error message:

Uploading from the data file /xxx/fs1/EBSapps/appl/pay/12.0.0/patch/115/import/US/loc_jp/pyjpbal.ldt
Altering database NLS_LANGUAGE environment to AMERICAN
Dumping from LCT/LDT files (/xxx/fs1/EBSapps/appl/pay/12.0.0/patch/115/import/pyseedbal.lct(120.6.12020000.7), /xxx/fs1/EBSapps/appl/pay/12.0.0/patch/115/import/US/loc_jp/pyjpbal.ldt) to staging tables
Dumping LCT file /xxx/fs1/EBSapps/appl/pay/12.0.0/patch/115/import/pyseedbal.lct(120.6.12020000.7) into FND_SEED_STAGE_CONFIG
Dumping LDT file /xxx/fs1/EBSapps/appl/pay/12.0.0/patch/115/import/US/loc_jp/pyjpbal.ldt into FND_SEED_STAGE_ENTITY
Dumped the batch (PAY_BALANCE_TYPES B_BON_AMT_AFTER_SI_PREM_DCT JP , PAY_BALANCE_TYPES B_YEA_WITHHOLD_ITX JP ) into FND_SEED_STAGE_ENTITY
Uploading from staging tables
Error loading seed data for PAY_BALANCE_TYPES: BALANCE_NAME = B_NET_PAY, BUSINESS_GROUP_NAME = , LEGISLATION_CODE = JP, ORA-20001: Only one balance in a legislation can be the 'Remuneration' balance

 

Steps to Reproduce:

The issue can be reproduced at will with the following steps:

  1.  Apply hrglobal.drv
  2.  Worker job fails loading ldt file



Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.