OTBI
Discussion List
-
Common Question: I didn't get any rows in the subject area, what's wrong?Typical Symptoms: you selected columns and didn't see any results, or once you added certain column/s, then you didn't see any results. Content: Q: "I didn't get any row…Gail Langendorf-Oracle 396 views 6 comments 4 points Most recent by Saina Reporting and Analytics for HCM -
Plan period start date in absenceSummary: Hi Team, I am trying to get absence accrual detail in OTBI report. Please let me know how to get these details with plan period start date. Thanks Content (plea…Anup Karmankar 11 views 3 comments 0 points Most recent by Anup Karmankar Reporting and Analytics for HCM -
Absence Calendar / Dashboard (Sample Report)Summary This dashboard creates an absence overview that can be used by either HR or the line manager to get more information about absences for the organization, team, o…Even Kjorsvik-Oracle 1.2K views 16 comments 4 points Most recent by GraemeC Reporting and Analytics for HCM -
Report on Denied Absences (OTBI)Summary: I am trying to create a report on Absences which are in "Denied" Approval Status using the Workforce Management - Absence Real Time SA. The Approval Status fiel…Gary Miller-39965 61 views 10 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
Remove Manager role from Worker self-evaluation Performance TaskSummary: Hello, I need help to check if my case statement below is correct. I encountered errors several times so I'm not sure what is the problem with this. I want to i…
-
What is the role of the Manager in Self-Evaluation?Summary: Hello, I'm currently working on Performance Task Status Report for my organization. I've changed the Role to Task Assignee. In the Worker Self-Evaluation, there…
-
OTBI Report for EthnicitySummary OTBI Report for EthnicityContent Hello, CASE WHEN COUNT("Worker"."Employee Ethnicity Code" BY "Worker"."Person Number")>1 THEN 'Two or More Races' WHEN "Worker".…Shanna Oppenheim 635 views 79 comments 2 points Most recent by Juliet Eaton Reporting and Analytics for HCM -
Unable to pull salary amount into OTBISummary: Hi, I am currently building an OTBI report and I am unable to pull the Salary Amount into the report. The report is crossing multiple subject areas and I have i…Sylvia Wong 21 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Need to report the number of Goal plan assignees who have Goals Created/Not createdSummary: Hi peers, My client wants a report that gives a count of the number of employees that have created goals as well as those who haven't yet created (even a single…
-
HCM report for monitoring access visibilityHi All, As a part of Executive and above (10,000+ employees) salary migration to the Fusion system, we are planning to introduce controls on salary visibility and access…Sachini 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI - ORC Report - How to pull the Offer accepted application status and Background Check applicatiSummary OTBI - ORC Report - How to pull the Offer accepted application status and Background Check application statusContent Hi. We have the candidates who accepted thei…Shabber Shaik 60 views 3 comments 0 points Most recent by Abhiram Vissamsetty Reporting and Analytics for HCM -
To remove NULL row occurring due to CASE statementThrough OTBI report, trying to pull element entries having input value as STI Target %, Percentage only. So, put the following formula in the case statement: CASE WHEN "…
-
System Account OwnerSummary System Account OwnerContent Hello Everyone, We've updated a few reports back in October/2020, however we can see now the owner as System Account, (as per screens… -
Multi Language update to existing OTBI reportsSummary: Multi-Language: How would you create or update existing reports to pull in any language? Is there a way to update all reports simultaneously with the option to …
-
Subject Area for Exit interview survey Responses --> Which Subject area to use ?Subject Area for Exit interview survey Responses --> Which Subject area to use ?
-
Guidance on OTBI Report for Transaction Summary by RegionSummary: OTBI Report for Transaction Summary by Region Content (please ensure you mask any confidential information): Hello Experts, We have a requirement to extract tra…Vasanthakumar Ravi 2 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Print Talent ProfileContent I am creating a custom print of talent profile RTF Template and there are some sections that are only available to line managers but when an employee prints it s…Misbahul Khair 51 views 2 comments 2 points Most recent by Harshal M Reporting and Analytics for HCM -
Report dashboard prompt showing error - ACIOA5LNSummary: Report dashboard prompt showing error - ACIOA5LN Content (required): One of the working BI report which uses dashboard prompt, suddenly stopped working and show…Swati U 3K views 17 comments 1 point Most recent by Aaron Epstein-261578 Reporting and Analytics for HCM
-
For OTBI Analysis not getting data in correct formatSummary: I am trying to built a analysis bases on 2 Subject areas Project Billing Revenue real time and Project costing Actual cost Real Time, this issue is like I am tr…
-
OTBI Added formula column and filter stopped workingSummary: I added a column from the Subject Area Recruiting - Recruiting Events Real Time of: CASE WHEN "Recruiting - Recruiting Events Real Time"."Job Requisition Histor…Kristin Montoya TWU 21 views 4 comments 0 points Most recent by Kristin Montoya TWU Reporting and Analytics for HCM
-
Case Statement error on Task Completion DateSummary: Hello, I need help to check if this case statement is correct. My case is if the "Step Completion Status" is 'Completed', it returns the "Step Completion Date";…
-
notification received is Redwood Users Delegation RolesSummary: Content (please ensure you mask any confidential information): The notification received is Redwood Users Delegation Roles. I need to know the OTBI path for thi… -
Performance tile is showing an error when I'm in edit view but working when added to compound layoutSummary: I'm experiencing an issue where I have a few different Performance Tiles to highlight active, completed and total courses within the 'Learning Records Real Time…Stephanie McInnes 41 views 5 comments 0 points Most recent by Stephanie McInnes Reporting and Analytics for HCM -
Learning items with learning outcomes assigned are not displayedLearning items with learning outcomes assigned are not displayed. In the front we can see data according to this but not in OTBI. Using the "Workforce Learning - Learnin…User_DA2EL 12 views 1 comment 0 points Most recent by Erika B-Oracle Reporting and Analytics for HCM
-
Report to identify Users when Clicked on Learning Tile under My Client GroupsSummary: Report to identify Users when Clicked on Learning Tile under My Client Groups Content (please ensure you mask any confidential information): I am looking to see…Thulasi Ram 12 views 1 comment 0 points Most recent by Erika B-Oracle Reporting and Analytics for HCM -
Query to get Latest offer extended by details in ORCHi Folks, We are trying to fetch the latest offer extended details in our report, we tried latest updated by column from irc_offers, but It didn't work. Scenario: Hiring…Sushant95-Oracle 21 views 1 comment 0 points Most recent by Anu Puchha Reporting and Analytics for HCM
-
BIP publisher email unable to send to icloud candidate emailSummary: Hi, we are using BIP jobs to trigger emails to new hires based on task completion in journeys and recently BIP email is getting failed to deliver to icloud doma…