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 JULY 18, 2016

Applies to:

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

Symptoms


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(OAException.java:912)
at oracle.apps.per.selfservice.common.webui.NewUserProcessTransaction.processTransaction(NewUserProcessTransaction.java:134)


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 :
     pAMETranType=SSHRMS&pAMEAppId=800&pProcessName=HR_NEW_HIRE_PLACE_JSP_PRC&pItem
     Type=HRSSA&pCalledFrom=HR_NEW_HIRE_SS&pFromMenu=Y&pNtfFyiDetails=Y&pFlowName=HrCommonInsertOab&pEffectiveDate=
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.

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