Form Perwstem Error Ora-20001 Hz_sync_sql_excep When Clicking on Reverse Termination
Last updated on JANUARY 13, 2017
Applies to:Oracle Human Resources - Version 11.5.9 to 18.104.22.168 [Release 11.5 to 11.5.10]
Information in this document applies to any platform.
***Relevancy checked 28-Mar-2013***
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
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.
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