My Oracle Support Banner

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

Last updated on JULY 02, 2019

Applies to:

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

Symptoms

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.

 

Changes

 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;

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!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.