OTBI
Discussion List
-
Administration-->Bi Publisher/Manage BI Publisher-->Runtime Configuration/Properties Refreshed?Content Hi there, I searched My Oracle Support and the Community, but wasn't able to find any documentation regarding the following: Any knowledge/documentation regardin…Karen Costakes 21 views 2 comments 0 points Most recent by Arghyo Banerjee -Oracle Reporting and Analytics for HCM -
Payroll element entries costingSummary OTBI Subject Area and fields for data.Content Under the payroll element entries - Cost Account are the fields Fund___ Purpose__ Prc__ Object___ Location___ CostC…User_2025-02-08-08-49-19-186 33 views 3 comments 0 points Most recent by Dilpreet Kaur Reporting and Analytics for HCM -
How to fetch 'Y' for Managers having direct reportee and 'N' for Managers not h'ing direct reportsSummary: Sql to get 'Y' for the Managers having direct reportee and 'N' for the Managers not having direct reportees in oracle fusion hcm. Please suggest. Content (requi…User_ENPUR 205 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Fiscal calendar in OTBIHas anyone built a fiscal calendar in OTBI? A 5-4-4 fiscal calendar. Our fiscal year starts in November (October 28th for 2020). We have a lot of reports that we end up …SM-Oracle 31 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Pass parameter to embedded report in pageSummary Pass person id as parameter to embedded report.Content We need to display some employee information on the Public Info page for any employee. Since personalizati…Varkey George-Oracle 133 views 3 comments 1 point Most recent by User_XHDBT Reporting and Analytics for HCM
-
Random Sampling of EmployeesContent I am trying to pull 50% of the employee population at random. Is there a report or formula I can use to pull this information?Riti Malhotra 36 views 13 comments 0 points Most recent by Caleb Pingelton Reporting and Analytics for HCM
-
Work structure reports for Oracle HCMSummary Work structure reports for Oracle HCMContent Do anyone have list of reports which can help pulling the work structure details from the configuration tables - JOB…Prabhu Krishnamoorthy 32 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
HCM Integration Real TimeSummary HCM Integration Real TimeContent Hi Experts, I am trying to build an OTBI report based on "HCM Integration Real Time" subject area to fetch HCM Extract definitio…
-
Candidate Address and Other - IRC_JobOffer_Accepted_External - Alert/NotificationContent Hi, Using Alert: IRC_JobOffer_Accepted_External, added template. Whereas Procurement Department need to be informed that Candidate accepted offer. Procurement ne…
-
Use TIMESTAMPADD in SQL PrefixSummary What is the correct syntax for using TIMESTAMPADD in a SQL prefix without using a presentation variable prompt?Content Hello - I am creating an analysis that wil…User_2025-02-08-04-27-03-855 20 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Calculate Time at grade, location, time in role (not position) using Assignment Event Real Time in HContent Hello, I am trying to use OTBI to look at an employee's assignment history and derive new calculated fields for the following: * Grade Effective Start Date and t…RebeccaAult1799 96 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Issue in Turn Over ReportSummary I have built Turn Over Report with 2 subject areas workforce Management-Assignment Event Real Time and Workforce Management- Trend Real Time .Content The Columns…User_2025-02-08-08-08-53-292 28 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How dependent parameter works in OTBI Report, BI Report and DashboardSummary How dependent parameter works in OTBI Report, BI Report and DashboardContent Hi Experts, Can someone explain how the following thing works in OTBI Report, Dashbo…
-
Sample snapshots of OOTB Reports and AnalyticsContent Hi Everyone, Client need sample snapshots of all OOTB report and analytics, Let me know where can i get all snapshots of OOTB report and analytics. Please let me…Reddykrishna Chidella-Oracle 38 views 3 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Multiple Dashboards to oneContent I have created 2 separate dashboards one for Headcount and one for Performance Document. I want to now add the performance dashboard as a separate tab on the hea…
-
Recruitment Subject Area - retrieve Candidate skillsSummary Fusion (21c) Subject Area Recruiting - Recruiting Real TimeContent Our customer requirement is to see Skills from the 'Skill and Qualifications' Candidate sectio… -
HCM Integrations Real Time Subject AreaSummary Extract SubfolderContent 1. Do we have any column which says if that extract is seeded or custom?2. Though I can see the Rule in Extract Definition, but can not …
-
Adding parameters to a deep linkContent Hi, Does anyone have steps or documentation of adding parameters to a deep link to go into a specific person's page/details from an OTBI report? Deep Link - http…Dishti Malhotra-Oracle 155 views 3 comments 2 points Most recent by Liran Reporting and Analytics for HCM
-
Average Time to HireSummary Documentation or Logic of Average Time to HireContent Is there any documentation or means to know how the measure "Average Time to Hire (Days)" is calculated in …Rajesh Jayaram 81 views 1 comment 1 point Most recent by Sovitendu Jalli-Oracle Reporting and Analytics for HCM
-
How to bring different type of manager in analysisSummary To display matrix manager and functional manager in analysisContent In fusion system, as per business requirement, there are two types of manager type, one is Li…User_2025-01-29-18-45-19-617 76 views 6 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Duplicate lines in OSHA 300 when an employee transfers to a new job/positionSummary Duplicate lines in OSHA 300 when an employee transfers to a new job/positionContent We are working through some issues where an employee has two rows within the …Andrew_Schmitz 18 views 1 comment 0 points Most recent by Glen Walton-Oracle Reporting and Analytics for HCM -
Role permissions to BI reportsContent We want to give access to our HR manager to modify BI report or create an adhoc OTBI analysis for the recruitment and onboarding module. What permission can we g…
-
Add 45 day to Benefit Program Date in OTBI AnalysisSummary Add 45 days to Benefit Program Date in in OTBI Analysis filterContent Hello, I need to add a filter to the OTBI analysis. The filter should add 45 days to the Be…GauravGupta39 23 views 6 comments 0 points Most recent by Sovitendu Jalli-Oracle Reporting and Analytics for HCM
-
Is there a way to track which all analytics/Reports are run by users and via which device (Laptop VsContent Hi Everyone, Is there a way to track which all analytics/Reports are run by users and via which device (Laptop Vs Mobile phones) Please let me know if you have a…Reddykrishna Chidella-Oracle 44 views 2 comments 0 points Most recent by Sovitendu Jalli-Oracle Reporting and Analytics for HCM
-
Dashboard prompts using sql querySummary Need to create dashboard prompts using sql query as the relevant subject areas for prompt data is not availableContent Hi Experts, I have a requirement to have p…Anirudh Udupa 13 views 3 comments 0 points Most recent by Anirudh Udupa Reporting and Analytics for HCM
-
Why are some column headers clickable links in my OTBI report? What is the functionality of these liContent Hi, I would like to know why some of the column headers in my OTBI report are clickable links and others are not. I would also like to know the purpose of these …Alex Buckley 30 views 1 comment 0 points Most recent by Sovitendu Jalli-Oracle Reporting and Analytics for HCM
-
Can anyone give me Logical SQL with UNION ALL sample codeSummary Can anyone give me Logical SQL with UNION ALL sample codeContent Hi All, Can anyone give me Logical SQL with UNION ALL sample code Regards, Rashmi -
Viewing secured views for Oracle delivered reportsContent I am reviewing some of our delivered reports and am noticing what I believe to be an issue with our secured views. Specifically, I noticed that users can see the…Evan Lehrhoff 30 views 3 comments 0 points Most recent by Evan Lehrhoff Reporting and Analytics for HCM
-
How to add bin as prompt?Summary How to add bin as dashboard prompt?Content We have created a column, Position Status, on a position management analysis based of a calculated measure we created,…Aja Nealley 37 views 5 comments 2 points Most recent by Sovitendu Jalli-Oracle Reporting and Analytics for HCM
-
Need SQL Query or OTBI report to display OTL Calculated HoursContent Hi All, Pls share Subject area or SQL query to get the OTL calculated hours. For Ex: In a week employee entered 42 hours under Regular. When we click on NEXT but…Visu 910 views 1 comment 0 points Most recent by John Finnegan-Oracle Reporting and Analytics for HCM