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 220.127.116.11 to 18.104.22.168 [Release 11.5.10]
Information in this document applies to any platform.
***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 22.214.171.124, ct can't affect key member to project , he has the following error
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.
sqlplus -s APPS/***** @/devora/devappl/per/11.5.0/patch/115/sql/perhrtca2.sql &un_apps &batchsize 1 4
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
The issue can be reproduced at will with the following steps:
1. apply patch 2564392
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