The specified criteria didn't result in any data.

Question

In project costing - commitments real time

"Total Committed Raw Cost" column is not returning any data

When added the "Project Number" and "Total Committed Raw Cost"  displays the below error

Please let me know how to get the values for

"Total Committed Raw Cost"

"Total Committed Raw Cost in Provider Ledger currency"

Steps we have done.

* Below roles are added

Grants Management Transaction Analysis Duty

Project Costing Transaction Analysis Duty

Project Journals Transaction Analysis Duty

* In OTBI analysis -  Advanced section added below

SET VARIABLE PREFERRED_CURRENCY='Ledger Currency';

Please help us with the solution

Nathan CCC · Answer

Hi Dilip,

You do NOT need to assign the duty roles. The duty roles are inherit by the job role. Revoke the 3 duty roles you have granted then from the list for this subject area grant the required job role(s). The job roles are required because they contain the data security that give access to data. But  as suggested by Praveen you do also need to setup manage data access for users.

They duty roles are listed in the user guide for a subject area for information only so you know which duty roles you might need in a custom role to use a subject area. Here is the user guide for this subject area.

Oracle Fusion Cloud Project Management

Subject Areas for Transactional Business Intelligence in Project Management

F85686-01 23D

https://docs.oracle.com/en/cloud/saas/project-management/23d/faopm/Project-Costing--Commitments-Real-Time-SA-14.html#Project_Costing__Commitments_Real_Time_SA_14_d1e4998

So as you can see you need one of the following job roles to "use" the subject area.

Job Roles

The following job roles secure access to this subject area:

Grants Accountant

Grants Administrator

Grants Department Administrator

Principal Investigator

Project Accountant

Project Administrator

Project Manager

For information only you know the above roles inherit the following duty roles that allow you to query this subject area without error.

Duty Roles

The following duty roles secure access to this subject area:

Grants Management Transaction Analysis Duty

Project Costing Transaction Analysis Duty

If you were not granted one of these job roles which inherit this duty role(s) then when you query this subject area it will throw a database connection error because you are not allowed to use it. Because your query was a success, it did not throw an error, it returned zero rows then you know you have been granted the correct roles. No data found is the expected result for many of the subject areas. That is a successful query.

A role does not give access to data in subject areas in ERP. HCM subject areas are different because it uses data roles. But in a subject area like this one in ERP the job role contains data security policies. These data security policies are used by the subject area to add a where clause to your query at run time for data security. For example, the data security policy for grant on business unit will allow you to see only projects for the business units to which your user has access to for this job role. Assume you have not setup any data access therefore get no rows.

You can view the data security where clause for your user by cut paste your logical query from the advanced tab of you analysis then go to page  issue sql then view the manage sessions log to see the physical query(ies) that the metadata repository database sent to the application databases to get the data. To go to this page make sure your bi administrator has granted using manage privileges your user or role "Issue sql directly" and "manage sessions".

Ok so now you know why you get no data! How do you get data? You need to go to the Navigator then in folder My Enterprise select work area Setup and Maintenance. Then go to task Manage Data Access for Users. Here grant your user with the job role, for example, Project Accountant to one or more security context, for example, if the job role has a data security policy for business unit, then grant one or more business units. Sorted?

Praveen Kumar Akkala-Oracle · Answer

Hi @Dilip.Murugan-Oracle,

You need to assign both the job and duty roles required for the subject area along with data access.

https://docs.oracle.com/en/cloud/saas/project-management/23b/faopm/Project-Costing--Commitments-Real-Time-SA-14.html#Project_Costing__Commitments_Real_Time_SA_14_d1e5007

Thanks,

Praveen