Introduction:
This blog has Project Tasks Import FBDI Query that can be used to retrieve data as per Project Tasks FBDI Format in Oracle Fusion Cloud application.
Cause of the issue:
Business wants to update the existing Project Tasks information in Oracle Fusion Cloud Application.
How do we solve:
We have created below query to retrieve data as per Project Tasks FBDI Format and required columns in Oracle Fusion Cloud application.
Query:
select
ppav.segment1 project_number,
ppav.name project_name,
ppev.element_number task_number,
ppev.name task_name,
ppev.description Task_Description,
ppev.chargeable_flag chargeable_flag,
ppev.planning_start_date planning_start_date,
ppev.planning_end_date planning_end_date,
ppev.element_number TaskSourceReference,
ppev.denorm_wbs_level denorm_wbs_level
ppev.ATTRIBUTE1,
ppev.ATTRIBUTE2,
ppev.ATTRIBUTE3,
ppev.ATTRIBUTE4,
ppev.ATTRIBUTE5,
ppev.ATTRIBUTE6,
ppav.ATTRIBUTE7
from pjf_projects_all_vl ppav,
pjf_proj_elements_vl ppev
where ppav.project_id = ppev.project_id
/* chargeable for lowest item in task*/
and ppev.chargeable_flag = ‘Y’
/*
AND ppav.segment1 in (
)
*/
order by ppav.name