Error on calling pa_project_pub.BULK_UPDATE_TASKS_LITE

Oracle Ebus R12 Projects

Can Anyone pls help with sample code to call pa_project_pub.BULK_UPDATE_TASKS_LITE.

This throws error

Task:<task_id>is not given in correct sequence in the hierarchy of tasks

 entered for the project.

The requirement is to update scheduled_finish_date for 700K + of tasks.

pa_project_pub.update tasks takes 3 sec for each task to update, therefore cant use it.

Query used to fetch tasks is

SELECT wp.task_number,st.task_name,
wp.wbs_level,
wp.display_sequence,
st.task_id
FROM
pa_tasks t,
pa_struct_tasks_amg_v wp,