OTBI
Discussion List
-
How to get Department of Level1 , level2 and level 3 position in position HierarchySummary: We have a requirement to fetch following fields in OTBI, Person Number Assignment Number Position Name Level1 Org: Populate department of the position One level…Raghavendra M 614 views 10 comments 1 point Most recent by Raghavendra M Reporting and Analytics for HCM -
How to CAST Char to DateSummary CAST Presentation Variable of Text to Date Prompt in FormulaContent Age Band on Line Manager Dashboard is based on CURRENT_DATE rather it should based on Dashboa…User_UM4C6 59 views 4 comments 0 points Most recent by Aslam Khuajah Reporting and Analytics for HCM -
State: HY000. Code: 27047. [nQSError: 27047] Nonexistent table: "SET". (HY000)Summary: I am trying to create 2 reports: 1) Workforce Management - Worker Assignment Event Real Time:- Picking all person numbers with action names and effective date b…
-
Defined Flex Field (DFF) & Person Count and Head CountContent We have created a defined flex field (DFF) for gender as we use different values from the default HCM gender field. The DFF has been placed into Workforce Manage…User_2025-02-04-10-47-55-876 69 views 3 comments 1 point Most recent by Harry Oracle Reporting and Analytics for HCM -
How to add any OTBI/BIP report in Simple User Interface - Analytics SectionSummary How to add any OTBI/BIP report in Simple User Interface - Analytics SectionContent Please suggest. How to add any OTBI/BIP report in Simple User Interface - Anal…Avaneesh Jain-5059 76 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to join two subject areasSummary: Hi we need to join worker assignment real time and documents of real time and may i know what are the join columns of two subject areas Content (required): Vers…AjayKumar Maddipati 46 views 2 comments 0 points Most recent by User_2025-02-11-05-19-35-410 Reporting and Analytics for HCM -
Fusion 22A/22B : Post P2T Issues in BISummary: Oracle has brought a big change in OTBI/BIP configurations during P2T where configurations will be copied to the Non-Prod instances from the Prod instances. Thi…User423246 78 views 3 comments 1 point Most recent by Swapnil Kashid Reporting and Analytics for HCM -
OTBI Absence report shows different end dates on different browserSummary: Content (required): We have an absence reports which shows the employees absence. Absence type, start date and end date. However depending on which browser I us…Nicolas Vahman 74 views 9 comments 0 points Most recent by Nicolas Vahman Reporting and Analytics for HCM
-
OTBI Analysis > Time Displayed IncorrectlySummary: Hello All, I will appreciate your support on the following issue: The Start Time and Stop Time reported from the Time Device Machine are displayed correctly on …Bernard T 29 views 7 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
CASE when help for balance valueSummary: I have an OTBI analysis where I need to pull the sum of balance values for specific balance type between two dates. If an employee does not have that balance ty…Greg Rank 27 views 5 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Report for reverse terminationsSummary Report for reverse terminationsContent We are currently looking to build a report that has those who may have been processed as termination but then had the term…Preston Schultz 128 views 7 comments 0 points Most recent by Abderrahim Reporting and Analytics for HCM
-
OTBI formula needed for multiple IF THENSummary: I have a simple report that uses the subject area Workforce Management - Worker Assignment Real Time. The report contains Person Name, Job Code, Job Name, Depar…
-
Embed Report in UI AppSummary: Content (required): I am trying to add a report in the UI in the onboarding App- Is this possible to do? see image I tried using page composer but it doesn't gi…
-
How to map multiple columns from 2 different subject areas to one dashboard promptSummary: Hello everyone, I have 2 different OTBI analyses - 1 that refers to the Workforce Management - Worker Assignment Event real time and the other one refers to Wor…Vijay Rajendran 23 views 1 comment 1 point Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
OTBI Dashboard Embedded into HCM Not ResponsiveSummary: Issue with dashboard running/completing that are embedded in HCM. The dashboards were working until a recent patch after 22A. Content (required): Hi there, We h…
-
I am trying to learn how to determine what SQL is being issued in a Subject AreaSummary: I am trying to learn how to determine what SQL is being issued in a Subject Area. Any guidance is much appreciated. Thank you! Content (required): Specific anal…
-
Split OTBI analysis to multiple worksheet depending on certain columnSummary: Is there a way we can split an existing OTBI Analysis into multiple worksheet for each location Content (required): Version (include the version you are using, …
-
Please help on Oracle Learning activity report not pulling activity completion date.Summary: Trying to create a OTBI report for Oracle Learning activity report using Workforce Learning - Learning Management Real Time subject area . But I am not able to …Srinivas Sakinala 59 views 7 comments 0 points Most recent by Jane Warwick Reporting and Analytics for HCM
-
Organization Hierarchy fields causing missing employeesSummary: We have a report that keeps dropping employees whenever we add the Organization Hierarchy fields level 2 and level 3. We have made sure the values are populated…Shanna Oppenheim 29 views 9 comments 0 points Most recent by Shanna Oppenheim Reporting and Analytics for HCM -
How select only th last event in Recruiting - Recruiting Event Real Time Subject AreaSummary: Content (required): Hello Guys, We would create a report that extract the number of job application for each reason, but we only want take in consideration the …Giuseppe Iacono 57 views 2 comments 0 points Most recent by Madhavi-Oracle Reporting and Analytics for HCM -
Turnover report with custom column filterSummary: Hi Experts, our requirement is to create a turnover report with Active employees on the 1st of every month and the last date of every month, no of hires and Ter…Naveen setti 12 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How can I add a column for % Holiday Balance remainingSummary: Hello, I'm looking to see if anyone has the correct formula for me to use, or has already added in the column for '% Balance Remaining' for the annual holiday a…Karen Doig 37 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Does anyone have a report for Checklist Real Time and Transaction Administration Real Time?Summary: I am looking for a report/trying to build one for Checklist Real Time and Transaction Administration Real Time to try to report on when a Checklist has been rea…prjohnson 49 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Report for all the users along with all the rolesSummary: I am wondering if we have any report available that shows all active users with the roles assigned to them ? I am able to build OTBI report that shows Employees… -
Running OTBI based upon the Results of another OTBI getting Error getting Drill InformationSummary: We are trying to base the results of one OTBI analysis off the results of a second OTBI analysis. Both analysis run successfully on their own. However, once con…Denise Izzi 57 views 19 comments 0 points Most recent by Denise Izzi Reporting and Analytics for HCM -
Session/repository variables available in OTBISummary: Hi there, Is it possible to find out what session/repository variables are available in OTBI? Thanks for your help in advance. VijayVijay Gorania 40 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
HCM > Others tab > My Dashboard > End User Dashboard Does Not OpenSummary: HCM > Others tab > My Dashboard > End User Dashboard Does Not Open Content (required): Hello All, I will appreciate your support on the issue below: When the HR…
-
Is there a compensation event real time subject area similar to worker assignment event real time?Summary: Is there a compensation event real time subject area similar to worker assignment event real time? Content (required): We created a report using the worker assi…TerryM01 33 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Seeking confirmation of what is stored in 'question response answer text'.Summary: We currently use OBIEE and will migrate to OTBI later this year. I do not have access to OTBI to try this for myself :) . As part of the migration I am trying t… -
Application channelSummary: Mobile vs Desktop - Is there a way to report on how candidates are applying, whether it be on a mobile device or from a desktop/laptop? Content (required): We a…Mitch_123456 25 views 1 comment 0 points Most recent by User_2025-02-11-05-19-35-410 Reporting and Analytics for HCM