In Worklist for Manager, FYI Notifications for New Hire Throws Error "ORA-06512: at "APPS.HR_NEW_USER_REG_SS", line 166" After all Approvals (Doc ID 2039617.1)

Last updated on MAY 02, 2017

Applies to:

Oracle Self-Service Human Resources - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

When attempting to click on the FYI notifications from the worklist received after approving a new hire request, the following error occurs.

ERROR
Error Page
Exception Details.
 oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-20001:
ORA-06512: at "APPS.HR_NEW_USER_REG_SS", line 166
ORA-06512: at line 1

at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
at oracle.apps.per.selfservice.common.webui.NewUserProcessTransaction.processTransaction(NewUserProcessTransaction.java:134)
  ...
  ...
## Detail 0 ##
java.sql.SQLException: ORA-20001:
ORA-06512: at "APPS.HR_NEW_USER_REG_SS", line 166
ORA-06512: at line 1

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
  ...
  ...



Steps to reproduce:
The issue can be reproduced at will with the following steps:

1. Log into Manager Self-Service

2. Submit a request for a new hire

3. All approvers approve the transaction

4. An FYI notification will then be available in the worklist of the manager

5. Click on the FYI notification...the above OA Exception is thrown



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