OTBI
Discussion List
-
get earliest hire date by action typeSummary: Hello, I'm trying to get, in OTBI, a result of the earliest "Employee Hire Date", based on a specific HR action (Rehire in this case). The Analysis is to get “E…Alons 31 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Is it possible to report on which workers are scheduled to work on a particular date?Summary: Content (required): I'd like to be able to report on which employees are scheduled to work on a certain date, based on the work schedule held for them, and what…Leanne W 123 views 10 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI Date Prompts for two analyses in order to compare data fieldsSummary: OTBI Date Prompts for two analyses in order to compare data fields. I used the instructions of this page OTBI HCM historical reporting (v-cdn.net) to set the da…Sa_De_Or 54 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to get Periodic accrual Projected Hours Value in OTBISummary: how to get Periodic accrual Projected Hours Value in OTBI Content (please ensure you mask any confidential information): Version (include the version you are us…
-
BIP performance after 24ASummary: We have one BI Publisher report that will not complete in any of our Oracle 24A environments. It has a data model size of 661 rows and has numerous Validation m…Thane_Fuller 62 views 2 comments 0 points Most recent by Thane_Fuller Reporting and Analytics for HCM
-
OTBI Report to get Candidate Education Start date and end dateHi Everyone, I have requirement of get candidate education start date and end date in OTBI report. Navigation : My Client Groups > Hiring > Job requisition> Applications…Rajdeep Chavda 23 views 4 comments 0 points Most recent by Rajdeep Chavda Reporting and Analytics for HCM
-
as of date birthdaySummary: Hello, Please assist on the following... We were able to calculate person ‘Age’ based on presentation variable @{asofdate} for the Headcount page on LM dashboar…
-
Report on questionaire details tagged to a courseHi, I have requirement to fetch Questionaire name, question text and answer text tagged to activity of a course but I am facing an issue while joining the learning item …
-
How to create an OTBT analysis to get results if the benefit plan got declined?Summary: We need to create an analysis to get employee results when they selected the decline option for a specific benefit plan. Which subject area I need to use ? Cont…Ayesha Iroshani 23 views 1 comment 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM
-
Email Correspondences/System Notifications ReportSummary: Looking for report(s) which would list all email correspondences we currently have set up, the status, frequency and recipients. As well as a listing all system…GMV 21 views 1 comment 0 points Most recent by Wendy Horowitz-Oracle Fusion Applications Administration
-
How to create analysis for Check-in Documents Created vs. Not Created?I need an analysis to get a list of employees who haven't created their Check-in Documents yet. I'm currently using Workforce Performance - Performance Check-In Real Tim…Welsey 31 views 2 comments 0 points Most recent by Suman Chenumalla-Support-Oracle Reporting and Analytics for HCM -
OTBI Dashboard Design - Export ButtonHi all, I'm currently working on an OTBI Dashboard that certain groups across the business will use. We're using a mixture of Performance Tiles, Graphs and Tables and I …
-
OTBI Report for Document Records Descriptive FlexfieldsHello Experts Step 1 : I Have Created a Document (Eg: External Training Request) using Task Document type. Step 2: Using Task: Document Records Descriptive Flexfields, I…
-
ESS and MSS ReportSummary: How can I report the number of transactions that were done through ESS and MSS? We want to check which countries are using the self-service the most against the…
-
Ethnicity DashboardSummary After applying "Two or more races" code, ethnicity count gets incorrectContent Applied "Display Ethnicity" logic code as per the post below to fix "Two or more r…User_2025-02-10-17-54-52-878 123 views 8 comments 0 points Most recent by Daren Reporting and Analytics for HCM -
Is there a way to use environment-aware variables for dashboard action links?Summary: Instead of hardcoding urls for dashboard action links, is there an environment-aware variable that can be used? For example, instead of https://sample-dev2.xx.x… -
FA-SAAS Enhanced SQL Guardrails and Tuning for Long Running BI SQLs for Oracle CloudSummary: FA-SAAS Enhanced SQL Guardrails and Tuning for Long Running BI SQLs for Oracle Cloud Content (required): We got mail from Oracle Cloud Saying following : As par…Swati U 940 views 7 comments 0 points Most recent by Avinash Veeranna Reporting and Analytics for HCM
-
Assignment Manager Prompt - Direct and Indirect ManagersHi all, Does anyone know if its possible to use Assignment Manager as a prompt for a dashboard and also include the full direct and indirect managers for the user? At th…
-
Footer is not displaying when data of custom report is output in WordSummary: Footer is not displaying when custom report is exported to Word. What is causing the footer to disappear when report is exported to Word? I can see the footer w…Consultant Ian 12 views 2 comments 0 points Most recent by Consultant Ian Reporting and Analytics for HCM -
OTBI > Ability to AggregateSummary: OTBI > Ability to Aggregate Content (please ensure you mask any confidential information): Hello All, In order to prevent the repetition of the Time Card Commen…
-
BIP Data Model - How do I join multiple Data Sets created from OTBI AnalysisSummary: BIP Data Model - How do I join multiple Data Sets created from OTBI Analysis Content (please ensure you mask any confidential information): After creating 5 dat…Mike.Myers.CDIPRODUCTS.COM 555 views 1 comment 0 points Most recent by Skolli-Oracle Reporting and Analytics for HCM
-
Agents and RecipientsSummary: Does anyone know how I can get a list of Agents and recipients out into a report? Content (please ensure you mask any confidential information): I need to get a…GJ79 44 views 1 comment 0 points Most recent by Gaurav Bharadwaj-Oracle Reporting and Analytics for HCM
-
Report footer not showing completely in report outputSummary: Report footer not showing completely in report output. My client wants to display this footer on all the reports. When I run the report then everything in the f…Consultant Ian 11 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
how to show different content for in app and email workflow notificationswe have a requirement to show different content for in app and email notifications of RESIGNATION. So I used below condition in the RTF template using the oracle docs. …Dara Nagasai 31 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
I have made changes to emps to workers from our integration urls but unable to find AssignmentDffId"Summary: I have made changes to emps to workers from our integration urls for testing one url need this "AssignmentDffId" but i have checked frontend as well as backend …
-
Recruitment questions in all blocksSummary: Hi , I would like to report on all questions in the pre-screening form for a candidate. The questions for the job requisition appear but not the questions in ot…Neena S 21 views 1 comment 0 points Most recent by Prabhu Mohan-Oracle Reporting and Analytics for HCM
-
Candidate and Job Application Source-TrackingWe drew the statistics from the recruit to hire dashboard, and need clarification on how these are being collected and what those source mean. We inserted a pre-screenin…Radhika Hatwar-Oracle 21 views 1 comment 0 points Most recent by Prabhu Mohan-Oracle Reporting and Analytics for HCM
-
Using BI Publisher attempting for get Learner - Self Service Setting and if overwrittenSummary: Using BI Publisher tables I am attempting to get default access - learner serf-service setting on a catalog/enrollment and then see if it was overwritten at the…Nicolas Trojack 41 views 1 comment 0 points Most recent by Erika B-Oracle Reporting and Analytics for HCM -
Privilege to Perform Location Changes from Manage in SpreadsheetWould there be a way to run a report of all active/inactive locations in Location Details? And would there be a way (with a privilege, AOR, or role) to download the loca…
-
No results using subject area Help Desk - HR Service Request LifecycleSummary: I'm trying to create an analysis using Help Desk - HR Service Request Lifecycle. In particular I need to see the data such as "Previous assignee resource id" or…