Timecards Stuck In Submitted Status, ORA-20001: HXC_APR_NO_REC_PERIOD: N, TIME_RECIPIENT, 1, N, APP_PERIOD_PREF (Doc ID 1683164.1)

Last updated on MAY 12, 2017

Applies to:

Oracle Time and Labor - Version 11.5.10 HRMS FP.K RUP9 to 12.2 [Release 11.5 to 12.2]
Information in this document applies to any platform.

Symptoms

When attempting to create and submit timecards for Employee.Ex-contingent worker,
the following error occurs.

ORA-20001: HXC_APR_NO_REC_PERIOD: N, TIME_RECIPIENT, 1, N, APP_PERIOD_PREF, 2022

HCAPPRWF.hxc_approval_wf_pkg.create_appl_period_info(HXCEMP, 363, 283853, RUN, 100)
Wf_Engine_Util.Function_Call(HXC_APPROVAL_WF_PKG.create_appl_period_info, HXCEMP, 363, 283853, RUN)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Go to Timekeeper responsibility
2. create timecard and submit

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