My Oracle Support Banner

HR_NEW_HIRE_SS : add parameter &PNTFFYIDETAILS=Y : notification error ORA-20001: ORA-06512: at "APPS.HR_NEW_USER_REG_SS", line 162 (Doc ID 1967562.1)

Last updated on MARCH 14, 2022

Applies to:

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


On : 12.1.3 RUP4, Hire, CWK Placement, Appl Hire

After add parameter &PNTFFYIDETAILS=Y in New Hire function, in FYI notifications following error occurs.

Exception Details.
oracle.apps.fnd.framework.OAException: java.sql.SQLException:
ORA-20001: ORA-06512: at "APPS.HR_NEW_USER_REG_SS", line 162
ORA-06512: at line 1
at oracle.apps.fnd.framework.OAException.wrapperException(
at oracle.apps.per.selfservice.common.webui.NewUserProcessTransaction.processTransaction(

Steps to Reproduce:

1. Responsibility system administrator
2. Navigate to Application, Function
3. Query the function HR_NEW_HIRE_SS
4. Modify the parameters to :
5. Responsibility Manager Self Service
6. Hire an employee
7. Check that there is an error in the FYI notifications

If one takes out the pNtfFyiDetails=Y parameter, the notification works.


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.