OTBI
Discussion List
-
we have OTBI Report skills and certfications but it showing unparallely ?Summary: HI Team, We have report facing this is how can sorted Content (required): Version (include the version you are using, if applicable): How it looks in the report…AjayKumar Maddipati 21 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Tree Name Criteria Dropping out International & Non-EmployeesSummary: Hi - I am creating a report with a number of different fields pulling from the following subject areas: When I have all of my criteria EXCEPT for the tree name,…Kyle Norris 22 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Prepare Review Content example reportsSummary: Prepare Review Content Subject Area: Workforce Talent Review - Talent Review Meeting Real Time Content (required): Hi All, We are looking to better engage our e…William_Johnson 21 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
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… -
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 12 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 439 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 392 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 44 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 44 views 9 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
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 373 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 22 views 2 comments 0 points Most recent by William_Johnson Reporting and Analytics for HCM
-
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 51 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…
-
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 32 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 81 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 42 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…
-
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 95 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 210 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 76 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 … -
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 172 views 4 comments 0 points Most recent by Swaraj_Sudhagonela Reporting and Analytics for HCM
-
Workforce Goals Goals Status Overview Real Time and Workforce Goals - Goal Plan Assignments RTSummary: Hello, I'm trying to create an OTBI report that requires two subject areas (Workforce Goals Goals Status Overview Real Time and Workforce Goals - Goal Plan Assi…Hazel De Castro 41 views 8 comments 0 points Most recent by Hazel De Castro Reporting and Analytics for HCM
-
Excel document that shows OTBI subject area, BI duty role name and BI job role for access purposeSummary: Need an excel document that shows HCM OTBI subject area, BI duty role name and BI job role for access purposes similar to attached output that was available in …Ibrar Hussain 72 views 1 comment 0 points Most recent by Asmit Piyush Reporting and Analytics for HCM
-
How cHi, I want to write a query that reCansel Karasoy 42 views 1 comment 0 points Most recent by Asmit Piyush Reporting and Analytics for HCM
-
Line Manager information in OTBI reportSummary: If any employee is Line Manager for other employee record then we need to display 'X' value. Content (required): Ex: Output: In the above scenario 66789 and 123…Visu 438 views 8 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM