OTBI
Discussion List
-
How to pull Rate Name in Reporting?Summary How to pull Rate Name in Reporting?Content How do we pull rate names tied to employees benefits in analysis reporting? I have added the Benefits - Enrollments Re… -
Employee Self Service: how do you show employees their salary history?Summary Employee Self Service: how do you show employees their salary history?Content Hi, Our team would like to display an employee's own salary history on the Personal…Matthew Grillo-95429 121 views 5 comments 1 point Most recent by Kalyan Amaravathi Reporting and Analytics for HCM
-
Employee not appearing on report; issue appears to be related to Top Manager Name fieldSummary Recreated current report with filter on the impacted employee to identify why she is not showing up on report. When I pull in Top Manager Name field, I get no re…User_2025-01-28-20-43-56-568 46 views 5 comments 0 points Most recent by User_2025-01-28-20-43-56-568 Reporting and Analytics for HCM -
50,000 Cell Excel Export limit from OTBIContent My current client's Pods seem to have a 50,000 cell limit on exports from OTBI into Excel. I've never come across this restriction with previous clients, and for…User_2025-01-25-01-23-28-110 177 views 8 comments 1 point Most recent by User_2025-01-25-04-02-13-126 Reporting and Analytics for HCM
-
BI Report to achieve SANDWICH ABSENT DAYS CASES.Summary BI Report to achieve SANDWICH ABSENT DAYS CASES.Content BI Report to achieve SANDWICH ABSENT DAYS CASES. Please Kindly Help us to achieve these scenarios in BI R…Radhika Yalamanchili 26 views 2 comments 0 points Most recent by Radhika Yalamanchili Reporting and Analytics for HCM
-
GenerateHead Error when writing Employee Changes ReportContent I have an employee changes report that runs fine until I try to add two additional fields to it (Cost Center and Manager Name). Now I'm getting a GenerateHead er…Lauren Owen 26 views 3 comments 0 points Most recent by Parthiban Vaithiyanathan Reporting and Analytics for HCM
-
Worker Assignment Event - Created ByContent Hi, I am interested in finding out which user created the assignment event. I get the user "FUSION_APPS_HCM_ESS_LOADER_APPID" created this. How would I find out …User_2025-02-01-04-05-22-904 55 views 9 comments 0 points Most recent by User_2025-01-28-16-10-52-033 Reporting and Analytics for HCM
-
OTBI Reporting of the new Onboarding FeaturesContent We are looking at alternative designs for OTBI support for the new Onboarding feature and we'd appreciate your input. The existing Workforce Management - Checkli…Julian Challenger-Oracle 137 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Subject Area for Onboarding TaskContent Hi All, Is there a subject area to pull the data from the Me-->Quick Actions-->Onboarding Tasks for the pending workers. I tried using the subject area: Workforc… -
Missing Talent Profiles on ReportsContent We are doing an HDL for License and Certifications and we are missing about 1200 employees when we try and pull the profile report attached. When we pull up one …User_2025-01-31-00-25-12-234 91 views 7 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM
-
Link to most recent scheduleContent All - In BI Publisher reporting, is it possible that we are able to provide a static link to the most recent scheduled report? I have a report that is run daily …Prudence K 32 views 2 comments 0 points Most recent by Skolli-Oracle Reporting and Analytics for HCM -
Embedding BI Publisher Report on DashboardSummary Embedding BI Publisher Report on DashboardContent Hello, Looking for a better way to display an embedded BI Publisher report in a Dashboard. The views between BI…User_2025-01-28-20-36-10-715 137 views 7 comments 0 points Most recent by User_2025-01-28-20-36-10-715 Reporting and Analytics for HCM
-
Citizenship FieldContent Hi Guys, I don't able to find the field "Citizenship", some one know in which subject area can I find it? Best Regards GiuseppeGiuseppe Iacono 41 views 4 comments 0 points Most recent by Giuseppe Iacono Reporting and Analytics for HCM -
My Team Tab - Adding BI Catalog to PageSummary Adding BI Catalog to PageContent Background: We are planning to only use infolets as the primary channel for managers to access "reports" in HCM. We also want ma…User_2025-02-04-10-47-55-876 81 views 5 comments 2 points Most recent by User_2025-02-04-10-47-55-876 Reporting and Analytics for HCM
-
DISTINCT NOT WORKSSummary DISTINCT NOT WORKSContent Hello everyone, Does anyone have any idea why my query does not work? I'm using DISTINCT but I get repeated rows. Also, we have 8500+ e…User_2025-01-25-01-17-59-580 52 views 9 comments 1 point Most recent by MandeepKGupta Reporting and Analytics for HCM
-
Person running report not showing up on reportSummary Inaccurate dataContent I've created a few different report and I've found that when I run the report my data is not on present. This causes issues for our payrol…User_2025-01-31-00-25-12-234 47 views 10 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM
-
Reporting on Employee Schedule ChangesContent Hi, Has anyone built reports around employee schedule changes? For example, if a manager goes into Time Management > Manage Planned Schedule and changes the sche…Dishti Malhotra-Oracle 54 views 1 comment 0 points Most recent by ravikiran goda-Oracle Reporting and Analytics for HCM
-
Merged ColumnsSummary How to prevent merged columns in reports?Content Hi Everyone, I noticed that some of our reports come out with merged columns, which always throw off our sorting…User_2025-01-29-23-59-58-976 62 views 9 comments 0 points Most recent by Mansur Khalil Reporting and Analytics for HCM
-
CASE Statement Future Termination DatesSummary Trying to show future termination dates as blank in active reportContent I have an all ee report. One of the fields is termination date. if someone has a future …Mike Borghoff 51 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Assignment Name vs Job NameSummary Report comparing Assignment Name and Job Name to list differencesContent The Oracle bug where Assignment Name and Job Title (Name) are different causes our downs…User_2025-01-23-21-24-21-434 62 views 10 comments 0 points Most recent by Debo Reporting and Analytics for HCM
-
column information for PAY_ACTION_INFORMATIONSummary PAY_ACTION_INFORMATION Developer DFF Columns detailsContent I am looking for details on action_information1...300 columns in pay_aciton_information. what data is…Rakesh Lathiya 2018 118 views 2 comments 0 points Most recent by Rakesh Lathiya 2018 Reporting and Analytics for HCM
-
Nesting Case statements?Summary Is it possible to nest Case statements in otbi?Content I am working on a recurring report that requires me to classify people based on certain characteristics. I…Cheryl Burwell 57 views 3 comments 0 points Most recent by User_2025-02-04-18-47-48-634 Reporting and Analytics for HCM -
HCM CLOUD BENEFITS (OTBI) Open Enrollment DashboardSummary The goal of this dashboard is to assist the benefits department management of their employee benefits data and the downstream actionable benefits data throughout…Adam Gates-Oracle 485 views 25 comments 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM -
Active User Name Flag (Terminated Employee or Active Employee)Summary Does OTBI provide an Activated User Flag?Content We have a requirement to provide an audit report in HCM that shows any active HCM user accounts for terminated e…User_2025-01-28-08-17-22-037 160 views 2 comments 0 points Most recent by Linda Dunn Reporting and Analytics for HCM
-
Is it possible to get Previous/Prior Salary Frequency from OTBI Subject areas?Summary Is it possible to get Previous/Prior Salary Frequency from OTBI Subject areas?Content Hi Team, Is it possible to get Previous/Prior Salary Frequency like Annuall…Harish Kumar Kovi 54 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Create performance titleContent Hi Guys, How i can realize a performance title that show the Learn Count for each plan cycle name? Best Regards GiuseppeGiuseppe Iacono 15 views 1 comment 0 points Most recent by User_2025-01-31-00-30-34-540 Reporting and Analytics for HCM
-
Performance Document - Report on Core RoleContent Hi Experts, We have customized the core role section recently. Please find the screenshot of New Core role section attached. Can you please guide me how i can re…User_2025-01-30-00-14-06-021 20 views 12 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
3 Basic Payroll OTBI (BI Answers) ReportsSummary Element Entries - Payroll Results - Costing ResultsContent XML is ready to be copied and pasted into the XML section on the advanced tab of any subject area. Hop…Becky Stalsby 195 views 5 comments 8 points Most recent by Annette M Reporting and Analytics for HCM -
HCM Location for Manager Self-Service ReportsSummary Where are other companies, placing self-service reports in HCMContent The manager experience we are designing for HCM is to provide infolets as the primary chann…User_2025-02-04-10-47-55-876 51 views 6 comments 3 points Most recent by User_2025-02-04-10-47-55-876 Reporting and Analytics for HCM
-
BI Report to achieve SANDWICH ABSENT LEAVE CASES.Summary BI Report to achieve SANDWICH ABSENT LEAVE CASES.Content Please Kindly Help us to achieve these scenarios in BI Reports. Here below are the two scenarios, We are…Ravikanth Rao Thota 37 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM