OTBI
Discussion List
-
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 11 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 1 view 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 92 views 6 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Workforce Profiles - Person Profile Real TimeSummary: Hi Expert, I need your assistance. I picked up multiple values by using the above-mentioned subject area and getting values from different sections of a person'…
-
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 61 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 81 views 7 comments 0 points Most recent by David Bean - BW Reporting and Analytics for HCM
-
OTBI Report coming up with blank dataSummary: We created an OTBI analysis in Recruiting in Real Time and data is coming up blank. Content (please ensure you mask any confidential information): Summary: We c…Hi.itsa.me 99 views 1 comment 0 points Most recent by Hassan El Bouihi-Oracle 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 41 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 32 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 286 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 111 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 21 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 2 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 3 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… -
Payslip Template ChangesHi all, I'm hoping someone can help me here. Our payslip is a customised version of the seeded one provided by Oracle that currently has every page in landscape. We'd li…MikeW 13 views 2 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
Time Zone in OTBI is not in sync with timezone set in user preferencesSummary: Time zone in OTBI/BI Publisher is not in sync with the time zone set in user preferences 1) How to find out all the users who have this mismatch? 2) How to sync…Keval_Shah 291 views 4 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
auditing for document of records viewwe have a requirement to get auditing report for who are viewing the document of records. we are trying to get it from OTBI but data is not coming from those columns. ca…Dara Nagasai 1 view 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM -
Comparing current Job Titles to previous week Job Titles in OTBISummary: Hi, I've been tasked to compare current Job Titles to Job Titles in the previous week. Can anyone assist in explaining how this can be done via an OTBI reports …GJ79 84 views 6 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI Comparison between two tables with the same fields in one tableHello! I would need some help with this idea of an analysis. The idea would be to make a comparison in a single table of two different tables with the same fields. Somet…
-
Absence calendar inc work patternSummary: Is it possible to report on work patterns/worker availability in OTBI Content (please ensure you mask any confidential information): Hello With the ability for …Helen Thomas 22 views 2 comments 0 points Most recent by Helen Thomas Reporting and Analytics for HCM
-
How to schedule an OTBI report using agent if the report has two dates as prompt?Summary When we schedule this OTBI report with agent, it pulls all data which are not in the range of default valuesContent We have an OTBI report which has "from date" …Linda Huang 395 views 7 comments 0 points Most recent by Sushant95-Oracle Reporting and Analytics for HCM
-
Headcount and Termination # for Turnover and ESG reportHi there, We are looking for the columns in subject area to display precise headcount and termination number for Turnover and ESG reports. Below are other numbers which …Yiming Xiong 15 views 2 comments 0 points Most recent by Yiming Xiong Reporting and Analytics for HCM
-
BI Publisher : I need to create a report to track the changes on employement for my employeesSummary: I need to create a report to track the changes on employement for my employees with situation before the action and action reason and the situation after the ac…Ayoub AFRASS 22 views 1 comment 0 points Most recent by MilanMohanty Reporting and Analytics for HCM -
Maryellen_Gancena 14 views 3 comments 0 points Most recent by Maryellen_Gancena Reporting and Analytics for HCM
-
Audit Document Records AccessContent Hi experts - hoping you can help with an OTBI or BIP audit report. I have the tables needed to run a report on what documents exist in the Document Records secti…Prudence K 120 views 11 comments 0 points Most recent by Malla Pratibha Reporting and Analytics for HCM