OTBI
Discussion List
-
OTBI-How to combine Requisition other locations into one fieldSummary: I have created an OTBI report ( Subject Area :Recruiting -Recruiting Real Time) , and the Requisition Other Locations are displayed in multiple lines in output … -
Active Candidate Pools OTBISummary: Dear Community, We would like to create an indicator that counts all active candidate pools within our system. However, while exploring the Recruiting - Recruit…Giuseppe Iacono 2 22 views 1 comment 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM
-
OTBI report for finding position wise incumbants including candidates with Job offersSummary: We are looking for an OTBI report to fetch all incumbents of a given position along with candidates with active Job offers already given. This report will help …Pavan Kumar Thummalapalli 76 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
if we can run an OTBI report that shows when a password has been reset as well as an email updated?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…Chandra Rao.D 14 views 2 comments 0 points Most recent by Satyam Roy Reporting and Analytics for HCM
-
Adding Learning Comments to Criteria is causing my analysis to fail to process ResultsSummary: I have a report using Workforce Learning - Learning Records Real Time that works until I add "Evaluation Questionnaire"."Answer Comments" to the Criteria. Then …
-
Can someone please help, on where to find this value in oracle Tables?Hello can someone please help on where to find this field on HCM Table and Views? UI Navigation is Benefit Administration> Plan Configuration> Rates and Coverages> Varia…Joliver Caangay 12 views 3 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Need Join Condition column for tablesSummary: Hi team, I have two tables to join hrc_dl_message_lines hdml and HR_ALL_POSITIONS, where i need position code from HR_ALL_POSITIONS table by joining with below …
-
table name to fetch 'Write to person profile on completion' In learningSummary: Which table stores information about the Field 'Write to person profile on completion' In learning Navigation :- Course ->Skills and qualification -> manage -> …Shubham Wadekar-Oracle 1 view 0 comments 0 points Started by Shubham Wadekar-Oracle Reporting and Analytics for HCM
-
how to get the Annualized salary of terminated employeesSummary: I just need basic details like thePerson number, Name etc of terminated employees with their annual salary. How do I get this in the OTBI report ? Content (plea…Trupti Khodke 28 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Recruiting Offer > Message Notification OTBI FieldGood Day Experts, Is the 'Message Text' field in recruiting module in fusion available in OTBI Recruiting Real Time subject area? Navigation from fusion is Offer > Actio…
-
Task Type in Subject Area Workforce Management - Checklist Real Time - Checklist Task TemplateSummary: 1- Looking for the Task Type in the Subject Area Workforce Management - Checklist Real Time. This is to pull the configured task type for various tasks in the j… -
How do I write a number in full in the report?Summary: I need to write the salary amount in full, for example, R$ 1,000.00 (one thousand dollars). I know it's possible using a PL/SQL function, but I couldn't do it i…Simiao Oliveira 12 views 3 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM -
Embedded OTBI Analysis Refresh IssueHi, I'm using an embedded OTBI Analysis within Fusion HCM on Candidate Submission Profile. I'm running into a cache issue where if the report is viewed before the result…
-
Time card details based on payroll flow - Load Time Card BatchesHi Expects, Requirement : Need to fetch time card details based on payroll flow - Load Time Card Batches. basically OTL report , based on payroll flow parameter. when we…Rajdeep Chavda 61 views 5 comments 0 points Most recent by Indushree Reporting and Analytics for HCM
-
OTBI Report integrated within performance document is not loading first timeSummary: OTBI Report integrated within performance document is not loading first time Content (please ensure you mask any confidential information): I have OTBI report c…Neha Thakre 2023 11 views 2 comments 0 points Most recent by Sivakumaran Muthusamy-Oracle Reporting and Analytics for HCM -
Performance OTBI to extract Task Status, Section Names, Rating LevelsDears, we have a requirement to build an Analysis to extract performance document task status and ratings given to each document section. To do so we are crossing "Workf…Domenico P. 87 views 1 comment 0 points Most recent by Sivakumaran Muthusamy-Oracle Reporting and Analytics for HCM
-
Fusion HCM - OTBI Report - Can't view other employee's data only my own ?Summary Fusion HCM - OTBI Report - Can't view other employee's data only my own ?Content I have created a OTBI report with the subject area 'Workforce Management - Worke…Ruzwan Akram 263 views 15 comments 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
for-each OTBIHello everyone, I have the following problem: I have a report that is grouped by several groups and subgroups. I need to be able to total the columns for each subgroup a… -
Consolidated List of OTBI and BI Publisher Reports Posted (14 April 2015)Content The following is the list of published OTBI and BI Publisher reports between 10 December 2014 and 10 February 2015: * OTBI: Employee Salary and Performance Ratin…Julian Challenger-Oracle 296 views 3 comments 3 points Most recent by Ms_Oracle Reporting and Analytics for HCM -
OTBI Vacancy ReportSummary: Is there a way to report using Subject Area(s) all current employees and any requisitions and vacancies so we have one entire list? For example a report that sh…JHaden3 164 views 13 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Veteran StatusSummary PER_PEOPLE_LEGISLATIVE_F ;PER_PERSON_LEGISLATIVE_DATA_LEG_DDF'Content Can someone please help on attribute mapping from the application screen(i.e Armed Forces S…User_2025-01-29-01-31-31-940 382 views 5 comments 0 points Most recent by User_UAM4F Reporting and Analytics for HCM -
Is it possible to report on Number of Positions requested, approved, rejected, pending?Summary: I have a requirement to design a Dashboard designed to track the overall timeline to 'Hire an new employee' from the time the initial position is requested/amen…Antonio Moldovan 32 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How can I get values entered on a prompt displayed on an OTBI report?Summary: We have a Termination report that prompts for Termination Dates From & To (Work Relationship Details."Actual Termination Date"). Is there a way to see the dates…
-
Is it possible to get 'Last Update By' from Recruiting Subject Area in OTBISummary: We have a OTBI Reporting Requirement to display 'Last Update By' for a job application. I can see that 'Job Application Last Update Date' is available under Rec…Antonio Moldovan 32 views 4 comments 0 points Most recent by Antonio Moldovan Reporting and Analytics for HCM
-
BIP report RTF template excel output type date formatting issueSummary: Hi, Trying to show BIP report output data in excel using RTF template, but when we click on the output data column in the excel data file , the date value showi…Phani S-Oracle 296 views 5 comments 0 points Most recent by Kevin M-Oracle Reporting and Analytics for HCM
-
BIP Bursting - Linked OTBI Reports HelpHi all, I'm wondering if anyone has a solution to a challenge I've encountered recently. I have two OTBI reports, a feed and a report where the report links to the feed.…MikeW 11 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Calculating average headcount and turnoverSummary Calculating average headcount and turnoverContent We'd like to be able to calculate the average turnover rate for rolling 12 months by using Period End Headcount…Emily Robinson 401 views 5 comments 0 points Most recent by Lauriane Massin Whitaker Reporting and Analytics for HCM
-
Veteran Self-Identification Status - no results in OTBI Person Real Time SA **Updated**Summary: I have the 'Veteran Self-Identification Status' along with the other Veteran statuses in multiple analyses and dashboards. Recently, sometime after 8/15/2024, t…Susan Anderson 95 views 5 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM -
How can we find the path of the report being referenced in a dashboard within OTBI/catalog?Content Hi All, Is there a way to find the path of the report that is referenced in a dashboard? We have several custom dashboards built by various people within the org…PriyaPenugonda-SC 761 views 5 comments 0 points Most recent by Gokul Reporting and Analytics for HCM