My Oracle Support Banner

OTL: HXCEMP: PLS-00302: component 'SET_APPL_PERIOD' must be declared, Approved timecards show as Submitted (Doc ID 304533.1)

Last updated on OCTOBER 22, 2019

Applies to:

Oracle Time and Labor - Version 11.5.8 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.


Employee has submitted a timecard, which was approved by their Approver. However, the timecard is now showing as 'Submitted' in the employee's 'Recent TImecard Activity' screen.

Once the timecard is approved by the approver, it should show as 'Approved'.

Reviewed 2 timecards that had been submitted this morning in the Workflow Status Monitor.
Both were in error status. The error indicated that a workflow package is uncompiled or undeclared:

Failed Activity: Set Application Period Information
Activity Type: Function
Error Name -6550
Error Message: ORA-06550: line 1, column 27: PLS-00302: component 'SET_APPL_PERIOD' must be declared
ORA-06550: line 1, column 7: PL/SQL Statement Ignored
Error Stack:,


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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