OTBI
Discussion List
-
custom email - how to add a link to access the systemSummary: Hi all, I would like to create a custom email. in the text of this email I would like to insert a link to access the system. in particular, I would like to inse…Alessandro Nesi 15 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Subject Area: Payroll - Personal Payment Details Real TimeHello, Could anyone help or confirm if the Subject Area: Payroll - Personal payment details real time can extract the Account Suffix for our Personal Payment Method? Cou…
-
Seeded Process/Report/Data Model customizationSummary: Once we did customization of seeded Process/Report/Data Model, after applied any patch/upgrade then the customization changes will override. Content (please ens…
-
BIP Vs OTBI What is the practicality of moving BIP reports to OTBI?Summary: I am recommending that my client investigates the possibility of using OTBI in preference to BIP for their reports (including whether this is just for new repor… -
Does any OTBI subject area have these payroll schedule related columns?Do we have any OTBI subject area where we can fetch these columns? Period Schedule Name, Period Schedule ID, Usage, Frequency, Period Start Date, Period End Date, Paymen…MeghnaDe 20 views 1 comment 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM
-
Can we filter data using values from two columns?Summary: To obtain the data using values from two different columns. Content (please ensure you mask any confidential information): I am working with Workforce Managemen…Pranav Waichal 25 views 5 comments 0 points Most recent by Pranav Waichal Reporting and Analytics for HCM -
Why is "Compensation - Salary Details Real Time" so slowSummary: We have an employee roster/list that uses "Compensation - Salary Details Real Time" If we use 3 columns from that subject area (pairing with Person Seniority an…Monique 46 views 5 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Workforce Goals - Goal Tasks Real Time 'Development Goal.description same as 'Task Name.description'Creating a simple analysis to report each development goal along with it's associated task(s) by using the Workforce Goals - Goal Tasks Real Time subject area. The 'Deve…
-
How can we convert CLOB datatype to string in OTBI Reports?Hello, We are trying to remove HTML tags from a CLOB datatype column in OTBI report by using Substring and Replace function in the analysis. This is resulting us to get …Vaishnavi Katiyar 38 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Unable to see goals under approval/in draft in OTBI ReportsSummary We are not able to get the data for goals awaiting approval or in draft state using Workforce Management - Goal status overview real time Subject Area.Content Hi…Mohit Gupta-45440 219 views 18 comments 1 point Most recent by andywuwuwuwu Reporting and Analytics for HCM -
OTBI British Summer Time effecting dates in Payroll - Element Entries History Real TimeSummary: British Summer Time (GMT +1) is producing incorrect results from the date Prompt using Effective Start annd End Dates Content (please ensure you mask any confid…Kevin Robertson 7 views 0 comments 0 points Started by Kevin Robertson Reporting and Analytics for HCM
-
Organization tree OTBISummary: We have an Organization Tree in Fusion HCM where: LE = Top Parent Node Division = Child Node under LE Departments = Child Nodes under that Division LE-->Divisio…charan_Gudla 52 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Issue is when we add termination date in two subject areas OTBI reportSummary: Hi Team, when we add the two subject areas it showing correctly but when i adding termination date it showing two rows as below ? one is with termination record…AjayKumar Maddipati 49 views 10 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Populating the manager hierarchies for OTBI reportingSummary Provides the steps the populate the various manager hierarchies available in HCM OTBI Content This document provides details on the process that allows the custo…Raghavendra Raghunath-Oracle 1.4K views 14 comments 11 points Most recent by Ruvina Khan Reporting and Analytics for HCM -
OTBI Report with SQL query filterSummary: Hi Team, We have a custom reporting requirement that involves applying complex, SQL-based filters. We are planning to implement this logic within an OTBI report…
-
Volume of email notifications by typeSummary: I have a stakeholder who has requested the volume of emails by template sent by HCM to workers by Month. We have BI Burst, Alert Composer, and Seeded Notificati…SusanJ 17 views 2 comments 0 points Most recent by Andre Brown-Support-Oracle Reporting and Analytics for HCM
-
Is there an API in Oracle that can extract the OTBI Analysis Criteria XMLSummary: We have lot of OTBI analysis which are being used for Learning initiatives/recommendations. These reports have filters on Organizational levels/Names. Whenever …
-
OTBI Analysis Report – Duplicate Rows Issue Even After Enabling DISTINCTSummary: I am working on an OTBI analysis where I am seeing duplicate rows in the output. For example, the same Person Number and Person Name (e.g., "101 – Ben") is repe…Manoj Muddineni 60 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Need to Extract Termination Transaction Approval DetailsSummary: Need to Extract Termination Transaction Approval Details Content (please ensure you mask any confidential information): Hello Experts, We have a requirement to …Vasanthakumar Ravi 23 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Check-Ins ReportContent We are considering implementing the Check-Ins feature in our 2021 performance reviews. We will need to be able to track completion rates. Perhaps I am overlookin…User_2025-10-31-00-57-47-193 77 views 7 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Want to fetch row values based on another column's value.I want to print mid salary values which are highlighted in screenshot, based on columns "overtime" and "grade rate name".Raja Subramanian-Oracle 18 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
how to fetch top 10 otbi reports that users access frequentlySummary: The request is to fetch the top 10 OTBI reports that users access frequently on their dashboard Content (please ensure you mask any confidential information): R…SivaNallagatla 44 views 7 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
BIP: For Year Parameter, Set Default Value as Current Year and attach LOV (SQL Query LOV) to the YeaSummary BIP: For Year Parameter, Set Default Value as Current Year and attach LOV (SQL Query LOV) to the Year ParameterContent Hi, This is related to earlier post: https…User_MC37Q 1.1K views 5 comments 1 point Most recent by NIRMAL KUMAR L Reporting and Analytics for HCM -
Report or SQL Query to Identify Unused Departments in Department TreeHi Team, We’re looking to generate a report that identifies unused departments within our department tree. Specifically, we’d like to find departments that: Have no asso…Mahendra Y 7 views 1 comment 0 points Most recent by Carl Bequilla-Oracle Reporting and Analytics for HCM
-
Reporting/Managing on Goal Plan EligibilitySummary Can goal plan eligibility be managed like Performance documents can?Content I've been searching the forums but haven't found a clear answer. I have a lot of ques… -
Generate Employment Letter from Employee Self ServiceSummary: Hello Experts, We have a requirement to develop the Employment Letter from the system from the employee self service. We have checked in the delivered Document …Jaydeep.More 18 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
HR Action / Termination Action in Manage Work RelationshipSummary HR Action / Termination Action in Manage Work RelationshipContent Hi - We are trying to move all of our BI Publisher reports to Analysis and encountered an issue…Roy Paolo Paunlagui 201 views 13 comments 1 point Most recent by Anjaneyulu Reporting and Analytics for HCM
-
OTBI/BIP catalog/folder last update date differenceHI Team, After a refresh/upgrade/patch getting applied does the folder last modified date change for each folder. We could see some folders have different last modified … -
OTBI Report (Dashboard) Security Not Mirroring FusionContent My understanding of the OTBI security is that security applied in Fusion will also be applied when running reports. You'll see the same data. However, if additio…Rebecca L Smith 64 views 13 comments 0 points Most recent by GPOtimization Reporting and Analytics for HCM
-
Need to get the OTBI Schedule Agent Information Report Jobs.Summary: Content (please ensure you mask any confidential information): We need to the details of OTBI agent schedule report jobs when the report was run details, who ra…VishnuVardhan Raju 32 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM