Hi Raoof, Out of the box you can use the data security policies such as the in job role such General Accountant to setup on page Manage Data Access for Users data security on context Data Access Set by ledger. But if cost centre is one of the segments in your charts of accounts(s)? Then maybe get your application…

Hi, You refer to the conversion rates setup from My Enterprise work area Setup and Maintenance task "Manage Daily Rates" in application table GL_DAILY_RATES https://docs.oracle.com/en/cloud/saas/financials/24d/oedmf/gldailyrates-24409.html So that we can do our own currency conversions check the data lineages yourself…

Hi, Granting a job role does not give a user any data access. Assuming the obvious that you do in fact have some payments in your system! Your user has bi consumer role and as per your user guide for this subject area…

Hi Omran, What is this access error? If you bypass data security then the outcome is the opposite. What you have done is made it so that it does NOT function properly. To function properly a user must view only data for which they are authorized to view. It you replace an analysis in OTBI with a report in OTBI with a data…

Hi, You do not need our help for this one. No guessing or searching required. Because you know already what physical application database table column you need PON_AUCTION_HEADERS_ALL.creation_date https://docs.oracle.com/en/cloud/saas/procurement/24d/oedmp/ponauctionheadersall-14541.html you can read your data lineage…

Hi, Yes most subject areas in ERP for the job roles you have that include this data security policy use security context Business Unit from page Manage Data Access for Users. But the designer of the subject areas has tended to put the data security only on the facts measures but not on the dimensions themselves. So if in a…

Hi, Use division. If x is amount in unit of currency then add a calculated column with formula x/1000000 is millions etc. then use the calculated column in your chart.

Hi Gökhan Karabulut The system does this "out of the box". All dashboards are already "role based". Yes you do not need to build different analysis for each business unit. You just build one analysis. At query time User A only get business units X Y and user B will only get business unit Z. You do NOT need to use dashboard…

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…

Hi, You have privilege to create an alert if you can create an agent which on the left hand side in purple Actionable Intelligence is link Agent. All agents use a SQL query from a subject areas in the metadata repository database RPD to get the content in the alert using an analysis or an analysis on dashboard page or…

Hi Kalpesh, In the screen you posted it shows that your BI Administrator HAS already using page Manage Privileges /analytics/saw.dll?PrivilegeAdmin granted this user privilege to create an alert using Agent. To create an alert in the global header select Create, system display list of values, in Actionable Intelligence…

Hi Protyush, The duty roles that give you permission to issue SQL using a subject area in the metadata repository database RPD in OTBI are typically not included in the list of privileges used to count a user as a "hosted named user" for a subscription as a hosted named user to a service part number . A custom read only…

Hi, It is ok for me. Not greyed out. Maybe your privileges? Ask your user with bi administrator role go to page manage privileges /analytics/saw.dll?PrivilegeAdmin to check the privileges granted to your user or a role your users has or inherit?

Hi Aman, I recommend building your action as a separate object. That way you can unit test it. And reuse it on multiple analysis. Select Create, select Action then Navigate to BI Content. When you double click the completed action in the catalog does it go to the target page with your child analysis (but with no context so…

Hi Omran, Period name is a string not time. You could perhaps change it to a prompt on a date like where "Period Start Date" or "Period End Date" between X and Y? The decision on what period of time a period name represents using what naming convention was a choice made by your application implementation consultant. Your…

Hi Vinay, You tend to get a different error message if your user does not have the required duty role to execute any query from this subject area. I expect this query will execute with success if this user only selects just a few columns. I expect there is something odd in one of the columns in this particular query…

Hi, Here is the SQL for timecard approval date "Reported Time Cards"."Time Card Approved Time" This is the current timecards. https://docs.oracle.com/en/cloud/saas/human-resources/24c/faohb/Workforce-Management--Reported-Time-Cards-Real-Tim-SA-56.html#Workforce_Management__Reported_Time_Cards_Real_Tim_SA_56_d1e19413 You…

Hi Anup, Yes I understood your requirement. Action code tells you what type of change was made to the assignment. So if it is manager change then you know it is just the few manager attributes. But if it is assignment change then it can be one or more of many attributes. And you understand what is the data you get using…

Hi, Yes it does give you the changes to values like location, grade etc. So the query will return 1 row for each version of an assignment over time. So a worker assignment is unique identified by 5 attributes; assignment id, effective start day, effective end day, effective sequence number, effective latest change. All the…

Anup, Yes you can build a query from subject area Workforce Management - Worker Assignment Event Real Time https://docs.oracle.com/en/cloud/saas/human-resources/24c/faohb/Workforce-Management--Worker-Assignment-Event-Real-SA-4.html#Workforce_Management__Worker_Assignment_Event_Real_SA_4_d1e20594 either by a) using an…