OTBI
Discussion List
-
Automatic parameter binding for contextual reportsSummary How to configure R13 functionality "Application Context Passing to Embedded Reports"Content We are trying to configure the solution "Application Context Passing …Gabrielle Ungaro 76 views 2 comments 1 point Most recent by Satheesh Nesamani Reporting and Analytics for HCM -
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 842 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 841 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 166 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…