Project Workplan Will Not Publish: ' An error occurred during publication.'
(Doc ID 2077726.1)
Last updated on NOVEMBER 15, 2022
Applies to:
Oracle Project Planning and Control - Version 12.1.3 and laterInformation in this document applies to any platform.
Symptoms
Error while trying to publish the workplan
ERROR
An error occurred during publication. Please re-publish the workplan by clicking the button Republish on Maintain Versions page.
Query to identify data corruption
SELECT task_id,
project_id
FROM pa_tasks pt
WHERE NOT EXISTS
(SELECT proj_element_id
FROM pa_proj_elements ppe
WHERE ppe.project_id =pt.project_id
AND ppe.object_type ='PA_TASKS'
AND ppe.link_task_flag ='N'
AND ppe.proj_element_id=pt.task_id
)
AND NOT EXISTS
(SELECT proj_element_id
FROM pa_proj_element_versions ppev
WHERE ppev.project_id =pt.project_id
AND ppev.object_type ='PA_TASKS'
AND ppev.financial_task_flag='Y'
AND ppev.proj_element_id =pt.task_id
)
AND pt.project_id=XXXXXX --(Enter project id with the issue)--
ORDER BY wbs_level DESC;
l_return_status varchar2(1);
l_msg_count number;
l_msg_data varchar2(2000);
l_error_msg_code VARCHAR2(200);
l_error_code number;
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 |