unable to access OTBI reports from Product Management subject Area

Pavan Kumar B

Users are unable to any OTBI analysis from product management subject area.

This issue is with user who has custom item master view only responsibility

Custom responsibility defined has these privilages

Regards,

Pavan

Nathan CCC

Hi Pavan,

OTBI subject areas do NOT require any Function Security Policy Privileges. So it does matter what function security privileges are granted direct to your custom role.

However to use a subject area your custom role MUST have inherit the required "transaction analysis" duty role(s) as per your user guide

Product Catalog Transaction Analysis Duty

Oracle Fusion Cloud SCM
Subject Areas for Transactional Business Intelligence in SCM G12617-01 24D

https://docs.oracle.com/en/cloud/saas/supply-chain-and-manufacturing/24d/faosm/Product-Management--Structures-Real-Time-SA-74.html

And optionally if your query execute without error but you get "no data found" but data does exist then if this is because subject area uses data security then your custom role must also include the required Data Security Policies with your user setup with security context on page "Manage Data Access for Users".

BTW To prove that this is in fact an issue for ANY query on this subject area, not just an issue with this particular combination of columns in this one, can you try issue a simple query just with one column.

For example, does this work for this user?

select all 0 s_0, "- Main"."Item" as name

, DESCRIPTOR_IDOF("Product Management - Structures Real Time"."- Main"."Item") as code 

from "Product Management - Structures Real Time"

Or perhaps just a yellow "measure" fact column on its own, since all queries you build must have a measure, and if you do not include a measure, the system will add the default measure in any case for you at runtime , if you have, as most query do unless for prompt lists of values, attribute columns from at least 2 dimensions. You should think about adding an explicit measure into your query.

select all

 0 s_0

,

 "Structures"."Structures" as m


from "Product Management - Structures Real Time"

Does that execute without error for this user?