Hi, It is not a report in OTBI. You are editing an analysis in OTBI. This is a custom analysis built using the advanced technique based on some custom logical SQL to join different subject areas rather than build using the wizard from individual subject areas. Payables Instalments and Suppliers. Because you have used this…

Hi, This is an analysis in OTBI (blue) not a (publisher) report in OTBI (yellow). The correct approach for novice authors is to add a column using the criteria tab (the advanced tab is for expert users). Add any presentation column, then select column (gear icon), select edit formula. You can build up a custom calculation…

Anand, What is the issue! What is the error message? What is the sql you issue to get that error message? (cut paste since most people for security must not read attachments by strangers on the internet) Assume this is a publisher report in OTBI (yellow) not an analysis in OTBI (blue). You said report jobs so does it fail…

Hi Leonardo, Have a look at Oracle Fusion Cloud HCM Tables and Views for HCM G26438-01 25B https://docs.oracle.com/en/cloud/saas/human-resources/25b/oedmh/index.html Chapter 27 Time and Labor Also use SQL to query the following 4 subject areas to get information about business process "Report Time", "Approve Time", and…

Hi, Yes you have that out of the box. No need to do anything. A normal user cannot edit. That screenshot looks to be from a developer with elevated privileges to edit. If you sign in as a consumer then your user does NOT have the option in this list of values to edit report or edit layout. But a consumer does get the…

Hi Sandipan, What function privilege in which role did your security team tell you was required to go to this page? What data security have was implemented for this transaction on page Manage Data access for Users? If the link does not work in a users browser then assume your security team have not understood what…

Hi, Are you using the same user? Does your user have the required role with privileges to go to this page to view a payables transacction. Does the link work if you just cut paste it into a browser for this user? For comparison here is my known good version we have on our custom dashboard. Looks same to me. We are using…

Hi Warren, Yes you can create a custom read only role for any subject area in OTBI. Yes these read only roles will not need to include any of the privileges that are currently used in your metrics document to count towards a hosted named user subscription for a service in SaaS. Step 1 read the user guide to find out what…

Hi, Looks like you are query is mixing information from both 1) a job requisition and 2) the offers to candidates who made applications for a job. A job requisition may have many applications by many candidates (including multiple applications by same candidate). That application may or may not outcome with a job offer.…

Sharmava, Have you included all columns in your results view? Because you said "Results" tab say I assume you mean an analysis in OTBI not a report in OTBI (that is the object you have created in the catalog is a blue analysis not a yellow report). When you export as data to CSV or XML you get ALL the columns with all rows…

Hi Bshan, Granting a user job roles and duty roles does NOT give access to data. All it does is make it so when a user query that subject area that the system does not throw a database connection error. For many subject areas the default data security policies will mean that your expected result for a user granted the duty…

Hi, Have a look at writing a query using subject areas Compensation - Salary Details Real Time https://docs.oracle.com/en/cloud/saas/human-resources/25a/faohb/Compensation--Salary-Details-Real-Time-SA-13.html and if you need the breakdown from gross to net maybe try Payroll - Element Entries Real Time…

Hi, Write SQL to query this subject area to get information about absence plan balances https://docs.oracle.com/en/cloud/saas/human-resources/25a/faohb/Workforce-Management--Accrual-Real-Time-SA-2.html

Hi Sunil, What do you mean synched? Please provide an example. Are you talking here about viewing data in either 1) a report in OTBI (yellow) from a data model with data source from one of the 3 application database FSCM/HCM/SCM or 2) an prompt/analysis in OTBI (blue) or a report in OTBI (yellow) from a data model with…

Hi, Please review My Enterprise work area Setup and Maintenance page "Manage Data Access for Users". If you have granted for example this user with this job role security context to one or more business units then the expected result is that this user may view in analytics all purchase documents in those BU not just the…

Hi Neha, Little to no impact. The platform inside package service OTBI is suite of products Oracle Business Intelligence OBI (suite Enterprise Edition EE). 2 of the products in this suite is the 1) "green/teal" Marketing product with objects Segment, Segment Tree, List Format and 2) the "purple" product Scorecard and…

Hi Ankur, Why are you building a custom solution with custom SQL? Did the out of the box feature not work for you for some reason "Limit values by? Your requirement is you want prompt B to only have values linked to what is in prompt A. Prompt B is assignment number "Workforce Management - Worker Assignment Real…

Hi Ratha, The answer is yes. For all subject areas you can create a custom read only role. You do this because you want some users to be able to "VIEW" information but to not be able to take any action to "DO" anything like create or update or delete transactions or make configuration changes. A bit of whispers here. Human…

Hi Sebastian, We have our compensation managers viewing only data they are authorized to view by areas of responsibility. Maybe compare our notes on what we did. What did you do. Assume you built an analysis or a report with a data model with data source Oracle BI EE to query subject area Compensation - Salary History…

Ankil, The limits on data is not just rows but columns and what data is in the values of the cells (bytes) and also by time and database resources used. For analysis in OTBI you have a default maximum query row limit of 75k rows of which a default max 500 can be displayed in a table online. Other limits for pivot tables,…