My Oracle Support Banner

OTL Workflow for Employees Is Failing with Error ORA-20001 (Doc ID 182911.1)

Last updated on AUGUST 22, 2022

Applies to:

Oracle Time and Labor - Version 11.5.10 and later
Information in this document applies to any platform.


Running the Workflow Background Process for OTL Workflows for employees

Workflow for employees is failing with error

ORA-20001: System Error: Procedure hxc_find_notify_aprs_pkg.person_approval at Step 10Cause: The procedure hxc_find_notify_aprs_pkg.person_approval has created an error at Step 10.



 HXC_FIND_NOTIFY_APRS_PKG => hcafnawf.pkh hcafnawf.pkb Excerpt related to person_approval and Step 10

-- if null returned, approver does not have a self service login name, -- where does notification get sent?

-- if l_login is null then hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL'); hr_utility.set_message_token('PROCEDURE', l_proc); hr_utility.set_message_token('STEP', '10'); hr_utility.raise_error; end if;


To view full details, 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 a vibrant support community of peers and Oracle experts.