My Oracle Support Banner

Exception Error when Processing Hire in Self Service - ORA-20001: ORA-06512: at "APPS.HR_NEW_USER_REG_SS", line 166 (Doc ID 2431372.1)

Last updated on DECEMBER 06, 2020

Applies to:

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


Problem Statement:

When attempting to open For Your Information (FYI) notifications from the worklist for an approved New Hire transaction, the following error occurs:

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


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

  1.  Responsibility: Manager Self-Service

  2.  Navigate: Hire > Enter all the required details on each page, then submit
  3.  Complete any approvals to trigger the final FYI notification



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.