My Oracle Support Banner

ORA-01407: cannot update ("HR"."<TABLE_NAME>"."<COLUMN_NAME>#1") to NULL (Doc ID 2714293.1)

Last updated on FEBRUARY 10, 2022

Applies to:

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

Symptoms

Problem Statement:

Skipping failed job (AD_ZD_TABLE_APPLY.sql) when applying 12.2.9 or HR_PF.C RUP13 caused the partial update in the tables (e.g. pay_assignment_actions, pay_population_ranges, pay_payroll_actions). Some of the #1 columns(e.g. PAY_PAYROLL_ACTIONS#1) are not populated and having the value -1 and some of the records have null old columns (e.g.PAY_PAYROLL_ACTIONS).
When re-applying the patch or loading AD_ZD_TABLE_APPLY.sql manually, ORA-01407 error occurs.

 

Example:

ERROR at line 1:
ORA-20001: Could not apply crossedition trigger
"APPS"."PAY_ASSIGNMENT_ACTIONS_F1": ORA-20001: Parallel update task failed:
"PAY_ASSIGNMENT_ACTIONS_F1" status=8 Error: ORA-01407: cannot update
("HR"."PAY_ASSIGNMENT_ACTIONS"."PAYROLL_ACTION_ID#1") to NULL
ORA-06512: at "APPS.AD_ZD", line 26
ORA-06512: at "APPS.AD_ZD_TABLE", line 19
ORA-06512: at "APPS.AD_ZD_TABLE", line 1787
ORA-06512: at line 1
ERROR at line 1:
ORA-20001: Could not apply crossedition trigger
"APPS"."PAY_POPULATION_RANGES_F1": ORA-20001: Parallel update task failed:
"PAY_POPULATION_RANGES_F1" status=8 Error: ORA-01407: cannot update
("HR"."PAY_POPULATION_RANGES"."PAYROLL_ACTION_ID#1") to NULL
ORA-06512: at "APPS.AD_ZD", line 26
ORA-06512: at "APPS.AD_ZD_TABLE", line 19
ORA-06512: at "APPS.AD_ZD_TABLE", line 1787
ORA-06512: at line 1

 

 

Steps to Reproduce:

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

  1. Apply 12.2.9 or HR_PF.C RUP13.
  2. Skip the failed job (AD_ZD_TABLE_APPLY.sql)
  3. Payroll tables that have new #1 columns are not updated
  4. Re-apply the patch or load AD_ZD_TABLE_APPLY.sql manually.
  5. Error occurs

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.