Fusion OTBI - Need to fetch Project Number assigned for the logged in user
Summary:
We need to fetch the Project Number associated with the logged-in user in order to create a List of Values (LOV) in a dashboard prompt. We have tried using the "Project Resource Management - Real Time" subject area, but it does not return the expected or valid values for this requirement. Please suggest the appropriate subject area and columns we should use to retrieve the Project Numbers relevant to the logged-in user (person).
Content (please ensure you mask any confidential information):
Oracle Fusion Cloud - Analytics - OTBI
Version (include the version you are using, if applicable):
25B
Code Snippet (add any code snippets that support your topic, if applicable):