OTBI
Discussion List
-
How to restrict the data in OTBI report based on AOR (Area of Responsibility)We have created HCM reports from the Absence module, Goals and performance, etc. and we need to restrict the data based on AOR. Is it possible to restrict the data in th…Vikas V. Kamat 196 views 7 comments 0 points Most recent by GPOtimization Reporting and Analytics for HCM -
Need inputs to restrict OTBI reports only based on the AOR roleSummary: Need inputs to restrict OTBI reports only based on the AOR role for users that have both AOR and Line Manager data access roles. Content (required): We have cre…Sakthi priyanka B-Oracle 245 views 3 comments 1 point Most recent by GPOtimization Reporting and Analytics for HCM
-
OTBI Worker Attributes Changed After Redwood EnablementSummary: Our reports stopped working in Production after migrating to Core HR Redwood. We’ve observed changes in OTBI column attributes when comparing Redwood and non-Re…Josel Pleyto 16 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Can you help me add the assignment status (Active/Inactive/Suspended,etc) to this SQL query?Summary: Hello team! I have this code, but I don't know how to add the assignment status (Active/Inactive/Suspended, etc). Could you please help me with that? Thank you …Claudia Linares L 105 views 13 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
The datatype of this column is NULL and such columns are not supported in the BICC schedule extractWe are facing error "The datatype of this column is NULL and such columns are not supported in the BICC schedule extract" for few columns in HcmTopModelAnalyticsGlobalAM…
-
Document of Record Drill to Document DetailsSummary: This report uses Deep Links for Document Records to navigate directly to the worker's DOR from the report results without additional clicks or navigation. Conte…Melanie Mahon-Oracle 196 views 4 comments 7 points Most recent by Samantha Collins Reporting and Analytics for HCM -
Need to calculate month on month attrition percentageWe need to calculate month on month attrition percentage on the basis of formula = (Attrition count of that month *100)/(Average of (Headcount as of first day of month a…Shaarif_Hussain 38 views 8 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to fetch the physical address of Geo coordinates that we have in Time records?Summary: On the OTL page, we can view the latitude and longitude of the geo-location from which an employee submits their timesheet. Additionally, there is a button that…ManikandanRajagopalan 33 views 4 comments 0 points Most recent by ManikandanRajagopalan Reporting and Analytics for HCM
-
How to get Journey Survey Responses?Summary: How do I report the responses from Journey Surveys to the LMs or HR? Can anyone suggest table names for BI reports or Subject areas for OTBI? Content (required)…
-
how to limit values in OTBI prompt when using SQL Results in choice list values.Summary how to limit values in OTBI prompt when using SQL Results in choice list values.Content Hi All, We have a requirement to show values in prompt as per AOR/securit…User_XT9HW 669 views 7 comments 0 points Most recent by Gerald Hartmann-Oracle Reporting and Analytics for HCM
-
How do I return vacation request data in the transaction console, which tables can I use?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
HCM Extract and BI Publisher - GC overhead limit exceededTeam, We have a HCM Extract which is invoking the BI Publisher to generate PDF output. But we are getting an error and HCM Extract is not generating any PDF output. Erro…
-
How to provide the gap between the 2 bars in bar graphSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Narendar Rao Naineni 14 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI output is different for 2 different usersSummary: Hi, We have a custom OTBI report which is scheduled to send report to the Business Users. This report shows that 100 employees have missing family contact infor…Sailajad 26 views 8 comments 0 points Most recent by Yves_Guyon-Oracle Reporting and Analytics for HCM -
Issue: Unable to expand Calculation Components Detail folder in Payroll - Calculation Cards Real TimSummary Users building reports on Calculation Cards Subject Area when try to expand Calculation Components Detail folder, the folder doesn't expand. Solution is provided…Tanvi Jain-Oracle 136 views 1 comment 2 points Most recent by Al Darabaris Reporting and Analytics for HCM
-
View Reports and AnalysisSummary: View Reporting and Analysis on the Cloud Help Center Content (please ensure you mask any confidential information): There used to be a link for Reporting and An…AVorster-Oracle 27 views 4 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
Is there a way to set a section to collapsed state by default on OTBI dashboard page?Summary: Need solution to set section collapsed on load of dashboard page. I understand there is an option to save the customization for each user but it is not viable t…Shreya Agarwal-Oracle 5 views 0 comments 0 points Started by Shreya Agarwal-Oracle Reporting and Analytics for HCM
-
How to report on details held in Past Incumbents section of Position DetailsSummary: We need to add some of the fields held in 'Position Details' into an existing report but cannot find within any tables columns that correspond to the fields vis…
-
Report to say if employee has any direct reportsContent Hi, have a simple report that says something like PERSON NUMBER | Name | Department. I need to add an additional column that returns yes/no for if that employee …Mike Borghoff 132 views 7 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Is it possible to add a time zone prefix to an OTBI report?Summary: If I want my OTBI report's data to only display one specific time zone no matter the user's preferences, how would I do that for just one report? Could the pref…CCannadayCTR 17 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Unable to report on Guided Journey QuestionnaireSummary: We've created a guided journey questionnaire as part of the requisition process for hiring managers, however we are unable to report on the data. We've had an S…DanSut 21 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Difference between Oracle Delivered OTBI Report-Budgets Wrksheet & Budgets Wrksheet Worksheet MgnrWhat is the difference between these two out of the box OTBI reports? Budgets Worksheet and Budgets Worksheet for Worksheet Manager Path: /Human Capital Management/Compe…MeghnaDe 16 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Overtime status is not showing data in workrelation subject areaSummary: Hi Team, We had defined overtime status at job level. like below. but the information is not showing workrelationship subject area. Request you to help on to fi… -
Looking for a Applicant Report < Oracle delivered report>Summary Looking for a Oracle out of box report output - To display all candidate responses to the application questions/fields including the signature with date and time…Prabhu Krishnamoorthy 24 views 3 comments 0 points Most recent by Karen Long Reporting and Analytics for HCM -
Current approval status table name for development goalsUnable to get approval status for development goal: Need a table name and SQL query for development goa approval status to check whether the goal is approved? rejected o… -
Trying to find a Link between Career Site and RequisitionSummary: We are trying to derive the career sites where a specific job requisition is published. Can you point us to a REST API which can provide this information ( alre…
-
Select performance goal seeded report customization in not working in Production.Summary: Select performance goal seeded report customization in not working in Production . where as working in TEST pod. Below are the steps followed to customize the r…
-
Subject Area to determine the Legal Entity details in Workforce Succession Management Subject AreaSummary Subject Area to determine the Legal Entity details in Workforce Succession Management Subject AreaContent Hi , While building some reports for the talent Module,…Manisha Chakraborty 112 views 3 comments 1 point Most recent by Atif Nisar Reporting and Analytics for HCM
-
Help with setting up Map View in OTBI - Map showing marker on incorrect StatesSummary: I'm looking to create a headcount by State/City/County report and use the map feature to display the results. State appears to be working correctly and the head…
-
How to retrieve Work Day Definition (Weekly Working Hours section) using OTBIContent Hello We need to extract the information: Work Day Definition (Weekly Working Hours section) using OTBI. USA are using this information to track Shift informatio…Lucile Fleischman 100 views 3 comments 1 point Most recent by Thomas Samuel19 Reporting and Analytics for HCM