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 laterInformation 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:
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
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:
- Apply 12.2.9 or HR_PF.C RUP13.
- Skip the failed job (AD_ZD_TABLE_APPLY.sql)
- Payroll tables that have new #1 columns are not updated
- Re-apply the patch or load AD_ZD_TABLE_APPLY.sql manually.
- 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 |