My Oracle Support Banner

Error during userhook call in HR_ASSIGNMENT_BK2.UPDATE_EMP_ASG_B (Doc ID 2059343.1)

Last updated on FEBRUARY 05, 2019

Applies to:

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


On : 12.1 HRMS RUP8 version, Assignment,Term,Pay,ChgMgr,LOA

When attempting to change manager (or any assignment related function) with user hook code call in HR_ASSIGNMENT_BK2.UPDATE_EMP_ASG_B, the following error occurs.

 at oracle.apps.per.selfservice.supervisor.server.SupervisorAMImpl.updateAssignment(
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(
 at java.lang.reflect.Method.invoke(
 at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(
 at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(
 at oracle.apps.per.selfservice.supervisor.webui.SupervisorCO.processFormRequest(
 at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(
 at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(
 at oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processFormRequest(

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

1. Add a custom user hook call in HR_ASSIGNMENT_BK2.UPDATE_EMP_ASG_B to display a message based on any logic.



  CREATE OR REPLACE procedure xx_test_PRC AS
  hr_utility.set_message (800, ‘HR_Display_MSG’); -- HR_Display_MSG is a message.
  END xx_test_PRC;
 Modify HR_ASSIGNMENT_BK2.UPDATE_EMP_ASG_B to call the above procedure:
 end if;
 end if;
 -- Added code below Begin
 if hr_api.call_app_hooks then
 end if ;
 -- Added code below End
 hr_api.validate_commit_unit(l_commit_unit_number, 'UPDATE_EMP_ASG', 'BP');
 hr_utility.set_location(' Leaving: HR_ASSIGNMENT_BK2.UPDATE_EMP_ASG_B', 20);


2. Compile the package body.
3. Navigate to 'Manager Self-Service' -> Change Manager

4. Click Action icon for any employee.

5. Click Continue button in the effective date options page.

6. Change the New Direct Report, Click Next button.

7. Shows Error.

8. Remove the user hook call from HR_ASSIGNMENT_BK2.UPDATE_EMP_ASG_B, Re-test no error.


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.