OTBI
Discussion List
-
Reporting on OTBI and its Subject areas in UseSummary: There is requirement to check if there are any existing OTBIs that uses fields identified as sensitive. Is there a way to achieve this? Content (required): refe…Girish_Kulkarni_123 36 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Performance Reviews for Inactive employeesHi, I am trying to pull a performance review for a terminated employee.When I go into the performance performance goals screen and search for the employee, he iş appear …Cansel Karasoy 47 views 3 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
Reporting Comments on Termination/Resignation Quick ActionSummary: Content (required): In classic UI, we were able to pull Employer Comment on OTBI analyses but that field is not available in RUX and is replaced with Comments a…Kathleen Nguyen 38 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to get effective date of analysis so only values with a date greater than a specific date show?We have a report build to view talent ratings and are using the subject area Workforce Profiles - Person Profile Real Time. Our report is currently showing every record …JMora1234 14 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
FEIN Number in OTBI AnalysisSummary I'm trying to pull in the FEIN Number that my roster of active employees are assigned to. Is that possible?Version Oracle Cloud V20BUser_2025-02-04-18-03-17-329 144 views 18 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM -
How create a column by concatenating multiple columns in otbiSummary How create a column by concatenating multiple columns in otbiContent We have a requirement to concatenate multiple columns and print it as separate column in otb…User_2025-02-05-02-11-29-794 1.7K views 9 comments 1 point Most recent by Ankur Kamboj-Oracle Reporting and Analytics for HCM
-
Need to display terminate records as on Yesterdays dateSummary: Need to display terminate records as on Yesterdays date Content (required): We are referring "Workforce Management - Work Relationship Real Time " subject area.…
-
How can I see the Goal Tasks details of inactive employees in the Analysis report?Hi, I am preparing an analysis report from the Workforce Goals- Goal Tasks Real Time subject area and I have added 'Display Name' , 'Task Name' and 'Comments' fields to …Cansel Karasoy 33 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
attachment in bursting not addingSummary: requirement is to add attachment using data model for custom report, in bursting section we have added email bursting and adding attachment but we are receiving…Rehber Hussain 105 views 5 comments 0 points Most recent by Rehber Hussain Reporting and Analytics for HCM
-
Is there a way to pull in current assignments from Person Profile Real Time?Summary: Subject Area: "Workforce Profiles - Person Profile Real Time" Content (required): Hi All, We have been attempting to pull only the current active assignment fro…William_Johnson 41 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Pull current assignment only from Workforce Profiles - Person Profiles Real Time subject area?Summary: Subject Area: Workforce Profiles - Person Profiles Real Time Pull only most recent, current assignment - NOT past assignment data Content (required): Hi All, *R…William_Johnson 68 views 7 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Workforce Talent Review - Talent Review Tasks Real Time administrator view of all tasks in system?Summary: Subject Area: Workforce Talent Review - Talent Review Tasks Real Time HR View All security assigned to report creator Content (required): Hi All, For the Workfo…William_Johnson 38 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
SQL to take out alternating rows for Risk and Impact?Summary: Subject Area: Workforce Profiles - Person Profile Real Time Columns: "- Risk of Loss"."Impact of Loss", "- Risk of Loss"."Risk of Loss" Content (required): Hi A…William_Johnson 56 views 10 comments 0 points Most recent by William_Johnson Reporting and Analytics for HCM
-
What is Rating Model 1, Rating Model 2, Rating Model 3 in Person Profile Real Time subject area?Summary: Subject Area: "Workforce Profiles - Person Profile Real Time" Columns: "- All Profile Content"."Rating Model 1", "- All Profile Content"."Rating Model 2", "- Al…William_Johnson 25 views 0 comments 0 points Started by William_Johnson Reporting and Analytics for HCM
-
We need to fetch the latest record only in OTBI how can we achieve this requirement ?Summary: Hi Team, in below attachment filled by Hr team for employee in multiple times of records creating and report also fetching three records, but Business wants to …AjayKumar Maddipati 468 views 2 comments 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM -
ORC-OTBI Report we have used two subject areas but report still searching modeSummary: Hi Team, I have developed OTBI report by using recurting real time and recurting real time we used but no out after long time also. Please find attachement of i…AjayKumar Maddipati 26 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
Secure Reporting on Person Special Category DataSummary: In 23B we see there is a new feature to secure reporting on Ethnicity, below is the detail. We also require this capability for other sensitive categories such … -
Reporting on element entry Correction - getting new and former values?Summary: There is a need to report on changes made to an element entry record of a person, where the 'Correct' editing option was used (not Update). We are seeking to ge…Shant Sarkissian_NES 52 views 7 comments 0 points Most recent by Shant_Sarkissian_WJG Reporting and Analytics for HCM
-
Missing Bank Details for Rehires and Global Transfers not linked to latest Personal Payment MethodsSummary: Bank Details for Employees who have transferred from one Legal Employer to another or for Rehires are not updated against their new Personal Payment Methods. Co…GJ79 83 views 3 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM
-
OTBI Analysis - Pulling the latest effective dated recordSummary only want to see the record with the latest effective dateContent I am in need of assistance to create a filter to include only the latest date record in my anal…Shelly Feyerherm 840 views 8 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Element Entry Changes ReportSummary Copying an existing BI Publisher versionContent Hi, I'm trying to replicate a BI Publisher report that HR runs each month and submits to payroll. I'd like the re…User_2025-02-05-22-44-35-842 104 views 2 comments 0 points Most recent by Isabela Radivoi Reporting and Analytics for HCM
-
OTBI HR Help Desk Reports Not Returning Data, Security MappingSummary: Creating a all module reporting role, and added all the transactional duty roles specified to HR help desk. Additionally, have added DSPs to view all Service ty…
-
hcm bi report - how to schedule report on every end of monthSummary hcm bi report - how to schedule report on every end of monthContent Hi, I wonder how to schedule HCM BI report on every end of month. I wasn't able to find the o…
-
We have new requirement in my workforce page how find which subject area available ?Summary: HI Team, we have new requirement in my workforce page > additional person info group. which subject area available . Any one help me on . Thanks. Ajay Content (…AjayKumar Maddipati 54 views 9 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
Getting duplicate record in OTBI reportSummary: Content (required): Hi Expert, We have built an OTBI report for talent meetings and when we are running the report there is a record that is coming multiple tim…Faizan Rashid 837 views 3 comments 0 points Most recent by Faizan Rashid Reporting and Analytics for HCM -
Is there a way to enter a prompt date and show this date in a column within the report?Summary: Enter an effective date of 01/05/2023 in a prompt Display this date within a column in the output of the report Content (required): If I user enters a prompt ef…
-
Copy and Modify the Seeded Recruit to Hire DashboardSummary: We want to make modifications to the analysis tied seeded Recruit To Hire Dashboard. I've read various posts and documentation on how to achieve this, but none …Alex Tellez 164 views 6 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Pulling Comments from Resignation/Termination ActionSummary: Content (required): We are implementing employee self-service and manager self-service on submitting resignation/termination. There is an Comments and Attachmen…Kathleen Nguyen 39 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
Dynamic Regular Date Earned Formula RequiredSummary: Need a formula to get the last two regular dates earned to update each month. Content (required): I have a Payroll Net Pay Variance report which compares the Ne…
-
Annual Leave Buy / Sell - ReportSummary: A Report to identify those Employees who Bought / Sold Annual Leaves Content (required): Hi, Can you please help me to develop a report which will give details …