Hrglobal Failed Loading paygbbalfeed.ldt and/or pergbfrr.ldt with ORA-20001 Error
(Doc ID 2640704.1)
Last updated on OCTOBER 22, 2023
Applies to:
Oracle HRMS (UK) - Version 12.2 and laterInformation 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
/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:
/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:
- Apply patch:30855835(TYE20: FINAL PATCH FOR TAX YEAR END CHANGES 2019-20)
- Run DataInstall/hrglobal for GB legislation
- 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 |