OTBI
Discussion List
-
Learning Records Subject Area - How to remove duplicate linesSummary: In the new Learning Records Real Time Subject Area, I am trying to produce a report for the following data, but when I add the Activity Details start and end ti…Mark Stoker 101 views 1 comment 0 points Most recent by Abdul Rauf Mohammad-Oracle Reporting and Analytics for HCM -
Why is my new custom field not showing in BI?**This post was created as part of a How to Service Request (SR) Release: 23A Summary of the question: I have created a new field 'NewField_c' in the 'Object_c' custom o…Ionel Spaloghe-Support-Oracle 71 views 1 comment 0 points Most recent by Ionel Spaloghe-Support-Oracle Reporting & Analytics for Sales
-
Subject Area for Workflows & Approvals?Summary: I need to do a review of all of the Workflows & Approvals, and would like to be able to export them all, as is to avoid going through each one, one-by-one. Is t…Jessica D 363 views 6 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
What role or privilege controls the schedule functionality for OTBI analyses?Summary: How to enable the "Schedule" functionality for an analysis? Content (required): In OTBI there is the option of scheduling an analysis to be run, delivered etc. …Matti Bugge 192 views 4 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM -
How to get the termination action/reason for the report with benefit details?Summary: I have an OTBI report built with benefit details. I need to add employee's termination reason/action for that report. Content (required): I cannot find a benefi…Ayesha Iroshani 391 views 1 comment 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM
-
Filter Planned Completion Date Based on Current DateSummary: Content (required): Hi, We have created an OTBI report with the column "Planned Completion Date" using Maintenance Management - Work Order Performance Real Time…Sheneli98 41 views 1 comment 0 points Most recent by Bharath Raghupathi-Oracle Reporting and Analytics for SCM
-
Removing blanks from questionnaire reportingSummary: I have created a questionnaire with some questions having a response type of Rating and some with Answers. When I bring the fields Response Answer and Response … -
How do I suppress trailing zeros in my RTF template for comp statementSummary: How do I suppress trailing zeros in my RTF template for comp statement Content (required): I have tried both ’999.999999’ and ’D999999’. If a number has 6 decim…TerryM01 51 views 2 comments 0 points Most recent by Indra Sardana-Oracle Reporting and Analytics for HCM -
Values appearing in alternate lines when exported to excelSummary How to have just one line of valuesContent Hi, The Risk of Loss and Impact of Loss fields are not aligned on a single line of data, instead there is a NULL inclu…User_2025-02-05-22-44-35-842 36 views 4 comments 2 points Most recent by William_Johnson Reporting and Analytics for HCM -
Create Custom Subject AreaHi, Please help with the steps how to create custom subject area from the custom data model ? ThanksMohammed Rafi 71 views 3 comments 5 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
Allocated Checklist Status Code in Workforce Management - Checklist Real TimeSummary: Hi All, Is anyone aware of what/where information in this column would pull from in the system? What would value "WAI" represent? Subject Area: Workforce Manage…William_Johnson 62 views 4 comments 1 point Most recent by William_Johnson Reporting and Analytics for HCM
-
SQL prefix for 'As of' Date getting ADFS errorContent Hello, I have a sql prefix set as SET VARIABLE PARAM_EFFECTIVE_DATE = '@{AsOfDate}'; I'm all of a sudden getting this error: State: HY000. Code: 77031. [nQSError…Susan Anderson 50 views 2 comments 0 points Most recent by Harpreet Shergill Oracle Reporting and Analytics for HCM -
Division showing blank for Performance task status real time subject area in OTBISummary: Org tree columns showing blank value in OTBI due to new org tree version Content (required): We have activated our new tree version from 1st jan 2023, since the…
-
Display an OTBI report in the UI based on page binding parameterSummary Often requested, we've cracked that nut. This is a method to display an OTBI report in a UI page with a pre-filter based on any binding parameter available in th… -
Salary Range Report ALL Jobs (Active and Inactive)Summary: I have a requirement to produce the below OTBI report but if I use the Compensation Salary Detail Real Time, it only shows data if an employee is assigned to th…JHaden3 101 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
What is the equivalent of EBS Request Group in FusionSummary: I would like to know the equivalent of EBS Request Group in Fusion. For Example, I have a project accountant who needs to have access to run and view AP custom …Navaneeth TechM 66 views 1 comment 0 points Most recent by Shivashish Dwivedi-Oracle Project Management
-
OTBI Filter for Numeric using MAXSummary: Thinking of the approach how to apply Filter in OTBI to get the Max value of column where column is only numbers. Content (required): Data on DFF column is Varc…
-
Report showing previous month (starters, leavers)Summary: Is there a way to filter results for only a previous month - for example all new hires, terminations - regardless of the date the report is run? Content (requir…Gary Miller-39965 171 views 4 comments 0 points Most recent by Gary Miller-39965 Reporting and Analytics for HCM
-
Need to display complete History related Employeement changes for the previous and current valuesSummary: Need to display complete History related Employeement changes for the previous and current values Content (required): We need to display complete history employ…