Approval Notification Errors With "3146: Commit Happened In Activity/Function 'HXC_APPROVAL:HXC_FILL_APP_PERIODS/HXC_APPROVAL_WF_PKG.Create_appl_period_info"

(Doc ID 1064129.1)

Last updated on JULY 15, 2016

Applies to:

Oracle Time and Labor - Version 11.5.10.2 to 12.2 [Release 11.5 to 12.2]
Information in this document applies to any platform.

Symptoms

On : 11.5.10.2

You are using Project Manager approval. 

After submitting a timecard, the approval request does not reach the Project Manager.  The timecard remains in Submitted status and SYSADMIN get the following notification:

Timecard (DD-MON-YYYY to DD-MON-YYYY) workflow for <employee> encountered error 3146: Commit happened in activity/function 'HXC_APPROVAL:HXC_FILL_APP_PERIODS/HXC_APPROVAL_WF_PKG.create_appl_period_info'

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