OTBI
Discussion List
-
Merge Lead Creation Date & Opportunity Creation DateSummary: We are having a scenario to populate total no of Leads & Opportunity created on Monthly basis. For FY2024, On monthly basis Jan'24, Feb'24 , Mar'24 etc . . It s…Vigneshwar 12 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Combining two rows of data into a single columnSummary: Combining two rows of data into a single column IF an employee has two degrees the expectation is to print it into a single row of data. For example Employee 12…Venkateswaran Murali-Oracle 237 views 15 comments 0 points Most recent by Velidi Supraja Reporting and Analytics for HCM
-
Not able edit the OTBI reports for developed by others usersSummary: Not able edit the OTBI reports for developed by others users. Can you please suggest Content (please ensure you mask any confidential information): Throwing an …Linga Murthy 12 views 5 comments 0 points Most recent by Linga Murthy Reporting and Analytics for HCM
-
![Arun Kumar Krishnan [AK]](https://us.v-cdn.net/6034893/uploads/userpics/L8BUJDYF94E7/nTLGWFBWW678P.jpg)
Inherited Role Audit detailsSummary: Hi Team, Need a Role report that gives you the details for scenario: Role A is inherited by Role B(Employee Role) and assigned to Person A. Need to know below: …Arun Kumar Krishnan [AK] 32 views 3 comments 0 points Most recent by bobby.hussey Reporting and Analytics for HCM -
Passing real time binding parameter to OTBI as presentation variableContent I have a requirement to add OTBI report in Termination Page UI which will capture three Real-time Binding Parameters (Person ID, Termination Date & Termination N…User_2025-02-06-14-37-05-233 656 views 28 comments 0 points Most recent by GopalS Reporting and Analytics for HCM -
Need help finding field in OTBI reportSummary: Hi Team, We have requirement to create a report to pull Progression Grade Ladder’s details. We created OTBI report using Workforce Management - Grade Rate Real …Saurabh_Mharolkar 61 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
OTBI Custom ImagesHi all, Just a quick one I'm hoping someone knows the answer to! We've been using our own custom images for reporting and have noticed that the system allows us to uploa…MikeW 26 views 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM
-
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 126 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 45 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 21 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 22 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 23 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 32 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 909 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 11 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 505 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 48 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 12 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM