My Oracle Support Banner

Updating Assignment Information Fails with ORA-20001: System Error: Procedure hr_assignment_api.validate_scl at Step 6 (Doc ID 2700757.1)

Last updated on AUGUST 13, 2020

Applies to:

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

Symptoms

Problem Statement:

When attempting to execute API (HR_ASSIGNMENT_API.UPDATE_EMP_ASG_CRITERIA) to change the assignment information, the following error occurs.

ORA-20001: System Error: Procedure hr_assignment_api.validate_scl at Step 6
Cause: The procedure hr_assignment_api.validate_scl has created an error at Step 6.
Action: Contact your system administrator quoting the procedure hr_assignment_api.validate_scl and Step 6.

        * The error does not occur when updating assignment information in PUI.

 

Steps to Reproduce:

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

  1.  Run API (HR_ASSIGNMENT_API.UPDATE_EMP_ASG_CRITERIA)
  2.  Error occurs



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


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