OTBI
Discussion List
-
How to obtain Source System ID for absence entriesSummary: Content (required): I have a requirement to use HDL to delete and then re-submit a large quantity of annual leave absence entries. I have an HDL file that I can… -
Getting error when person extra info flexfield is pulled in OTBI reportSummary: Getting error when person extra info flexfield is pulled in OTBI report Content (required): I am getting following error when I dragged and dropped one of the p…Swati U 23 views 2 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
Time to complete self-paced learningSummary: Is there a way to report on the time taken from launching a piece of self paces learning to the point it is finished? We have a lot of compliance offerings whic…Elizabeth Docherty 21 views 2 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Display OTBI without SecurityContent Hi all - we have a dashboard we display some reports on for users that do not have Fusion security (other than a standard employee access). For our BIP reports, …Prudence K 96 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Is Manager Display Name available in OTBI? What SA can be used?Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Hazel De Castro 22 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
OTBI challenges rendering null valuesSummary: OTBI challenges rendering null values. Content (required): Hi experts, We experiencing challenges to come up with a solution to correctly show the data in the O…Volodymyr Faranosov 114 views 4 comments 0 points Most recent by Volodymyr Faranosov Reporting and Analytics for HCM -
Need subject area to get the manager name of inactive employeesSummary: Need subject area to get the manager name of inactive employees Content (required): Hi, I need subject area to get the manager name of inactive employees. For e…
-
OTBI Subject Area not displaying Payroll Periods After a certain PeriodSummary: I am facing an issue where in the Subject Area ( Payroll Ruy Result Real Time ) is not fetching the Payroll Period Data of an Employee after a certain Period (s…Rajit Paliwal 11 views 5 comments 0 points Most recent by Sharon Harper Reporting and Analytics for HCM
-
Steps to create OTBI Report / BI Publisher Report for Planned Schedule → Time ManagementSummary: we need steps to configure Planned Schedule report which can be useful for HR Representatives and HR Admin which provides information of employees whose Worksch…
-
Learning ProgressContent we are trying to mimic the reporting for learning on the front end that shows progress (1/5) for the specialization or course but I can't find this field. see sc…Riti Malhotra 51 views 3 comments 1 point Most recent by Lanette Frank-Oracle Reporting and Analytics for HCM
-
Could not able to fetch various seniority dates through OTBISummary Could not able to fetch various seniority dates through OTBIContent Hi Team, We are looking to fetch different seniority dates like VLSR Date, Enterprise Hire Da…Harish Kumar Kovi 229 views 25 comments 0 points Most recent by Dannielle Dellucci Reporting and Analytics for HCM
-
How to put the information into one row and limit the duplications?Hi All, I've been working on building a report to show the employee's personal information (address, contact number etc) and include their emergency contact information …
-
Manage Seniority Dates subject areaSummary Need to know the subject area for reporting the dates in the Manage Seniority Dates action menuContent I'm looking for the subject area that can be used to repor…User_2025-01-29-22-47-27-383 136 views 18 comments 0 points Most recent by Dannielle Dellucci Reporting and Analytics for HCM -
Seniority Dates V3Summary OTBI Subject Areas to Report on Seniority Dates V3Content Does anyone know if the Seniority Dates V3 are available in any OTBI Subject Area? We need to be able t…Lindsay Lamont 266 views 28 comments 0 points Most recent by Dannielle Dellucci Reporting and Analytics for HCM -
Union for 2 reportsSummary: How can I combine the output of 2 reports into one output Content (required): I have two reports, both using the same 2 Subject Areas (Workforce Management - Wo…Joe Dorrian 32 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Usage of BI System RoleSummary: Usage of BI System Role Content (required): Hi Team, We would like to know the usage of BI System Role. Please share your knowledge on the same. Version (includ…Vasanthakumar Ravi 25 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
How to query the organizations in the Organization List of an Organization Security Profile?Summary: How to query the organizations in the Organization List of an Organization Security Profile? Content (required): The Organization List section of the Organizati…User_2025-01-25-06-00-22-809 533 views 5 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
OTBI Reports on agents and delivery recipientsSummary: Hi, any reports that can give you the report agents, including the schedule and the list of the recipients (by username or email address)? Thank you! Jenia Cont… -
Provide access to OTBI report by Area of Responsibility by BUSummary: Content (required): We have a requirement that the user will have only Employee and/or Line Manager Role and they should be able to fetch the employee records i…Vinay Gharge 255 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Sql Query to Fetch the Last Modification Date and Last Modified By Details of SSOSummary: Can any one please help with a sql query to get the last modification date, last modified by, Created by details for SSO configuration. Content (required): Vers…MilanMohanty 276 views 2 comments 0 points Most recent by MilanMohanty Reporting and Analytics for HCM -
Embed bursting report content in body of email?Summary: Embed bursting report content in body of email? Content (required): Hi all, Hoping someone can advise if it is possible to embed report content within the body …Luke.Findex 53 views 3 comments 0 points Most recent by Aaron Hager Associated Bank Reporting and Analytics for HCM -
Turnover- Last 3 monthsSummary: Content (required): trying to add a filter for the last three months but nothing is pulling - I tried several sql expressions and repository variables xml attac…Riti Malhotra 42 views 8 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
DFF Values Missing from OTBI ReportContent Hi, I had an Analysis report that looked at 2 different DFFs from the Workforce Management - Documents of Record Real Time Area and reported back on the values i…Joe Dorrian 112 views 13 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Career Profile Dashboard: Filtering for Performance Tiles and Analysis Not WorkingSummary: We're creating a Career Profile dashboard and would like tiles/drill down analysis to display for employees whose career profile is In progress (1-8 out of 9 se…
-
Drill downs on DashboardSummary: Why does drill down report different numbers to dashboard when its the same report? Content (required): I've created a dashboard report for absence reasons, but… -
Missing time card OTBI/BIP report or analysisSummary: Content (required): Is it possible to create an OTBI or BIP report to show employees who have not handed in their time cards? Either standard or customized repo…Nicolas Vahman 459 views 4 comments 1 point Most recent by user5969783 Reporting and Analytics for HCM
-
How to make the shown value of one column depend on the value of another column?Summary: How to make the shown value of one column depend on the value of another column? Content (required): I've made an analysis from the assignment real time subject…Matti Bugge 104 views 4 comments 0 points Most recent by Matti Bugge Reporting and Analytics for HCM -
How to convert State Code into State name in BI AnalysisSummary Convert state code into description using subject area or table.Content Hi, I am building an analysis to get some information from a Person's payroll run results…Senthilkumar D 143 views 7 comments 0 points Most recent by Dhinakaran-Venugopal-Oracle Reporting and Analytics for HCM
-
Busting OTBI Myths - Using Agents to BurstContent Myth: OTBI doesn't support bursting, this is only possible in BI Publisher OTBI provides bursting via agents. Create an analysis that includes the lowercase comp…Julian Challenger-Oracle 427 views 18 comments 10 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
OTBI: Custom message while opening DashboardSummary: Custom message while opening Dashboard Content (required): We have a requirement where cutomer wants to have custom message of dashboard prompt. Can we edit OOT…