My Oracle Support Banner

Error 'ISG_SERVICE_EXECUTION_ERROR' When Calling HR_ASSIGNMENT_API.UPDATE_EMP_ASG Using Rest Webservice Or REST API. (Doc ID 2985879.1)

Last updated on NOVEMBER 07, 2023

Applies to:

Oracle Human Resources - Version 12.2 and later
Oracle E-Business Suite Integrated SOA Gateway - Version 12.2 and later
Information in this document applies to any platform.

Symptoms

When attempting to execute hr_assignment_api.update_emp_asg as Rest service or REST API
the following error occurs.

ERROR
-----------------------
 
ISG_SERVICE_EXECUTION_ERROR
Message": "Error while executing service",
"Resolution": "System error, please see service log trace for details",

Server log error:

ISGRootException: ISG_SERVICE_EXECUTION_ERRORError occurred while executing the web service request
ISGRootException: ISG_SERVICE_EXECUTION_ERRORError occurred while executing the web service requestService execution error - Stored procedure invocation error.
Error while trying to prepare and execute the APPS.ISG_HR_ASS_UPDATE15174444.HR_ASSIGNMENT_API$UPDATE_EMP_ API.
An error occurred while preparing and executing the APPS.ISG_HR_ASS_UPDATE15174444.HR_ASSIGNMENT_API$UPDATE_EMP_ API. Cause: java.sql.SQLException: ORA-20001: The mandatory argument assignment_status_type_id value cannot be null

Cause: The mandatory argument assignment_status_type_id has either not been specified or has been explicitly set to null in the API per_asg_bus1.chk_assignment_status_type_id '

Action: Either specify a value for the assignment_status_type_id argument which is not null or contact your local support representative.
ORA-06512: at "APPS.HR_ASSIGNMENT_API", line 11858
ORA-06512: at "APPS.HR_UTILITY", line 970
ORA-06512: at "APPS.HR_API", line 100
ORA-06512: at "APPS.PER_ASG_BUS1", line 4176
ORA-06512: at "APPS.PER_ASG_BUS1", line 2989
ORA-06512: at "APPS.PER_ASG_UPD", line 1992
ORA-06512: at "APPS.PER_ASG_UPD", line 2361
ORA-06512: at "APPS.HR_ASSIGNMENT_API", line 11468
ORA-06512: at "APPS.ISG_HR_ASS_UPDATE15174444", line 143
ORA-06512: at line 1

 
STEPS

=====

1. Execute hr_assignment_api.update_emp_asg as RESP API Services
2. Error is thrown as mentioned above.

Cause

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.