OTBI
Discussion List
-
Report display incorrect in dashboardSummary Report output on dashboard shows fewer rows of data than expectedContent I'm having some irregularities when trying to run an OTBI Analysis embedded in a dashboa…E McDonald 58 views 9 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Index Match formular for OTBIHi all, I am after some help on a formular that works similar to an index match formula in MS Excel I'm after the Legal Employer value of Managers using the manager pers…Tina T 19 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Query that retrieve Eligibility Profile from Benefit ProgramSummary: Hello! I need some help to finish some query, and it envolve Eligibility Profiles in benefit Program. Is there a table that I can get the Eligibility Profile th…Matheus Roberto 123 views 1 comment 1 point Most recent by Monica Vijayashanker -Oracle Reporting and Analytics for HCM -
OTBI Report is not giving actual Absense start date and absence date insted it is giving Date StartSummary We developed a OTBI Report to get the Absence details using the subject area Workforce Management - Absence Real Time subject area.To get the absence start date …User_2025-01-30-17-37-30-647 80 views 2 comments 0 points Most recent by Neha H Sharma Reporting and Analytics for HCM -
Is it possible to hide unnecessary buttons from OTBI Dashboard?Summary Is it possible to hide unnecessary buttons from OTBI Dashboard?Content I designed an OTBI dashboard, which when I run shows OTBI Header buttons and search option…Dharmendra Shukla 86 views 10 comments 2 points Most recent by AMIT KUMAR YADAV Reporting and Analytics for HCM -
Trying to pull Comments from Mid-Year Performance document into a reportSummary When Employee/Manager Comments fields are added to performance report, errors outContent I have a request to pull a report of all Goals and include the Employee …User_2025-01-28-20-43-56-568 64 views 4 comments 0 points Most recent by Catherine Abi Samra Reporting and Analytics for HCM
-
DOR Report: How would I create a report that allows me to see DOR data by employee?I am trying to build a report that shows the following information for Document of Records, but the fields I add show no data. Would it be possible to know which fields …Jay_Brannan 105 views 11 comments 0 points Most recent by Jay_Brannan Reporting and Analytics for HCM
-
Is it possible to add candidate Hire date using OTBISummary: We have a requirement to include hire date in the report. The intention of the report is to capture all offers that are created, even if they don't end in hire.…Christina Roy 25 views 1 comment 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM
-
Field to report the "Last Hire date"Summary Field to report the "Last Hire date"Content What is the field present in OTBI to report Last hire date. We are looking for the Field to populate Hire date if the…Prabhu Krishnamoorthy 344 views 3 comments 0 points Most recent by Gunjan Bobade Reporting and Analytics for HCM -
concatenate error in otbi reportSummary: CONCAT(NVL(TO_CHAR("Worker"."days"), '0'), ' Days, ', NVL(TO_CHAR("Worker"."months"), '0'), ' Months, ', NVL(TO_CHAR("Worker"."year"), '0'), ' Years') i tried t…
-
OTBI - recruiting - recruiting real time > Job Application issueSummary: Hi everyone, I'm customizing the 'Applications by Requisition' standard OTBI analysis. Trying to add the candidate Interview feedback field in the current analy…Saher 28 views 3 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
OTBI report only showing an individual's supervisor and managerSummary: I have a requirement to create a report showing each workers named supervisor and line manager (mostly these are the same person, but in some cases they're diff…Rich M 46 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Dashbord prompt issueSummary: Hi, I need assistance concerning the OTBI Prompt. I created a recruiting OTBI dashboard by combining two subject area subject areas in my report, 'Recruiting - …
-
Assigned Performance Document Manager not showing Assigned Indirect DocumentsSummary: I have created a dashboard that includes an OTBI report showing Performance Documents by When I run the report I can see all the Performance Documents assigned …Aaron Reynolds 22 views 1 comment 0 points Most recent by Andrew Gillibrand-Oracle Reporting and Analytics for HCM -
Direct and indirect reports in dashboard promptHi There, We have designed a custom dashboard with is using the subject area Workforce Management - Checklist Real Time. We have a requirement to display direct and indi…MadanMohan 10 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Unable to add SQL based Dashboard promptSummary: Hi All, I am trying to add an SQL based Dashboard Prompt and facing the Error: Failed to load(Error during query processing (SQLExecDirectW). The SQL I tried to…Abhishek Bhaskar 105 views 6 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
In (Fusion HCM)Seniority Date Page How to hide custom field based on selected Rule from Drop DownREQURIMENT: When we select the Rule Is Job Seniority Date section from the drop-down list then the custom field is Seniority Date report needs to be visible under Senior…Ravindr-Oracle 73 views 1 comment 0 points Most recent by Aliasgar Khambhaty-Oracle Human Capital Management
-
Specialization Title and Number in OTBI Learning ModuleHi Can you please tell me where can i can able to get the Specialization Title and Specialization Number in the Learning Module of OTBI (Workforce Learning - Learning Re…Shivam_123 86 views 7 comments 0 points Most recent by David Bean - BW Reporting and Analytics for HCM
-
Case when statements to evaluate values based on a groupSummary: Content (please ensure you mask any confidential information): I am working on an OTBI report based on the Workforce Management - Checklist Real Time subject ar…Giuseppe Cannova 47 views 7 comments 0 points Most recent by Giuseppe Cannova Reporting and Analytics for HCM -
Duplicate element entry report with entry detailsSummary: I have a requirement where I need to report on more than one element entry for a person where the input values differ. Attached is the OTBI analysis details on …Vibha Pandey - Oracle 36 views 3 comments 0 points Most recent by Anca Andronic-Oracle Reporting and Analytics for HCM
-
How To Embed OTBI Report To Responsive UI (Performance)Content Requirement ============ Manager able to see OTBI absence report using me -> career performance page -> Performance-> Employee Performance Document (Specific Emp…AvaneeshJain 316 views 14 comments 0 points Most recent by nanda.patil Reporting and Analytics for HCM -
Filter Inactive Requisitions in ReportsSummary: Inactive requisitions can be filtered on application by selecting the check box filter. What is the corresponding column (OTBI or BIP) which can help to filter …
-
OTBI Hourly Rate calculation for employees on monthly pay cycleSummary: I am modifying an existing report on employee's salary. The organization has bi-weekly and monthly pay cycles. When calculating the hourly rate some monthly emp…
-
Rating data is displayed in different rowsSummary: For the Perfomance Document Section I want to have two cases illustrated in two different columns: I wrote a Case-statement that if Perfomance Document Section …
-
How To Add A New Column With Custom Date FieldSummary: I have an OTBI report where I need to add a column (see expected date column below) that when there is a Termination Date it shows the Termination Date BUT when…
-
how to create Dynamic Parameter in Logical SQL in OTBISuppose a field/column- Effective Date of Balance in Payroll should be between two dynamic parameters such as Start date and end date. Start Date and End date will be as…Dona Das-Oracle 127 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Hi Team,I want to apply Security on OTBI Dashboard using Area of ResponsibilitySummary: Hi Team,I want to apply Security on OTBI Dashboard using Area of Responsibility so that HR can see only their BU data not whole data Content (please ensure you …Nalin Jha 26 views 1 comment 0 points Most recent by Rambabu Laveti-Support-Oracle Human Capital Management
-
Where to find HR Compliance and HR Operational ReportsWe recently went through an Oracle implementation, and was wondering where can I find HR compliance and HR operational reports. Our Implementation partner mentioned that…Ameya_J 8 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM -
Report to fetch the user logs in the system.Summary: Hello We have come across a requirement where we need to understand if there are any standard pages/reports through which, we can fetch: The logs of all the use…Osama Qamar 9 views 2 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM -
Download a Spreadsheet that has a link to attachment in the Journey RecordSummary: Our company is looking for a quick way to audit the attachments that have been uploaded into Journey's Content (required): “Is there a way to download a spreads…