Submitting Timecard, Errors: ORA-20001: HR_6153_ALL_PROCEDURE_FAIL: N, PROCEDURE, (Doc ID 301178.1)

Last updated on JULY 15, 2016

Applies to:

Oracle Time and Labor - Version 11.5.10.2 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.
***Checked for relevance on 03-Feb-2011***

Symptoms

Using PTO Accrual Balance vs Absence ( Seeded formula ) as a Time Entry Rule results in an error when submitting OTL self service timecard:

## Detail 0 ##
java.sql.SQLException: ORA-20001: HR_6153_ALL_PROCEDURE_FAIL: N, PROCEDURE,
hxc_ff_dict.set_pto_time_category, N, STEP, PTO Time Category
ORA-06512: at "APPS.FND_MESSAGE", line 126
ORA-06512: at "APPS.HXC_TIME_ENTRY_RULES_UTILS_PKG", line 2068
ORA-06512: at "APPS.HXC_TIMECARD_VALIDATION", line 707
ORA-06512: at "APPS.HXC_TIMECARD_VALIDATION", line 846
ORA-06512: at "APPS.HXC_TIMECARD_VALIDATION", line 893
ORA-06512: at "APPS.HXC_TIMECARD", line 499
ORA-06512: at "APPS.HXC_TIMECARD", line 766
ORA-06512: at line 2

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