OTBI
Discussion List
-
BI Publisher Bursting with Multiple Templates , Multiple Data setsSummary BI Publisher Bursting with Multiple Templates , Multiple Data setsContent Hi Friends We have a requirement where we need to burst BIP reports. Now i have 2 diffe…Mansur Khalil 332 views 4 comments 0 points Most recent by Alon Hadar Tamir Reporting and Analytics for HCM -
ORC:Date of Probity, Date of Interview, Date of review fields in Subject AreaSummary: Currently there is no any subject area available in ORC to get details directly against Date of Probity, Date of Review, Date of Interview and other phases. can…Siddhesh Nisal 21 views 4 comments 0 points Most recent by Siddhesh Nisal Reporting and Analytics for HCM -
How to link transaction adminstration Real time with worker assigenment Subject area ?Summary: HI Team, We have need to track the all transactions in hcm of : Change Location, Change Manager, DeleteAssignment Promotions ResignationTransfers. with worker d…AjayKumar Maddipati 21 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How to: Translate BI Publisher Report Parameters at 24ASummary: How to: Translate BI Publisher Report Parameters at 24A Content (please ensure you mask any confidential information): Version (include the version you are usin…Ishtiaque AHmed 41 views 1 comment 0 points Most recent by Satyabrata Nanda Reporting and Analytics for HCM -
Signature in the reportSummary We need to store Digital signatures in the Fusion cloud and need to display same signatures in the reports.Content Hi All, Can we store Signatures in the Fusion …
-
How to create a historical report with actions reasons in OTBI?Summary: How to create a historical report listing all actions/reasons since the hire date including future dated action reasons/ Content (required): I'm using Worker As…Stefaan Onderbeke 181 views 9 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI Dashboard-when i click the apply button it not changing the dashbord dataSummary: HI All, I have edtionally added completion date but when i click the apply button it not changing the dashbord data but when i apply the hire date of dates its …AjayKumar Maddipati 31 views 7 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
How to get the action reason from the Enterprise Hire Date?I'd like to get the Action Reason based on employee's Enterprise Hire Date. However, when I'm about to add the Action Reason column within the analysis, the value didn't… -
Current User/Logged in User Absence Details in OTBISummary Not able to fetch absence details of current user from otbiContent Hello Experts! I'm trying to build a report to get the logged in user/current user absence det…
-
Report for all direct and indirect reportsSummary: I need to write a report for all employees that role up to each VP. Content (required): I need to write a report for all employees that role up to each VP. I wi…Donna Valentine 211 views 5 comments 1 point Most recent by Girishbabu800 Reporting and Analytics for HCM -
OTBI REPORT- ERROR WITH COMPENSATION SALARY REAL TIME DETAILS SUBJECT AREASummary: Hi All, when I try to add the Annualized salary and salary currency to an employee with a changed salary we find the following issue: 1. adding only the annuali…GiovanniD 41 views 13 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Compensation Plan Worksheet with notesSummary: I have created a report to pull compensation worksheet with notes. I am facing the following issues: 1) It only picks up employees with Notes. I need to pull th…
-
Is there syntax in OTBI I can use to round down?I have age in years as 22.6 which I need rounded down to 22. Using ROUND rounds up to 23; applying data formats rounds up. e.g: ROUND((CURRENT_DATE - "Workforce Manageme…Clare Murtagh 41 views 2 comments 0 points Most recent by Clare Murtagh Reporting and Analytics for HCM -
Filter not working for case statementSummary: I am creating a HDL formatted report to produce a list of employees that require termination from HCM. I have managed to produce a list of all the employees tha… -
OTBI Agent sends spoiled action linksSummary: OTBI Agent sends spoiled action links Content (please ensure you mask any confidential information): Hi experts, I am working on the new job applications list O…Volodymyr Faranosov 11 views 2 comments 0 points Most recent by Volodymyr Faranosov Reporting and Analytics for HCM -
OTBI-Dashboard promt values not showing in Dashboard after added the new oneSummary: HI Team, We have new enhancement requirement in old dashboard that is needed to change the check task name from HR Questionnaire First 2-weeks check into Onboar…AjayKumar Maddipati 31 views 9 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
Performance Document Changes Audit ReportHello, We have a need to audit our Performance Documents to understand who all made changes on a performance document. Each time a rating is changed we want to generate …Nick Dorfner 333 views 7 comments 0 points Most recent by Andrew Gillibrand-Oracle Reporting and Analytics for HCM -
Report on Role MappingsSummary: I'm looking for a way to pull all Role Mappings currently set up. Is there a delivered one I'm missing? Or, does someone have a sample to share, please? Content…
-
How to Filter for Calculation Component Details in OTBISummary: Business requires a report to pull all current information on the Reporting Information Calculation Card where the Calculation Component Detail = Third-Party In… -
For impact analysis on BIP data models which meta data table is used in Fusion HCMSummary: As a part of impact analysis how can we find particular field is getting used in which BIP data models. Content (please ensure you mask any confidential informa…Siddhesh Nisal 31 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
BIP Report Tagged to OTBI Dashboard is taking long time and error outSummary: BIP Report is developed and tagged to OTBI Dashboard. Taking longtime more than 10 minutesand then error out Content (please ensure you mask any confidential in…Anjan Polimera 41 views 3 comments 0 points Most recent by LakshmiCharitha Cherukuri-Support-Oracle Reporting and Analytics for HCM
-
COUNT in a CASE statement for a calculated field in OTBISummary: Need to create a calculated field using COUNT and CASE statement Content (please ensure you mask any confidential information): I am using this Subject Area: Wo…Pradnya_Pampatwar 171 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Query to get assessment questionnaire responses for an employee from learn moduleSummary: Query to get assessment questionnaire responses for an employee from learn module Content (please ensure you mask any confidential information): Hello, I'm tryi…Manisha Rajupeta 373 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Audit of BIP Report ChangesSummary: Audit of BIP Report Changes Content (please ensure you mask any confidential information): Hi Team, Greetings! Is there any available feature to track or audit …Parag Hiremath 41 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Pivot Table > Sorting Date in Ascending Order Not WorkingSummary: Pivot Table > Sorting Date in Ascending Order Not Working Content (please ensure you mask any confidential information): Hello, We want to display the time card…
-
Education Levels in OTBISummary: I'm not able to locate School name shown in the Education Levels section on Person Profile in OTBI. I don't see the Education Levels section under Person Profil…Gala Meyerovich 11 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Unable to get the data from Workforce Management - Worker Assignment Real Time in OTBISummary Unable to get the data if we include Assignment Manager, Assignment Manager (Unsecured), Assignment Manager List, or Assignment Manager List (Unsecured) foldersC…Visu 340 views 10 comments 4 points Most recent by Vibha Pandey - Oracle Reporting and Analytics for HCM
-
We are using Assignment Event Real Time and do not see correct Termination headcount in BI reportsSummary: We are using assignment event real time subject area and reporting annual turnover for previous 5 years. We are not seeing the correct turnover headcount when w…David Boudreau 61 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Need query to resignation approved employeesHi, I have a requirement to send emails to employees whose resignation is approved. So I want to use bursting to send emails to employees. Can anyone help me out with th…Dara Nagasai 42 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM