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 11.12.1.0.0 and later
Information in this document applies to any platform.

Symptoms

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.

Changes

 

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
Changes
Cause
Solution
References


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