OTBI
Discussion List
-
Is there a way in OTBI not BIP to combine a "Security" with a "Workforce Management" Subject AreaSummary: Trying to combine Security Subject Area to a WFM Subject Area so we can see role on a user and which department they are in Content (required): There is an inte…Clifford Trett 11 views 2 comments 0 points Most recent by Clifford Trett Reporting and Analytics for HCM -
Termination Date for ManagersSummary: We are looking to create a report with employees with a manager who has a future termination date. How would I include the managers termination date? Content (r…Jo Black 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
OTBI Personal Payment method DetailSummary: I need Employee's Personal Payment method Details like IBAN and bank account info. My client wants to add these fields to the existing OTBI report. Currently, I…Saher 444 views 1 comment 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Subject Areas - Seniority Dates and Per Periods of ServiceSummary Subject Areas - Seniority Dates and Per Periods of ServiceContent We are wondering if there is a subject area, or an enhancement to allow for analysis to retriev…Dustin Puchalla 418 views 12 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How should I write multiple data returned from a column separated by commas next to each other?Hi, I actually have a pretty simple little query. More than one data is returning from this column and I want to write it on the same line separated by commas. SELECT YY…Cansel Karasoy 41 views 4 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
Performance Document Ratings - Dashboard - Prompt QuestionSummary: OTBI - can a prompt be used to define which column to be used in a filter Content (required): I'm trying to generate a dashboard prompt which will define which …David McLellan 41 views 9 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
OTBI Reports for BPA or CPA ?Summary: Role requiered to create either a BPA or CPA ? Content (required): Hello I would like to setup either a BPA or CPA , I think the process is 1.-Create a BPA or C…
-
Report to view workflow configuration in Fusion HCMSummary Report to view workflow configuration in Fusion HCMContent In Fusion HCM, we navigate to 'setup and maintenance' > 'Manage approvals for Human Capital Management…User_2025-01-25-04-02-13-126 384 views 12 comments 0 points Most recent by SanjayC Reporting and Analytics for HCM -
Workforce Talent Review - Talent Review Tasks Real Time reporting bug?Summary: How can we pull a report using this subject area to provide an administrative overview of all existing tasks in a Talent Reviews within the system? Content (req…William_Johnson 21 views 2 comments 0 points Most recent by William_Johnson Reporting and Analytics for HCM
-
What optimization is done for BICC extracts in 23A patchSummary: Optimization extraction to BICC in 23A patch. Content (required): BICC is providing EFF attribute extraction before the 23A patch itself, however, the increment…Shyledher Boddu 151 views 1 comment 2 points Most recent by Gaurav Johri-Oracle Product Master Data Management
-
Learning Records Real Time in OTBI not producing any results for activity sequencing 23A use caseSummary: Learning Records Real Time Subject Area in OTBI is not producing any results when we replicate the learner progress example in the 23A weekly release notes - Or…
-
OTBI Analysis transaction report giving wrong result.Summary: Hi Everyone!. I have created an OTBI Report which fetches the Document of Records Transaction. Context: If anyone modifies something in the Document type called…ShawShankk 61 views 6 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Date of Birth less than 16 yearsSummary: Employees with Date of Birth less than 16 years. Content (required): I need to create a list of employees with a Date of Birth recorded that would make their ag…
-
Data Table details for Affected Assets under Work Requirement.Summary: Please help in identifying the data Table for the marked content in attached image. We need to include it in a BIP report. Thank you Content (required): Forecas… -
HOW TO PASS AsOfDate TO OTBI AGENT OUTPUTSummary: We have created a OTBI report with AsOfDate prompt which is getting passed . This report will be scheduled monthly through agent. Our requirement is send the ag…Aathimoolam R 31 views 2 comments 0 points Most recent by Aathimoolam R Reporting and Analytics for HCM
-
Report on specific Manager and his/her actions with employeesSummary: Content (required): Good afternoon. We have a request to identify any employees that one specific manager either Supervised (their direct supervisor), Hired (th… -
Restricting LOV for a Line Manager Login for OTBI DashboardsSummary: We have a Line Manager and he is the from Operations department, when he opens the line manager dashboard from his account then he is eligible to see only the O…Nalsoft Pvt Ltd 82 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to display indirect terminations for a specific manager?Summary: We have a requirement to build OTBI (Graphs) to display number of terminations under a specific manager. There are 2 OTBI analysis I use in the dashboard - 1 wh…Vijay Rajendran 31 views 9 comments 0 points Most recent by Dannielle Dellucci Reporting and Analytics for HCM
-
Looking for Learning Reports specified in 20A release notesSummary: NOW RESOLVED. 22/05/23 Hi, I'm looking for a set of reports that were listed on the 20A Oracle release notes (https://www.oracle.com/webfolder/technetwork/tutor…
-
Converting payroll elements from one currency to anotherSummary: Content (required): Hello experts, Do you know if now it is available in OTBI and UI the possibility to convert payroll elements from one currency to another ac…Valerio Curzi 41 views 3 comments 0 points Most recent by Valerio Curzi Reporting and Analytics for HCM -
Reporting and Documents of Record Updating / UploadingHi all, Apologies if this is the wrong place to ask. We're looking to build a report within BIP that produces a letter of reference that can be saved to an employee's do…
-
Infolets: need to extract the query of the Receipt Lines infoletsSummary: Could I extract the query under the "Receipt Lines" infolets? I need to extract the same details about the lines to be received, to be inspected and to go to Pu…Giuseppe Galluzzo 51 views 2 comments 0 points Most recent by Giuseppe Galluzzo Inventory Management
-
Attrition Rate DashboardSummary: Hi Everyone, I am just wondering, if there is any seeded dashboard available to fetch the information about the attrition rate. Thanks in advance. Version (incl…ShawShankk 104 views 1 comment 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to pull rehire date in OTBI REPORT?Hi Team, How to pull rehire date in OTBI REPORT? ThanksSM_EP 211 views 2 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Number of columns mismatch. Expected: 6 columns. Actual: 7 columns.Summary It is happening while adding "Worker"."Person Number" on groupbyContent Hi, we are facing an error while we are adding "Worker"."Person Number" on groupby. The e…Nicola Petri 72 views 4 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
How can restrict the data in reports?Summary: How can restrict the data in reports? Content (required): Hi Team, Can some one help me to understand, how to restrict the data in reports. For example we have …
-
Query for Plans without Incumbents and/or candidatesSummary: Need assistance wtih querying plans that have no incumbent and/or candidates. Including Incumbent or Candidate counts appears to exclude plans that do not have … -
Application usage reportHow long the audit data has been captured without doing any configuration related to the application usage insights? What is the minimum time period (days/months/years) …Sangeetha Kumar 121 views 8 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
Report on Learning Alerts Notification ReportingSummary: I'm looking to see if there are any OTBI subject areas or BI tables that can be used to report on the learn notifications that are sent out using the Alert Comp…Mahesh_M123 171 views 4 comments 0 points Most recent by Swaraj_Sudhagonela Reporting and Analytics for HCM