OTBI
Discussion List
-
CONCAT Area Code and Phone NumberSummary I want to combine an employees work, home, and cellular phone number so area code isn't a seperate columnContent Using this forum topic https://cloudcustomerconn…User_2025-01-28-08-47-04-905 141 views 5 comments 0 points Most recent by User_2025-01-28-08-47-04-905 Reporting and Analytics for HCM -
Creating a Filter Based on Staff with Multiple Rows of Data in AnalysisSummary Creating a filter that will only produce records when an employee has more than one row on the reportContent Hi- I'm working on building a report to focus specif…Bernadette L 56 views 2 comments 0 points Most recent by Bernadette L Reporting and Analytics for HCM -
Error on InfoletsSummary I've created two simple infolets for employees to see HC and FTEContent I've created two simple infolets for employees to see HC and FTE - but when then go to th…User_2025-01-29-19-59-40-005 67 views 2 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to do an average days to approve formula?Content Hi all, I am trying to do an average days formula from a requisition submission date and when it was approved, and then put another column in with the month it w…User_2025-01-29-02-09-34-137 92 views 1 comment 0 points Most recent by Aaron Leggett Reporting and Analytics for ERP -
Traversing Department Tree in Reports with a ParameterSummary The ability to use one parameter in an otbi report for the department hierarchy as opposed to the multiple levels of departments being handled individuallyConten…User_2025-01-25-00-51-33-059 145 views 7 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Best Practice for text formattingSummary Building and exporting reports with text fieldsContent In building out a report around goals we're encountering issues with exporting the data. If we export the …User_2025-01-28-08-47-04-905 49 views 4 comments 1 point Most recent by User_2025-01-28-08-47-04-905 Reporting and Analytics for HCM -
Grouping monthly figures to create YTDSummary Grouping monthly figures to create YTDContent Hello, I am trying to create an OTBI report within the Subject Area called 'Payroll - Payroll Run Results Real Time…User_2025-01-30-03-54-32-528 68 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Application Policy NameContent Hi, We are on Cloud R12. Oracle provides an audit report by name "User Role Membership Report". This report displays all the roles a user has in cloud. Is there … -
R13 SCM and Procurement OTBI subject area Description documentationSummary R13 SCM and Procurement OTBI subject area Description documentationContent This documentation is published by Oracle OTBI development. This document provides use…Tu Lam 564 views 1 comment 10 points Most recent by Farooq Syed, CPA, PMP, CISA Reporting and Analytics for SCM -
Standard Financial DashboardsSummary Need to create some basic Financials Dashboards, which gives a clarity over Company Financial HealthContent Hi All, I have implemented Oracle Financials Cloud fo…User_2025-01-29-20-34-14-699 165 views 2 comments 0 points Most recent by Farooq Syed, CPA, PMP, CISA Reporting and Analytics for ERP -
After R12 upgrade BIP and OTBI reports are not defaulted to custom Inquiry roleSummary After R12 upgrade BIP and OTBI reports are not defaulted to custom Inquiry roleContent After R12 upgrade BIP and OTBI reports are not defaulted to custom Inquiry… -
Static Data ColumnsSummary Is there a way to 'repurpose' a column from an OTBI subject area with a static data value, conditionally?Content Hello Customer Connect Community! Is there a way…User_2025-01-22-19-43-38-766 41 views 3 comments 0 points Most recent by User_2025-01-30-03-53-16-644 Reporting and Analytics for HCM -
"Private" goal measure in Goals reportsSummary TRying to identify the right measure to use in an analysis to show private goalsContent Hi there, in OTBI I'm trying to create a Goals reports by creating an ana…User_2025-01-23-23-26-05-357 40 views 3 comments 0 points Most recent by Dr Surlina Yin-Oracle Reporting and Analytics for HCM -
Show those with No Goals in a Goal ReportSummary Creating a report which shows those with no goals in a particular goal planContent I'm looking to create a report that shows a count of goals for users along wit…User_2025-01-22-19-54-00-543 89 views 4 comments 0 points Most recent by User_2025-01-22-19-54-00-543 Reporting and Analytics for HCM -
OTBI Analysis- Column PropertiesContent I have created an OTBI analysis based on Workforce Performance - Performance Rating Real Time subject area. Requirement is to review employee goal and competenci…User_2025-01-28-21-18-43-496 84 views 2 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
R13 Risk Management OTBI subject area Description documentationSummary R13 Risk Management OTBI subject area Description documentationContent This documentation is published by Oracle OTBI development. This document provides users a…User720640-Oracle 88 views 1 comment 5 points Most recent by Youssouf Reporting and Analytics for ERP -
What job role gives access to Human Capital Management – Approval Notification Archival Real Time suSummary What job role gives access to Human Capital Management – Approval Notification Archival Real Time subject area ?Content What job role gives access to Human Capit…Ruzwan Akram 80 views 2 comments 2 points Most recent by Sricharan Monigari Reporting and Analytics for HCM -
Fusion Field - OTBI Subject / Folder MatrixContent Afternoon all, Is there a master matrix anywhere that lists fields in Fusion and cross-references them to their location subject area / folder / sub folder in OT…User_2025-01-28-05-39-23-766 117 views 2 comments 1 point Most recent by User_2025-01-28-05-39-23-766 Reporting and Analytics for HCM -
Data mapping for Oracle Business Intelligence Cloud Connector ConsoleSummary Mapping details for file extracts offerings from 'Oracle Business Intelligence Cloud Connector Console' and BI Apps Tables.Content We get 'Oracle Business Intell…Senthilrajan V 167 views 1 comment 0 points Most recent by Rohan Lobo-Oracle Reporting and Analytics for ERP -
Valid Job Grade reportingSummary We are trying to determine if we have muliple Valid Grades for Job CodesContent We found some Job Codes with multiple Valid Grades and I am having difficulty wri…User_2025-01-23-21-24-21-434 146 views 5 comments 2 points Most recent by Nitin.Goswami Reporting and Analytics for HCM -
Workforce Management - Timecard Application RoleContent Hi All, We are currently struggling to obtain data from: "Workforce Management - Processed Time Cards Real Time" "Workforce Management - Reported Time Cards Real…Aaron Leggett 31 views 2 comments 0 points Most recent by Aaron Leggett Reporting and Analytics for HCM -
Custom report to capture performance ratingsContent I need to create a custom report to capture both goal and performance ratings given by worker and manager in performance document. Is there any subject area to g…User_2025-01-28-21-18-43-496 89 views 3 comments 0 points Most recent by User_2025-01-28-05-39-23-766 Reporting and Analytics for HCM -
Changes only data in BI ReportsContent Please consider the following scenario: The Department of an employee is updated from 'Department A' to 'Department B' on 15th December 2017. The report is run o…Amrit 341 views 9 comments 0 points Most recent by User_2025-01-25-06-20-12-259 Reporting and Analytics for HCM -
Report on Comments from Performance FormsSummary I'd like to report on the manager and employee comments from a performance docContent Managers and employees are asked to provide a rating and comment on each co…User_2025-01-25-00-37-41-739 254 views 2 comments 1 point Most recent by User_2025-01-25-00-37-41-739 Reporting and Analytics for HCM -
How administrator refresh the server metadata?Content Hi, I am getting below error while running the analysis, how to refresh administrator server metadata please ? Result field position: 10, has metadata data type …User_7836 488 views 1 comment 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Dashboard security issueContent Hi I have added analysis to dashboard page , when I ran it its giving below error , from other user it is working fine , but with the specific user it is giving …User_7836 39 views 7 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Performance Document Eligibility Analysis errors outSummary I'm trying to create an analysis using Workforce Performance - Performance Document Eligibility Real Time subject area, but it errors outContent I need to get a …Gala Meyerovich 62 views 10 comments 0 points Most recent by Rebecca Emerson Reporting and Analytics for HCM -
Uk compliant VAT report in r12Content All,We are trying to find a uk compliant report or processes/white paper that we can use to run our vat returns from, are you please able to point me in the righ…User_2025-01-29-02-09-34-137 39 views 1 comment 0 points Most recent by Veronica Dumitriu Reporting and Analytics for ERP -
Max Custom BIP Reports that can be run as a scheduled jobContent Hi, My customer has a custom BI Report. It is similar to a Compensation Statement. Each report run has 2 pages per worker as output, in PDF. If a Line Manager wi…User_2025-01-30-03-39-56-442 23 views 4 comments 0 points Most recent by User_2025-01-30-03-39-56-442 Reporting and Analytics for HCM