My Oracle Support Banner

PER_289974_TCA_PERSON error when applying patch 2564392 (Doc ID 386348.1)

Last updated on JUNE 10, 2021

Applies to:

Oracle Human Resources - Version 11.5.10.0 to 11.5.10.2 [Release 11.5.10]
Information in this document applies to any platform.

Symptoms

***This document was archived after the technical review process and has not been checked for grammar and spelling***

On 11.5.10 in Production:
After migration to 11.5.10.2, ct can't affect key member to project , he has the following error
msqg:
ORA -01400: cannot insert null into (applsys.fnd_grants.grantee_key)
ORA-06512 � apps.pa_project_parties_pub line 300


As per NOTE Note:311188.1, apply patch 2564392
but the patch failed
the following error occurs.

ERROR
sqlplus -s APPS/***** @/devora/devappl/per/11.5.0/patch/115/sql/perhrtca2.sql &un_apps &batchsize 1 4
begin
*
ERROR at line 1:
ORA-20001: PER_289974_TCA_PERSON: N, PROCEDURE,
per_hrtca_merge.create_tca_person, N, STEP, 5, N, ERROR, ORA-20001:
HZ_API_MISSING_COLUMN: N, COLUMN, party number
ORA-06512: at "APPS.FND_MESSAGE", line 332
ORA-06512: at "APPS.PER_HRTCA_MERGE", line 2531
ORA-06512: at "APPS.PER_HRTCA_MERGE", line 536
ORA-06512: at line 3


STEPS
The issue can be reproduced at will with the following steps:
1. apply patch 2564392



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.