OTBI
Discussion List
-
Descriptive FlexfieldsSummary Deploy Descriptive Flexfields to Unified Sandboxes [HCM 20B]Content Please provide information of new features in Deploy Descriptive Flexfields to Unified Sandbo…User_080V4 46 views 3 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Salary reportSummary Salary reportContent I need a report which pulls current salary and previous salary details. Can any one have SQL to pull the data. PERSON_NUMBER OLD_SALARY_STAR…Reddykrishna Chidella-Oracle 202 views 9 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
OTBI performance recommendations V2 paper (2679006.1) is available on MOS PortalSummary OTBI performance recommendations V2 doc is intended for OTBI system integrators, BI report developers and admins. It covers advanced performance tuning technique…Pavel Buynitsky-Oracle 83 views 2 comments 5 points Most recent by Pavel Buynitsky-Oracle Reporting and Analytics for ERP
-
CASE Statement - Multiple rows in OTBIContent Hi, We have local legislative requirement for a report do deliver it in certain type of format. As the information is stored differently in HCM Cloud e.g. Elemen…User_KOLMZ 337 views 6 comments 0 points Most recent by User_2025-02-06-14-37-05-233 Reporting and Analytics for HCM -
Is it possible duplicate the General Ledger and Subledger Accounting by Journal Lines Report?Summary It is need edit the parameter and keep using the account filter parameter.Content I need create a replication of 'General Ledger and Subledger Accounting by Jour…
-
Adding labels on X axis in OTBI report under graph ViewSummary I am trying to add labels on X axis in graph view of OTBI report.Content I am trying to add labels on X axis in graph view of OTBI report.I am creating on OTBI a…User_2025-02-06-15-04-02-124 59 views 1 comment 1 point Most recent by Nivya Mathire Reporting and Analytics for HCM -
Looking for Position ReportSummary Would like number of unfilled positions, organization chartsContent Hi everyone - we are underway with preparing to implement Position Management. We currently u…Ashley Cossey 94 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI Workforce Trends - Time Column Values Are not Accurate or are BlankSummary Calendar Quarter and Calendar Month do not render correctly in the reportContent We have a requirement to show period active start and end headcount by different…Karen B 24 views 3 comments 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Calendar PromptSummary I would like to add a calendar promptContent Hi, I have added AsOf date prompts to various reports and here I would like to include a between date prompt using t…User_2025-02-05-22-44-35-842 71 views 5 comments 1 point Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM
-
OTBI Matrix Manager ReportSummary OTBI Matrix Manager ReportContent Hi Team, We are working on a OTBI report where client want to add all matrix managers and should extract all manager in single …User_2025-02-01-03-43-13-079 126 views 2 comments 2 points Most recent by User_2025-02-01-03-43-13-079 Reporting and Analytics for HCM
-
Looking for solution to "https://cloudcustomerconnect.oracle.com/posts/a3fe9e182c?commentId=407101#4Content Hi, I have a requirement exactly like "https://cloudcustomerconnect.oracle.com/posts/a3fe9e182c?commentId=407101#407101". I am not able to resolve it using MAX()…User_2025-02-06-14-37-05-233 33 views 2 comments 1 point Most recent by User_2025-02-06-14-37-05-233 Reporting and Analytics for HCM
-
OTBI Dashboard to Monitor AssessmentsSummary Includes deep drills to control and assessment records in Risk Cloud pagesContent This dashboard is useful for monitoring and acting on open assessments as well …Stephanie Golly-Oracle 69 views 0 comments 3 points Most recent by Stephanie Golly-Oracle Reporting and Analytics for ERP -
Parent manager blank for terminated employees.Summary Parent manager blank for terminated employees, how to retrieve manager hierarchyContent Hi all, we are facing some issues with OTBI report, we are using Parent M…Nicola Petri 103 views 4 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
How to get the Manual Journal Reconciliation Details?Summary How to get the Manual Journal Reconciliation Details?Content How to get the Manual Journal Reconciliation Details? -
OTBI Specialization Deep Link ReportSummary This report lists all Specializations and respective Deep LinksContent This is an alternative solution for MOS Doc ID 2535239.1 The Oracle Learning Cloud Special… -
Recommend to RehireSummary Termination - Recommend to RehireContent Hi, Where can I find the 'Recommend to Rehire' flag value to report on? For context, when someone terminates a dropdown …User_2025-02-05-22-44-35-842 72 views 6 comments 2 points Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM
-
OTBI Course Deep Link ReportSummary This report lists all Courses and respective Deep LinksContent This is an alternative solution for MOS Doc ID 2535239.1 The Oracle Learning Cloud Course Deep Lin…
-
View Objects to get Invoice Headers and its Business Unit?Summary Need Invoice Header and Business Unit of those invoices.Content Hi. I'm working with VO extracts in Tableau. I'm using: fscmtopmodelam_finapinvtransactionsam_inv…User_2025-02-07-06-48-26-537 38 views 4 comments 1 point Most recent by Sahil_Makhiza Reporting and Analytics for ERP
-
Graphs in OTBISummary Can graph with data count be created in OTBIContent Can we create a graph close to how it is shown in the image in OTBI?pooja yelsangikar-Oracle 47 views 4 comments 0 points Most recent by pooja yelsangikar-Oracle Reporting and Analytics for HCM -
Error while joining two subject areasSummary Error while joining two subject areas (No fact table exists at the requested level of detail:)Content I am trying to fetch list of roles that a worker has along …User_2025-01-25-04-02-13-126 69 views 12 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI Prompt: User Selects Operator "Between"Summary If you allow users to select the operator for a date prompt, the value "between" is not available.Content We have a requirement to allow end users to select the …
-
Element Entry for Each WorkerContent Hi Guys, I have to create a report that allow me to extract the Element Entries associated to each worker. But I have a problem, when I Add the "Worker"."name" c…Giuseppe Iacono 104 views 10 comments 0 points Most recent by User_2025-02-06-14-37-05-233 Reporting and Analytics for HCM -
Need help getting drill to detailed analysis from pivot table to workContent I'm trying to create a dashboard which contains some prompts and a pivot table. When a value in the pivot table is clicked, I want the detailed report to open. T…