Using the My Oracle Support Portal (MOSC)

MOSC Banner

Important - hr_assignment_api.update_emp_asg_criteria

edited Apr 18, 2017 5:04AM in Using the My Oracle Support Portal (MOSC) 6 commentsAnswered

I am trying to update a field in the per_all_assigments_f table using the hr_assignment_api.update_emp_asg_criteria  api but running into this error.

ORA-20001: There must not be any future assignment actions arising after the change effective date.

Process exited.

I have hard coded the assignment id and that is the last record in the table so I am not sure how to troubleshoot it:

here is the main code: I am passing in the assignment_id and effective_start_date and the value for p_segment17. Could someone please help?

hr_assignment_api.update_emp_asg_criteria

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center