Form Perwstem Error Ora-20001 Hz_sync_sql_excep When Clicking on Reverse Termination (Doc ID 266951.1)

Last updated on JANUARY 13, 2017

Applies to:

Oracle Human Resources - Version 11.5.9 to 11.5.10.2 [Release 11.5 to 11.5.10]
Information in this document applies to any platform.
***Relevancy checked 28-Mar-2013***

Symptoms

While attempting to terminate, reverse terminate, or new hire, you receive the following error:

"APP-PER-289974: There has been an error processing this person. The error
encountered is 'ORA-200001:HZ_API_OTHERS_EXCEP:N, ERROR, ORA-6508: PL/SQL:
could not find program unit being called', which occurred in procedure
per_hrtca_merge.create_tca_person at step 5. Please contact your support
representative."

Changes

1) Ran "Workflow Background Process" concurrent program to end-date all
obsolete run-time data.
2) Ran script bde_wf_data.sql to determine the correct purge lines to run.
3) Ran "exec WF_PURGE.ITEMS('PAXWFHRU',,SYSDATE,FALSE,TRUE); COMMIT;
to purge data
4) Ran "alter table move tablespace applsysd" to reorg the workflow
tables that were affected by this purging.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms