OTL Workflow for Employees Is Failing with Error ORA-20001

(Doc ID 182911.1)

Last updated on AUGUST 25, 2017

Applies to:

Oracle Time and Labor - Version 11.5.10 to 12.2.1 [Release 11.5 to 12.2]
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

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