My Oracle Support Banner

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

 

 

Steps to Reproduce:

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

  1.  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)

  2.  Apply hrglobal (Doc ID: 1469456.1).

  3.  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


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