My Oracle Support Banner

Hrglobal Failed Loading paygbbalfeed.ldt and/or pergbfrr.ldt with ORA-20001 Error (Doc ID 2640704.1)

Last updated on FEBRUARY 24, 2020

Applies to:

Oracle HRMS (UK) - Version 12.2 and later
Information in this document applies to any platform.
This note provides a brief overview of .

Symptoms

Problem Statement:

Hrglobal fails loading paygbbalfeed.ldt and/or pergbfrr.ldt.

Uploading from the data file
/XXX/pay/12.0.0/patch/115/import/US/loc_gb/paygbbalfeed.ldt Altering database NLS_LANGUAGE environment to AMERICAN
Dumping from LCT/LDT files (/XXX/pay/12.0.0/patch/115/import/pyseedbf.lct(120.5.12020000.10), /XXX/pay/12.0.0/patch/115/import/US/loc_gb/paygbbalfeed.ldt) to staging tables
Dumping LCT file /XXX/pay/12.0.0/patch/115/import/pyseedbf.lct(120.5.12020000.10) into FND_SEED_STAGE_CONFIG
Dumping LDT file /XXX/pay/12.0.0/patch/115/import/US/loc_gb/paygbbalfeed.ldt into FND_SEED_STAGE_ENTITY
Dumped the batch (PAY_BALANCE_FEEDS_F NI Employer for Off Payroll Worker NI Employer for Off Payroll Worker , PAY_BALANCE_FEEDS_F Working Tax Credit
Working Tax Credit Pay Value GB 0001/01/01 2006/04/05 ) into FND_SEED_STAGE_ENTITY
Uploading from staging tables
  Error loading seed data for PAY_BALANCE_FEEDS_F: BALANCE_NAME = Real Time Class 1A NICs, ELEMENT_NAME = Real Time Class 1A NICs, INPUT_VALUE_NAME = Pay
Value, BUSINESS_GROUP_NAME = , LEGISLATION_CODE = GB, EFFECTIVE_START_DATE = 2020/04/06, EFFECTIVE_END_DATE = 4712/12/31,
ORA-20001: System Error: Procedure INPUT_VALUE_NAME at Step Find

Cause: The procedure INPUT_VALUE_NAME has created an error at Step Find.

Action: Contact your system administrator quoting the procedure
INPUT_VALUE_NAME and Step Find.

 

Uploading from the data file
/XXX/per/12.0.0/patch/115/import/US/loc_gb/pergbfrr.ldt
Altering database NLS_LANGUAGE environment to AMERICAN
Dumping from LCT/LDT files
(/XXX/pay/12.0.0/patch/115/import/pyseedfrr.lct(120.4.12020000.9), /XXX/per/12.0.0/patch/115/import/US/loc_gb/pergbfrr.ldt) to staging tables
Dumping LCT file /XXX/pay/12.0.0/patch/115/import/pyseedfrr.lct(120.4.12020000.9) into FND_SEED_STAGE_CONFIG
Dumping LDT file /XXX/per/12.0.0/patch/115/import/US/loc_gb/pergbfrr.ldt into FND_SEED_STAGE_ENTITY
Dumped the batch (PAY_STATUS_PROCESSING_RULES_F Advance Clearup GB 0001/01/01 4712/12/31 P , PAY_FORMULA_RESULT_RULES_F Working Tax Credit GB
2003/04/06 2006/04/05 P V_MESS_STOP ) into FND_SEED_STAGE_ENTITY
Uploading from staging tables
  Error loading seed data for PAY_FORMULA_RESULT_RULES_F: ELEMENT_NAME = Real Time Class 1A NICs, ASSIGNMENT_STATUS_TYPE = , BUSINESS_GROUP_NAME = , LEGISLATION_CODE = GB, EFFECTIVE_START_DATE = 2020/04/06, EFFECTIVE_END_DATE = 4712/12/31,
PROCESSING_RULE = P, SPR_ELEMENT_NAME = Real Time Class 1A
NICs, SPR_ASSIGNMENT_STATUS_TYPE = , BUSINESS_GROUP_NAME = , LEGISLATION_CODE = GB, EFFECTIVE_START_DATE = 2020/04/06, EFFECTIVE_END_DATE = 4712/12/31,
SPR_PROCESSING_RULE = P,
RESULT_NAME = L_CLASS_1A_DEDUC, ELEMENT_NAME = Real Time Class 1A NICs, INPUT_NAME = Pay Value, ORA-20001:PAY_34159_FRR_INPUT_VALUE_REQD:

 

Steps to Reproduce:

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

  1.  Apply patch:30855835(TYE20: FINAL PATCH FOR TAX YEAR END CHANGES 2019-20)
  2.  Run DataInstall/hrglobal for GB legislation
  3.  Worker job fails loading paygbbalfeed.ldt and pergbfrr.ldt.

 

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
References


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