OTBI
Discussion List
-
Unable to create OTBI AnalysisHi to all, as an administrator user, when I try to create a OTBI Analysis I'm only able to view my own informations. I can't see the information about other users. The s… -
Pension and annual salary data in one reportSummary: Hi, We are trying to build a report which provides information on an employees pension and annual salary. The report is built combining subject areas. When comb…NusratB 24 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How do we find out the date a leave of absence was approved?Summary How do we find out the date a leave of absence was approved?Content We are using the 'Workforce Management - Absence Real Time' subject area and using the 'Assig…
-
Assignment Start Date Explained?Summary: Could an Expert help me understand how when Adding Assignments to a person, the Assignment Start Date field works in the Workforce Mgmt Subject Areas? The issue…
-
How to pull correct Learning Assignment Status valuesSummary: Cannot determine the logic to pull the correct Status value that is displayed in Status column of Learning Assignment Page. The Table has two Status fields and …Vanessa Gepitulan 280 views 6 comments 0 points Most recent by Vanessa Gepitulan Reporting and Analytics for HCM
-
Extract the ID of a department (going active on 01 october) from FusionHello, In Fusion we have created a department that will become active on the 1st of October. For our integration with Taleo I need the Department ID of this department a…
-
Absence Headcount - Percentage of Employees on Leave by JobSummary: Divide count of employees by total number of employees Content (required): Hello experts, As the title suggests, I was trying to fetch the percentage of employe…
-
Workforce Compensation Plan delivered reports and dashboardsSummary: Content (required): Hello experts, are there any delivered OTBI analysis and dashboards for Workforce Compensation Plan module? If so, please could you share th…Valerio Curzi 1 view 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Pull all of one HR Action as long as another HR Action doesn't exist afterSummary: Long title after contemplating how to ask this...:) My analysis pulls all HR Actions that equal 'Termination.' What I need to do is exclude any worker who had a…
-
How can we fetch data under Performance Goals for the field "Manager Rating" in OTBI.Summary: How can we fetch data under Performance Goals for the field "Manager Rating" in OTBI. We are able to fetch data only for the field "Overall Summary Manager Rati…
-
Report shows no results for certain usersHello, We are facing an issue regarding the ability to view a report of the subject Area of Workforce Management - Checklist Real Time. Here is the report that we have c…Ioannis Adamou 16 views 1 comment 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to I pull a report on departments that shows the hierarchy level ?Summary: I need an establishment report with position details. Content (required): We have recently migrated to Oracle Fusion and are still getting our heads around it b…Isabela Radivoi 162 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
OTBI report - employees' action and action reasonHi all, we are having difficulty in exporting the Action Code/Name and Action Reason Code/Name for each employee. We can connect 'Person Number - Reason Code' but, canno…Lia P 260 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Assignment and Person Information for Whole Employee PopulationSummary: Hi - I have created a report that is supposed to pull in a combination of Assignment data, comp data, work relationship and person real time information (4 subj…Kyle Norris 12 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Is it possible to build OTBI report to show have 0 incumbents for active positions ?Summary: Content (required): Need to build OTBI report to show have 0 incumbents for active positions along with Position HC Version (include the version you are using, …Nikhila 22 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Reflect one row when there are duplicate rows of dataSummary: Request received to have report with multiple rows of data for workers to reflect one row for each worker, but still include all data. Hopefully the screenshot …Jessica D 2 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Help -> Audit/field Change Reports (Old Value -> New Value) - OTBI or BIPSummary Help -> Audit/field Change Reports (Old Value -> New Value) - OTBI or BIPContent Hello, Looking for a quick help, please. Searched the archives but could not fin…SantoshKumarBhairi 194 views 12 comments 0 points Most recent by Ninja Reporting and Analytics for HCM -
Case Statement Length of ServiceSummary: I would like some assistance on a case statement calculating length of service. Content (required): I am creating a case statement that looks at the assignment …
-
how can we go with below requirement in OTBI between 2022-23 data of absenceSummary: Hi Team, we have requirement in between 2022-23 data for absence accural balance for annual leave , enchased and lapsed. by using accural real time subject area…AjayKumar Maddipati 22 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Pivot table column blankSummary: Content (required): Hi, I've created an OTBI report using the Workforce Performance - Performance Rating Real Time subject area, with a Pivot for the Manager Ra…Joe Dorrian 22 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Identify all actions/pages that contain Business TitleSummary: I need to identify all actions/pages that contain the Business Title in order to hide them, because client doesn't have them updated. Content (required): Versio…Stela Martins-Oracle 22 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Grade step start date per employeeSummary: Content (required): Hi, would anyone be able to point me in the right direction for creating a report that tells me how long each employee has been at their cur…Leanne W 11 views 4 comments 0 points Most recent by Kathi Chenoweth-Oracle Reporting and Analytics for HCM
-
How can I pull all reports and their permissions available /shared folder/custom/ pathSummary: How can I pull all the reports available in "/Shared folder/Custom/" path with their permissions through backend(sql) or any other alternate, with environment h…Nidhi S 326 views 4 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Assignment EFF Rest APII am trying to query from postman with the relevant platform_id information using Assignment eff rest api,(/hcmRestApi/resources/11.13.18.05/emps/{empsUniqID}/child/assi…Cansel Karasoy 12 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM -
calculate the past experience in HCM BI ReportSummary: calculate the past experience in HCM BI Report Content (required): My client requirement is to calculate the past experience and current organization experience…
-
Measurement to sum Actua Effort for yeach years starting from Current_DateDears, i've been trying to create performance tiles based on following measurements so to have sum of actual effort for the last 3 years splitted by years: Sum of Actual…
-
Total Salary by Division for the first of each month - OTBISummary: I feel like maybe this is very obvious and I'm overlooking it. But here it goes: We want a report that total salary for a given division on the first of each mo…Monique 12 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
In which subject area can I find 'Business Title'Summary: I need to create a report/analysis, showing all assignments, where job is not equal to Business Title. Content (required): I have started on an analysis with su…Morten Graae 529 views 4 comments 0 points Most recent by Stela Martins-Oracle Reporting and Analytics for HCM
-
Custom Error message on OTBI Reports / Dashboard Reports DisplaySummary: We need to display the custom error message on OTBI reports. Please provide the workaround for this. Content (required): OTBI Reports / Dashboard Reports - Disp…
-
How to create a report with manager management levelSummary: report with manager management level Content (required): Hi, I need to create a report with every employee of my company and relavite manager. I need also to re…Alberto Americi 92 views 10 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM