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

Recommended Posts

Start typing and press Enter to search