General Transactional Reporting (OTBI)
Discussion List
-
The performance tile view is not refreshing for one user in PRODSummary: The performance tile view is not refreshing for one user in PROD Content (required): Hi experts, We have a case where the performance tile view is not refreshin… -
Has Bursting SQL Functionality Changed with 22B?Summary: Bursting SQL not working as it did before upgrade to 22B Content (required): Simple bursting sql to send email when running a report. Worked fine up until 22B. … -
May I know subject area for talent ratings.Summary: I already taken person profile real time but we unable to find out rating source column from . Content (required): Version (include the version you are using, i… -
Which Subject Area to Use When Generating Personal Information DetailsSummary: We want to generate the personal information details created by different users on the system, but can't find the exact subject area that has those information.…
-
Absence Balances ReportHello, We have been tasked to develop a report against the Absence records to find out the employee balances for each pay period. Can anyone please advise the subject ar…
-
How to view History of a scheduled AnalysisSummary: Content (required): Hi All, I have scheduled an Analysis to run every hr. There is no History option available in the analysis -->> More menu or the analysis sc…
-
which subject Area need to take for Talent RatingsSummary: Hi team, we have new requirement on Talent ratings of employees So how can I go with and in which subject area below columns are available ? Talent ratings>care…
-
Using BIP Rest API in Oracle HCM CloudSummary: Using BIP Rest API in Oracle HCM Cloud Content (required): Hi experts. Does anybody know if it is still impossible to use BIP Rest APIs within fusion apps? A BI…
-
OTBI report and data role securitySummary: Should an OTBI report using General Ledger - Balances Real Time subject area (linked to the Essbase cube) inherit custom data roles configured in SaaS? Content …
-
Creating Custom Columns in OTBI ReportingSummary: I like to know who to create custom columns for reports and then call them in OTBI Analysis Save me updating individual reports as I am doing at the moment A us…
-
Table to retrieve records from Audit reports in Oracle Cloud Fusion ERP 22ASummary: Table to retrieve records from Audit reports in Oracle Cloud Fusion ERP 22A Content (required): Which table in SaaS stores information for Audit Reports? Table … -
OTBI Analysis - Show Managers Direct and Indirect StructureSummary: OTBI Analysis - Show Managers Direct and Indirect Structure Content (required): I am looking to show a manager's indirect structure, for example, I like to know…
-
How to restrict the PPM contract data based on the roles of the user logged in in OTBI DashboardSummary: We are trying to restrict the data based on the roles available for the user logged in specifically Principal Investigator role (PI role). Content (required): V…
-
Unable to open public job historySummary: Has anyone seen this error before. I have a user that is trying to view the results from the Job History and getting the attached error screen with message HTTP… -
Report containing all the agent(s) I have definedSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
Employee salary details not able to view through Compensation - Salary Details Real Time Subject AreSummary: We are trying to create a OTBI report for Employee assignment details with Salary details using Compensation - Salary Details Real Time % Assignment Real Time S…
-
Outer Join OTBI - Vacant PositionsSummary: I am trying to produce an analytic that can show the number of "Vacant" positions. The analytic requires two subject areas and I believe I may need an outer joi…
-
Absence Leave Amount & Payroll Element NameContent Good Day, We have been tasked to create a report where anyone who has booked less than a full days leave is highlighted. This in its self is very easy and achiev… -
Restrict User to create OTBI or BIP reportsSummary: Requirement is that Users should not be able to create any OTBI reports from his account. We have already restricted the Permission for the user to access other… -
Hide Seeded Folders from Reports and AnalyticsSummary: We are able to hide customs Folders by Using Shell role and and Permission feature. However While trying the same with Seeded Folders or the folders within them…
-
OTBI CertificationSummary: OTBI Certification Content (required): Since last year we have been using HCM.I have been trying to create some reports in OTBI, however, I see that I need to l…
-
Can we schedule Dashboards ?Dear , My requirement is to schedule a dashboard same like reports. I successfully schedule a reports but i cant see a option to schedule dashboard can any one guide me …
-
Can we restricted Report data on a users basis?Dear , We need to restrict reports data to a user base. Some user see all data which have been in report and some users see only his data. How can we do this . we need t…
-
how to write a condition When a employee get the direct reports for first timeSummary: Content (required): Retrive the data of the first time managers into a OTBI report Example : suppose an employee doesn't have any direct reports on yesterday(27… -
When archived report files re uploaded it is appearing as .catalog. Not as reportsSummary: What needs to be done to make it work as report. Previous instance it was appearing as report Content (required): Version (include the version you are using, if…
-
Oracle BIEE 11.1.1.9 to 12c (Oracle Cloud HCM Update22A) Catalog Group migration to Application RoleSummary: Need Guidance in transitioning Catalog Groups available in Oracle BI Enterprise Edition 11.1.1.9 to Oracle BI Enterprise Edition 12C. Oracle is performing the q…
-
Pie Chart does not return all itemsSummary: Table results not displayed in Pie Chart Content (required): We have a table that is ranked and everything ranked above 10 is grouped under the reason name 'Oth… -
How to pull Spouse Date of Death in OTBI reportSummary: The requirement is to pull the Employee's Spouse's Date of Birth but the field should be left blank if the employee doesnot have a spouse or if the spouse is de…
-
Issues in HC & FTE measuresSummary: Creating an analysis with several subject areas (six) with an incorrect output Content (required): Hello, I am creating a new analysis based on different subjec… -
Subject Area: Costing - New COGS and Gross Margin Details Real Time not giving any resultSummary: Analysis created using "Costing - New COGS and Gross Margin Details Real Time" subject area is not giving any output Content (required): I tried to create a sim…