My Oracle Support Banner

How to Run Custom Report Without Errors About Project and Task Codes? (Doc ID 2507436.1)

Last updated on FEBRUARY 02, 2020

Applies to:

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

Goal

A custom analysis using Task Codes and Project Codes errors when trying to run it from Manage Project Plan -> Shared Reports and Analytics. The same analysis runs without error from OTBI.


e.g. of error:
Code: 23037. [nQSError: 23037] The presentation object "Project Management - Planning Real Time".."- Task Codes"."Number Attribute 06"
visibility expression "case when 'HIDE' =VALUEOF(NQ_SESSION.PJF_TASKS_PJF_PROJ_ELEMENTS_B_NUMBER_ATTR06) then 1 else 0 end " is not valid. (HY000)

Solution

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
Goal
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.