Projects - EBS (MOSC)

MOSC Banner

PA_PROJECT_PUB.UPDATE_PROJECT giving "... should be passed in correct hierarchy" error

edited May 5, 2020 5:01AM in Projects - EBS (MOSC) 6 commentsAnswered ✓

eBus 12.1.3

I am trying to write a script to extend the completion dates on various projects and tasks. I am trying to use the procedure PA_PROJECT_PUB.UPDATE_PROJECT to do this.

I have a cursor to select some projects, and for each project the tasks are selected.

For the project I populate the following:

  l_project_in.pa_project_id := r_project_det.project_id;

  l_project_in.project_name := r_project_det.project_name;

  l_project_in.completion_date := l_new_completion_date;

Then loop through each task for the project:

l_count := l_count + 1;

l_tasks_in_rec.pm_task_reference := r_task_det.task_number;

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