My Oracle Support Banner

Project OTBI Report Doesn't Return Data When Year Column Is Added To The Report (Doc ID 2326701.1)

Last updated on AUGUST 16, 2020

Applies to:

Oracle Fusion Project Foundation Cloud Service - Version and later
Information in this document applies to any platform.


Problem Summary
Project OTBI report doesn't return data when Year column is added to the report

When trying to create an OTBI report to fetch Budget Vs Actual Cost for projects. Subject Areas 'Project Costing- Actual Cost Real Time' & 'Project Control -Budget Real Time' are used.
The report returns data when Project Number, Current Budget Cost and Expenditure Item Cost columns are selected.
However it returns no data when we add Accounting or Fiscal Year to the report.
They tried with Project Accounting Year & Accounting Year from both the subject areas; but same result.




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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.