OTBI
Discussion List
-
Individual certificates of completion per learning itemSummary Possible to create individual certificates of completion per learning item on learning transcriptContent Hello, I'm wondering if it's possible to create an indiv… -
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 66 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 547 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 166 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 13 views 1 comment 0 points Most recent by User_2025-01-31-00-30-34-540 Reporting and Analytics for HCM -
Invoice Line Level Account Combination (Distribution) ReportSummary Invoice Line Level Account Combination (Distribution) ReportContent Can someone tell me what Subject Area and specific Subject in Reports and Analytics should be…racheltx 109 views 4 comments 1 point Most recent by Sridhar Tumati-55392 Reporting and Analytics for ERP -
Loading item transactions via FBDI templateSummary Can't see accounting details of the item transactions passing in FBDI templateContent Hello Team, Item transactions loading done successfully with item cost, how… -
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 220 views 5 comments 9 points Most recent by Annette M Reporting and Analytics for HCM -
How to add OTBI report parameter to filter out those zero outstanding balance and date in range?Summary Add report parameters to filter those zero outstanidng balance and date in rangeContent hi all, I have two OTBI report parameters would like to add: 1) In the Su…User_2025-02-04-05-26-22-197 106 views 3 comments 3 points Most recent by Senthilrajan V Reporting and Analytics for ERP -
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 -
Managers on a Leave of AbsenceSummary Managers on a Leave of Absence reportContent Hello, I am trying to create a report that will show managers, the managers Assignment Status (to be used to determi…Shanna Oppenheim 51 views 1 comment 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Drill Down using Invoice NumberContent Hi, I have created analytical report which has Ledger Name, Supplier Name and Invoice Number When the invoice number is clicked i would like to drill down to tra…Mohammed Rafi 83 views 10 comments 6 points Most recent by Veronica Dumitriu Reporting and Analytics for ERP -
List of employees that are LINE MANAGERSSummary List of employees that are LINE MANAGERSContent Employee Details that are Line Managers Hello Community, Could anyone share a sample report which will list down …Prosenjit Manna 70 views 1 comment 0 points Most recent by Shakher Sharma Reporting and Analytics for HCM -
SCORM content reportingContent I'm bringing this topic up again. What are the plans for SCORM reporting of completion data via OTBI in 2019? A major business requirement for most organizations…User_2025-01-25-02-10-48-949 54 views 1 comment 0 points Most recent by User_2025-02-04-06-02-17-038 Learning -
All pre-built reports for HCM and FinanceSummary All pre-built reports for HCM and FinanceContent Where do I get full list of pre-built (OOTB) reports (OTBI and OBIA) for HCM and Financial? I got bits and piece…Vijay Gorania 130 views 4 comments 0 points Most recent by Vijay Gorania Reporting and Analytics for HCM -
Changes to 19b patch affected custom fieldsSummary Changes to 19b patch affected custom fieldsContent Hi all, We have custom fields under Workforce management - worker assignment real time > Location. After 19b p…User_2025-02-05-05-51-12-049 30 views 2 comments 0 points Most recent by Amrit Reporting and Analytics for HCM -
Employee Roster by Month Including Hours WorkedContent Does anyone have an example of a report that can be selected based on a begin/end date and list all employees with an active assignment for a specific department… -
Is it possible to create OTBI analysis that should reports person numbers for alternate Managers andSummary We are trying to create an OTBI analysis that should reports person number for alternate Managers and Line managers both.Content Requirement- Need to create an O…User_F89L9 78 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
19B Release causing report issuesSummary OTBI Report with Location GL field is breakingContent 19B released over the weekend. Noticed that reports that have Location GL field are causing ODBC error now.…User_2025-01-28-20-43-56-568 56 views 5 comments 1 point Most recent by Linda Dunn Reporting and Analytics for HCM -
Learning Analysis Need Column for Last Job ChangeSummary Find the date the colleagues Job Title ChangedContent How do I add a field to an analysis for Learning Module that will show the correct date the colleague's Job…Dena Swanson 38 views 2 comments 0 points Most recent by Dena Swanson Reporting and Analytics for HCM -
Direct Report - OTBI Report CatalogContent Hello from Columbus, Ohio! Does anyone have a nice Direct Report with Managers and Direct Reports listed? I'm looking for an .xml catalog file that I can share i…User_2025-02-04-11-13-27-138 92 views 3 comments 0 points Most recent by Shanna Oppenheim Reporting and Analytics for HCM -
Area of Expertise - Subject AreaContent Hi, I am trying to create Skills and Qualifications report from below subject area. --Workforce Profiles - Person Profile Real Time I wanted to add "Area of Expe…User_2025-01-30-00-14-06-021 114 views 5 comments 0 points Most recent by User_2025-01-30-00-14-06-021 Reporting and Analytics for HCM -
OTBI cross SA or SA is independentContent Hi , Can I create report in OTBI a cross SA or each SA is independent. Thanks, Rafik Beshara -
Learning BI PublisherSummary What is the good starting guide for BI Publisher?Content What is the good starting guide for BI Publisher?Raja Mohan Ivaturi 60 views 5 comments 0 points Most recent by Linda Dunn Reporting and Analytics for HCM -
OTBI Competences Gap AnalysisContent Hello everyone, I need to realize an analysis that shows the gap between workers' skills and their target value, has someone already done something similar? Or c…