How do I get Project Cost Adjustments detail and history data in FDI?

Question

Using the standard out of the box subject area(Project Costing), I am unable to get project adjustments data and history.

For example, I would like to get all project cost transfers from project A to project B; including data such as transaction numbers to/from, project number to/from, creation date, transaction amount, and all the adjustment history pertaining to the transfer transaction; example of Adjustment History shown below.

How can I get this data using standard out of the box Oracle subject areas?    Thanks so much in advance!

Bhaskar Konar · Answer

Thanks Daniel!

Hi @Trang Tran UCD,

In addition to Daniel's suggestion want to share my review of the standard FDI Project Costing subject areas, I haven't been able to locate attributes that expose the Project Cost Adjustment History shown in the Fusion application (for example, transfer history, approval history, justification, adjustment status, or source/destination transaction details).

The standard Project Costing subject areas appear to be focused primarily on reporting the resulting project cost transactions and expenditure items, rather than the adjustment audit trail.

I also reviewed the Oracle Project Costing FAQs  (

https://docs.oracle.com/en/cloud/saas/analytics/26r2/faiae/erp-project-costing-faqs.html

) for FDI, which describe the available Project Costing subject areas, their behaviour, and known reporting considerations. However, I couldn't find any reference to reporting on Project Cost Adjustment History or the adjustment audit information displayed in the Fusion UI. This suggests that the standard semantic model is primarily designed around project cost transactions rather than adjustment history.

If the reporting requirement is to analyse transferred costs between projects, some of the resulting transaction information may be available through the standard subject areas. However, for a complete adjustment history (for example, Project A → Project B transfer details, transaction numbers, approval history, justification, and status changes), then it may be worth considering a custom reporting approach (for example, BI Publisher or an FDI extension), depending on the available data sources and reporting requirements.

Hope this help.

Trang Tran UCD · Answer

Thank you Daniel for the reply.  We will look into using Data Augmentation.  I will also create an Idea for Oracle to deliver Project Cost Adjustments data via a new subject area or add to the existing Project Costing subject area.

Daniel Ryan · Answer

Hi @Trang Tran UCD, You could try bringing in the extra information using Data Augmentation to connect to the PVOs. The reference documents for Projects Business Objects is at

https://docs.oracle.com/en/cloud/saas/project-management/26c/fabpm/bo_oraErpCoreProjectCostTransactions_ProjectCostTransaction.html

Hope this helps