Error: ORA-20001: Unable To Derive Operating Unit For Worker. While Creating a Payroll only Timecard (Doc ID 2267942.1)

Last updated on JULY 18, 2017

Applies to:

Oracle Time and Labor - Version 12.1 HRMS RUP9 and later
Information in this document applies to any platform.

Symptoms

On Development : 12.1 HRMS RUP9 version(R12.HXT.B.9), Configured Timecard Layouts

When attempting to create a new Configured Payroll Timecard Layout or edit an existing timecard>,
the following error occurs.

ERROR
-----------------------
java.sql.SQLException: ORA-20001: Unable to derive Operating Unit for worker.
ORA-06512: at "APPS.HR_UTILITY", line 939
ORA-06512: at "APPS.HR_ORGANIZATION_API", line 4755
ORA-06512: at "APPS.HXC_SECURITY", line 306
ORA-06512: at "APPS.HXC_SECURITY", line 406
ORA-06512: at "APPS.HXC_TIMECARD", line 643
ORA-06512: at "APPS.HXC_T



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Self Service Time Responsibility>
Time>
Edit an existing Configured Payroll Timecard by modifying the hours type field then hit the
Fields(Assignment - List of Values, Hours Type - List of Values, Cost Center)
Continue>
Receive error>
java.sql.SQLException: ORA-20001: Unable to derive Operating Unit for worker.
ORA-06512: at "APPS.HR_UTILITY", line 939
ORA-06512: at "APPS.HR_ORGANIZATION_API", line 4755
ORA-06512: at "APPS.HXC_SECURITY", line 306
ORA-06512: at "APPS.HXC_SECURITY", line 406
ORA-06512: at "APPS.HXC_TIMECARD", line 643
ORA-06512: at "APPS.HXC_T


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue,it will keep from being able to roll out R12.HXT.B.9 on 02/24/2017

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