OTBI
Discussion List
-
pivot table sorting dataSummary: How to sort data in pivot table view Content (required): I created a report using a pivot table, but the data in pivot can be sorted in ascendent or discendent … -
Current report structure in OTBISummary: Please could we have a download of current report structure in OTBI for custom folder area? Ideally, we would like a list which contains all the folder/sub fold…Madhuri Brammadevara 22 views 3 comments 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM
-
Calculations not working when joining Payroll – Element Entries Real Time and Workforce Management –Summary I have some calculations insing information from Payroll – Element Entries Real Time, but when adding fields from Person real time the calculations are not shown…
-
What role or privilege do we need to access "Inherit Segment Value Attributes" ESS JobSummary: We would like to understand what role or privilege do we need to access "Inherit Segment Value Attributes" ESS Job. We tried searching for this in OTBI and "Man…
-
Report for failed attempted login with error messageSummary: Need to create a report for audit all the failed attempted logins with the error message. Content (required): Person number, name, date/time of login, error mes…
-
LRU Registration ReportSummary: LRU Registration Report Content (required): Hi Team, Greetings! We have the details for LRU (Legal Reporting Unit) Registration defined under "Manager Legal Rep…Parag Hiremath 12 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Talent Management DashboardHi, I am working on a dasboard to count the number of employees have a performance document in the worker evaluation status. I have both a KPI and a drill down report. T…Matt Houser 4 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Permissions for Customized Seeded ReportsSummary: When we're going to customize a seeded report, shall we retain the permission that has been set up in the customized folder? For example: Job Offer seeded repor…Welsey 19 views 1 comment 0 points Most recent by Ramanathan Sockalingam Reporting and Analytics for HCM -
Need table names or SQL for Approved OTL timecard details in BIPSummary: Hi Team, I Need table names or SQL for Approved OTL timecard details in BIP. We need particular person entries and along with approver comments. Navigator->my c…Janardhan ACS-Oracle 22 views 3 comments 0 points Most recent by Durgadevi-Oracle Reporting and Analytics for HCM
-
Where can I find tax registration Number for Reporting UnitSummary: Please can anyone tell me where the tax registration number is in OTBI, I am wanting to add it to a report but cannot find it. Content (required): I am looking …Sharon Harper 41 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Learning reports / dashboards - any good examples to share?Summary: Any learning reports or dashboards that people would like to share? Content (required): My company is moving from managing all training administration on spread…Lee-GT 14 views 3 comments 0 points Most recent by Abdul Rauf Mohammad-Oracle Reporting and Analytics for HCM
-
how to build OTBI report that give grade rate name by citySummary: Content (required): how to build OTBI report that give grade rate name by city. I am encountering a situation wherin I see multiple salary plans or grade rate n…
-
Manager Name not updating in AnalysisContent Hi, I have an OTBI analysis that display incorrect information from regional and resource managers. For some reason a manager change is not coming through despit…Javier Quiñones 72 views 5 comments 1 point Most recent by Geraud Andreux Reporting and Analytics for HCM -
OTBI Report as on effective dateSummary: Want to generate OTBI report as on effective date other than sysdate Content (required): We have a requirement to fetch data as on 1 day before the current date…
-
How to fetch details from Worker Assignment Real Time Subject area as of (current_date - 7)Summary: Hi All, In an OTBI Analysis, I'm trying to fetch all the employees who has their Assignment Category changed to "Leader" in the past week. But I don't see a sub…OneK 29 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
What particular role or privilege needed to gain access to Manage Report Jobs page?Summary: What particular role or privilege needed to gain access to Manage Report Jobs page as well as the list of scheduled report jobs? Here's the example:
-
Current HTML Markup values are not working after 23B updateSummary: I've added BIP report to the UI using the HTML Markup. However, when I entered its HTML Markup values, the dashboard is not working as expected. Upon checking, …
-
Language translation in oracle standard notificationsHi, I want to edit the rtf template according to the language of the standard notifications that I want to edit in Oracle. For example, where can I edit the Turkish RTF …Cansel Karasoy 30 views 7 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
Unable to access Recruiting - Recruiting Real-Time OTBI report using the custom roleSummary Unable to access Recruiting - Recruiting Real-Time OTBI report using the custom roleContent Getting below error while accessing Recruiting - Recruiting Real-Time…Venkatraman G 38 views 7 comments 0 points Most recent by Komal_Arora Reporting and Analytics for HCM -
Audit Report for all tax code changes received from HMRCSummary: Need a report showing tax code changes from HMRC Content (required): Can anyone help with suggesting how do I go about building a report based on tax code chang…Isabela Radivoi 55 views 1 comment 0 points Most recent by Anca Andronic-Oracle Payroll and Global Payroll Interface (GPI) -
Profile strength report for checking Talent profile completion status reportingProfile strength report for checking Talent profile completion status for the Organisation reporting? I am not able to find the field for profile strength in OTBI or BIRevanth.Rondla 11 views 0 comments 0 points Started by Revanth.Rondla Reporting and Analytics for HCM
-
Workforce Compensation Real Time issue in production vs test podsWe created a report in our test environment and vetted it fully. Everything is being pulled from the Workforce Compensation Real Time subject area, we are not using more… -
Active Organization Name for PromptSummary: Hi - I have a BI report that we're using for a dashboard along with some prompts for filtering the report. We have a Business Area (Division) filter but I wante…
-
Ability to Report on Talent Profile Strength Indicator (Content Section Completion)Summary Ability to Report on Talent Profile Strength IndicatorContent Hi All, I am searching for some information on how I can report on employee talent profile completi…rebecca levine 63 views 2 comments 0 points Most recent by Revanth.Rondla Reporting and Analytics for HCM -
Adding Worker Payroll Name to Custom Timecard ReportI have multiple custom timecard reports being developed. In these reports, I need to include the Pay Frequency (Payroll Name/Worker Payroll Name). The reports are develo…
-
Timecard Time Attributes Not Appearing in OTBI Timecard Subject AreasWe have Time Attributes set up that can be viewed in the application by navigating to Setup & Maintenance -> Workforce Deployment -> Time and Labor -> Time Entry Layout …
-
Add a data into a domain - direct accessContent (required): I would like to be able to integrate the data "Group contract type" (see enclosed picture) directly through the domain "Workforce management - Assign…Jacqueline GRANDIN 4 views 2 comments 0 points Most recent by Jacqueline GRANDIN Reporting and Analytics for HCM
-
how to join subject area work relationship real time with worker assignment real timeHello, I have an otbi report in there already have subject area (WorkForce Management Worker assignment Real Time) and (WorkForce Management Worker Person Real Time) and…Mirza_Adeel 12 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
How to create a historical report with actions reasons in OTBI?Summary: How to create a historical report listing all actions/reasons since the hire date including future dated action reasons/ Content (required): I'm using Worker As…Stefaan Onderbeke 17 views 0 comments 0 points Started by Stefaan Onderbeke Reporting and Analytics for HCM
-
Round to nearest 0.5 decimalSummary: Leave balance in hours, converted to days to 2 decimal points. Content (required): My formula is FLOOR("Front-Loaded Plan"."Accrual Balance"/7.4) however for so…Dawn Cawston - CPS 20 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM