OTBI
Discussion List
-
Data-model from Analysis not working after 20BSummary Data-model based from Analysis keep saying path not foundContent After receiving 20B update, it seems like our Data-models are having issues (which are tied to A… -
Please Save BI Answers Direct Database Query SQL Definition before 19D UpgradeSummary Please save your BI Answers Direct Database Query SQL definition before 19D UpgradeContent Please Note: This notice does not affect BI Publisher SQL data models …User720640-Oracle 149 views 5 comments 2 points Most recent by User_R6A85 Reporting and Analytics for HCM -
Compensation Salary History Details Subject Area not returning termsSummary Compensation Salary History Details Subject Area not returning termsContent Compensation Salary History Details Subject Area not returning terms. It will only re…TerryM01 26 views 23 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Is there delivered Affirmative Action Report for US in Oracle HCM CloudContent Hi All I was told there should be delivered report for Affirmative Action Report for US as its statutory requirement But I could not find one. Can you please let…Naveen Jayaraman-48236 118 views 1 comment 1 point Most recent by Tony Johnson-Oracle Reporting and Analytics for HCM -
Is it possible to view reports as employee?Content Hello experts, our customer would like to enable a user to see a specific OTBI report. However, at the same time this user cannot have access to My Team and My C…Valerio Curzi 94 views 9 comments 2 points Most recent by AshishERPCloud Reporting and Analytics for HCM -
Odbc driver returned an error (SQLExecDirectW)Summary Error running reports for users in Production: Odbc driver returned an error (SQLExecDirectW).Content Hoping someone has encountered this issue before. We curren…AIT 50 views 4 comments 0 points Most recent by User_2025-01-30-21-52-52-008 Reporting and Analytics for HCM
-
Benefits ReportingSummary Dependent that is an employee OTBI or BIPContent how do we determine that a dependent is an active dependent or a certain plan and an active employee at the same…User_2025-01-28-01-44-03-184 127 views 2 comments 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM -
Benefit Pending Action Item informationSummary Need back-end table name for Benefit Pending Action Item informationContent Hello Everyone, Can anyone share the table name/column name to identify benefit "Pend…
-
Intermittent Error Preventing Report FilteringSummary When applying filters to our Business Unit Column we are intermittently unable to do so when creating OTBI analyses and when using previously created analyses.Co…Thomas Griffiths 24 views 5 comments 0 points Most recent by User_2025-01-30-21-52-52-008 Reporting and Analytics for HCM
-
Joining Workforce Events to Person Real TimeSummary Having trouble getting the data to align between the two subject areasContent Hello Everyone, I've created a simple example of an analysis we're making to see ho…Rob F 34 views 11 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Sample Report: Salary Change Date Prompt (updated)Summary Sample salary change report using a date promptContent Salary Change Report Date Prompt This is part of the series of sample reports to use in your cloud environ…Gail Langendorf-Oracle 511 views 3 comments 4 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
OrganogramSummary Organogram RequiredContent Hi, I have come across many previous posts regarding organogram / organisational charts and none deliver a proper organogram whereby e…User_2025-02-05-22-44-35-842 51 views 37 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Row Limit? Missing RowsContent Hi all - I have a query (Logical SQL) that I use to run for changes. It runs Assignment and Salary changes. When I ran the report in April, it pulled back ~132K … -
Seniority hoursContent We are developing a report using OTBI and one of the columns is to populate employees Seniority hours. Wondering which subject area contains that information? We…User_WHB5J 36 views 6 comments 0 points Most recent by Aliasgar Khambhaty-Oracle Reporting and Analytics for HCM
-
Analysis for finding positions with more than one EmployeeSummary Need a report that shows a list of positions that currently have more than one Employee in the positionContent I am trying to build an audit report that shows th…User_2025-02-04-08-51-08-912 38 views 6 comments 0 points Most recent by User_2025-02-04-08-51-08-912 Reporting and Analytics for HCM
-
20c Subject Area Changes - Transaction AdministrationSummary Additional fields added to Human Capital Management - Transaction Administration Real TimeContent I have been reviewing the readiness docs for 20c HCM, but I hav…ndryden 56 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
OTBI Report with Position Headcount data as of current month and as of previous month in the same anSummary Current and Previous month data in the same OTBI analysis based on AsOfDate variable parameterContent Hello All, Request help! Trying an OTBI report which includ…pooja yelsangikar-Oracle 160 views 10 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Multiple Rows For Assignment ManagerSummary Updated the assignment manager job today and each employee now has multiple rowsContent Hi, Today we ran the jobs to update the assignment manager fields. After …
-
Could not able to fetch Manager Hierarchy for Contingent workers using Workforce Management - WorkerSummary Could not able to fetch Manager Hierarchy for Contingent workers using Workforce Management - Worker Assignment Real Time Subject AreaContent Hi Experts, We are …Harish Kumar Kovi 25 views 2 comments 0 points Most recent by Harish Kumar Kovi Reporting and Analytics for HCM
-
How to increase the number of characters for a OTBI Analysis columnContent Hello experts, a text column returns truncated text while in Core HR I can see the entire text. As a result, I think that it depends on the report configuration.…Valerio Curzi 37 views 5 comments 0 points Most recent by Valerio Curzi Reporting and Analytics for HCM
-
OTBI - Line Manager cannot report on future dated joinersSummary Line Manager cannot report on future dated joinersContent We have a requirement for Line Managers to see future dated joiners and internal movers. We are using t…User_2025-02-05-05-26-04-705 54 views 12 comments 0 points Most recent by User_2025-02-05-05-26-04-705 Reporting and Analytics for HCM
-
Absence Days between DatesSummary Data must be returned where the absence is between two datesContent Hi all Can anyone help me with a problem where the Workforce Management - Absence Calendar De…Dawn Cawston - CPS 59 views 4 comments 0 points Most recent by Dawn Cawston - CPS Reporting and Analytics for HCM -
Pivot Salary Data For Employee PopulationSummary Want to display salary data for employee population without summing the dataContent Hi - I am trying to create a pivot table in OTBI that would show salary data …Kyle Norris 30 views 9 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Parent Manager Name FormatContent How to switch format from First Name Last name to Last Name, First name/ Any ideas? Thank you.Mike Borghoff 24 views 10 comments 0 points Most recent by Mike Borghoff Reporting and Analytics for HCM
-
Need Public Holiday List in OTBI ReportSummary Need Public Holiday List in OTBI Report based on Country and year parameter.Content Need Public Holiday List in OTBI Report based on Country and year parameter. …User_2025-02-04-17-42-01-535 57 views 3 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Error occurs while calling remote service ADFService11G. Details: Runtime error for service -- ADFSeSummary OTBI Analysis is running out with above error after 20B upgradeContent Hi All, One of the Analysis which is having below subject areas is running out in error (c…
-
Using Performance Tiles as Filters/LinksContent Hi all, I have a report where we are using infolets to show the overall counts of transactions. I'd like to make it possible to click on the count and have the r…User_2025-01-31-00-25-12-234 11 views 2 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM
-
How to Hide Prompt Section in Dashboard OutputSummary How to Hide Prompt Section in Dashboard Output While printing it.Content Is there a way to hide the Prompt from the Dashboard when we print the Dashboard output …Jagdish Varadraj 133 views 4 comments 0 points Most recent by Krishna Manmohan Reporting and Analytics for HCM -
Fusion HCM Analytics Delivered Reports & DesshboardsSummary Fusion HCM Analytics Delivered Reports & DesshboardsContent Hello, I am looking the presntion/documention of the Fusion HCM Analytics Delivered Reports & Desshbo…Sohail Nawaz 64 views 3 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Editing a copy of a report is affecting the original oneSummary Editing a copy of a report is affecting the original one.Content Hi all, Don't know how simple might be this question, but i've made a copy of a report to edit i…Pedro Teixeira 32 views 9 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM