OTBI
Discussion List
-
Report on Duplicate Contacts in BenefitsSummary: I'm looking to see if anyone has come up with a clean way to report on duplicate contacts in Benefits. I have read a few other posts about this issue, so I know…Jessica D 14 views 2 comments 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM -
How can I pull a terminated employee's last annual salary into an OTBI report?Summary: Terminated Employees salary is not returning the expected amount. Content (required): I'm trying to create an OTBI report to use for balancing my payroll. One o…Sheri Curtis 433 views 8 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
OTBI report available for employeesSummary: OTBI report available for employees Content (please ensure you mask any confidential information): Hello, we have configured a guided journey which is visible i… -
Recreating Workforce Goals Reports using BI PublisherHello, For a number of reasons we've had to use BI Publisher to build a report on performance Goals and Goal Plan Eligibility. We've tried to use HRG_PERF_GOALS_SECURED_… -
Payroll Element Entries History excluding terminated employeesSummary Payroll - Element Entries History Real Time subject area is excluding terminated employeesContent I have created a report to pull Annual Salary and Annual Bonus …
-
Employee previous and current locations reportSummary: Looking for a way to report employees and their locations (Current and all previous locations). Content (required): Looking for a way to report employees and th…Scott Conaway 94 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Is it possible to get metadata of OTBI reportsSummary I am looking for any workaround to get the report/analysis names with subject areas used in a folder.Tried to find any xdo tables but no luck. TIAContent Assume …User_2025-02-05-19-28-09-134 58 views 3 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM -
OTBI bursting via agent for high volume email notifications inconsistent / sporadicSummary: Classic use case: Managers are receiving emails regarding outstanding actions. Of the 1132 expected emails, 1014 succeed. 118 emails still successfully send, bu…
-
Oracle fusion hcm OTBI Subject area for person extra infoSummary: I am looking for subject area in oracle fusion HCM that store person extra information. (i.e. Region (PEI_INFORMATION1), Capability (PEI_INFORMATION2), Service …Anup Karmankar 283 views 4 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
Data Security Policy is not working for the custom role which has Purchase Analysis role addedSummary: We have created a custom role by copying it BI Consumer Role, We have also added the Purchase Analysis role under this custom role so that users can access the …Shabbir M Tahasildar 45 views 5 comments 0 points Most recent by Shabbir M Tahasildar Reporting and Analytics for HCM -
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 411 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 13 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.3K 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 90 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 636 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 13 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 62 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 3 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM