Announcements for Payroll and OTL can now be found in the Announcements - Payroll and OTL - EBS (MOSC) subcategory. Follow to be sure you don't miss a thing!
Getting the Following Error in Projects Timecard Workflow ORA-01502: index 'HXC.HXC_TIME_CATEGORIES_
Hi All
We are using OTL with projects. Our Approval style is as below.
1. Project Manager.
------------------------------
On 12.1.3, When submitting a Projects Timecards, the following error is encountered in the workflow and timecard remains submitted with no notification sent to Project Manager:
Monitor Errors
-----------------------
Workflow Errors: HXCEMP, 549555
Failed Activity Create Application Period Information
Activity Type Function
Error Name -1502
Error Message ORA-01502: index 'HXC.HXC_TIME_CATEGORIES_UK1' or partition of such index is in unusable state
Error Stack HCAPPRWF.hxc_approval_wf_pkg.create_appl_period_info(HXCEMP, 549555, 401352, RUN, 130 approval style_id=9322) Wf_Engine_Util.Function_Call(HXC_APPROVAL_WF_PKG.create_appl_period_info, HXCEMP, 549555, 401352, RUN)