Hrglobal Fails Loading perleggb.sql with ORA-01400: cannot insert NULL into ("HR"."PAY_RETRO_COMPONENT_USAGES"."RETRO_COMPONENT_ID")
(Doc ID 2852408.1)
Last updated on APRIL 15, 2023
Applies to:
Oracle HRMS (UK) - Version 12.2 to 12.2 HRMS RUP15 [Release 12.2]Information in this document applies to any platform.
This note provides a brief overview of Bug:33747196.
Symptoms
Problem Statement:
Hrglobal fails loading perleggb.sql with the following error.
DECLARE
*
ERROR at line 1:
ORA-01400: cannot insert NULL into
("HR"."PAY_RETRO_COMPONENT_USAGES"."RETRO_COMPONENT_ID")
ORA-06512: at line 182
ORA-06512: at line 194
*
ERROR at line 1:
ORA-01400: cannot insert NULL into
("HR"."PAY_RETRO_COMPONENT_USAGES"."RETRO_COMPONENT_ID")
ORA-06512: at line 182
ORA-06512: at line 194
Steps to Reproduce:
The issue can be reproduced at will with the following steps:
- Apply patch that includes perleggb.sql 120.17.12020000.12.
e.g.
Patch:33738081 (TYE22: UK TAX YEAR END CHANGES FOR 2021-22 : FINAL PATCH)
Patch:33865829 (TYE22: IOM BUDGET CHANGES FOR 2022-23)
Patch:32713823 (TYE22:TYE EARLY ADOPTER CHANGES FOR 2021-22)
Patch:33717162 (TYE22: P11D LEGISLATIVE CHANGES FOR 2021-22) - Apply hrglobal (Doc ID: 1469456.1).
- Worker job fails loading perleggb.sql.
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 |