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 153 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 192 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 12 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 90 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…
-
OTBI ResourcesContent Resources to help you get the most from OTBI. Training Oracle Applications Analytics Cloud Service Videos (Oracle Learning Library) - many are no longer availabl…Julian Challenger-Oracle 40.3K views 94 comments 118 points Most recent by Raluca Vulpe Reporting and Analytics for HCM -
How to pull Survey results from a Journey in OTBISummary: Cannot seem to pull any results in OTBI using 'Workforce Management - Survey Journey Responses Real Time. Specifically need to easily and cleanly see Questionna…
-
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 188 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 35 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 18 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 619 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…
-
Absence Balance Report Based on Balance Calculation DateSummary How to get the absence balance to include future dated absencesContent In the existing report, balances are reflected as of today; however, would like it to refl…User_2025-01-28-20-43-56-568 1.6K views 20 comments 3 points Most recent by Gaurav Bhardwaj Reporting and Analytics for HCM -
Is there a table which stores Absence balance for future date of and incremental planSummary: We are looking for a table or sql query which gives Absence balance as on future date. Absence plan is incremental, and accrual process will run for every bi we…Abhishek Jois 41 views 6 comments 0 points Most recent by Gaurav Bhardwaj Reporting and Analytics for HCM
-
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 15 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 22 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 121 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 25 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 6 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 134 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 12 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 14 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 13 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… -
Salary details are not getting fetched for Subject area Recruiting-recruiting real timeSummary: I have seeded compensation manager role with required duty role Compensation Transaction Analysis Duty and Compensation Transaction Analysis but still i am not … -
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 20 views 3 comments 0 points Most recent by Karen Costakes 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…