OTBI
Discussion List
-
SQL Expression for a specific month and day with a year of current year - 1Content Hi - I need to add a filter to an OTBI report that is hire date greater than 10/1 of the prior year. I would like to make the year dynamic based on the year of t…Julia SRI International 143 views 1 comment 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
How can we find roles/access needed for a subject areaSummary How can we find roles/access needed for a subject areaContent Hi All, We are on R12. Our OTBI subject areas (for FIN and PRC) are working only for some users and…
-
Phones and emails make duplication rowsSummary I'm trying to add columns for emails and phones but instead of one line it's duplicating itContent Hi, I created an analysis in OTBI that shows employees phones …
-
Does Drill down feature work for Logical SQL based Analytics?Summary Want to know if the drill down feature works with analytics developed using Logical SQLContent For one of the requirement it was not possible to use the fields d…Sricharan Monigari 98 views 6 comments 0 points Most recent by Sricharan Monigari Reporting and Analytics for HCM -
Can we expose analytics or dashboards to users on fusion pages without traversing to BI CatalogSummary Can we expose analytics or dashboards to users on fusion pages without traversing to BI CatalogContent We have developed some analytics and dashboards and the cl…Sricharan Monigari 109 views 11 comments 0 points Most recent by Lynda Huebsch-Oracle Reporting and Analytics for HCM
-
Cross Subject Area Dashboard OptionSummary Need to join multiple subject area for dashboard purposesContent Hi, I apologize in advance if this is already discussed in some previous thread- if that is the …User_2025-01-30-19-26-42-218 46 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
FA Retirement & Reinstatement SummarySummary How to Print Retirements and Reinstatements in the same OTBI reportContent Hi, We are trying to print FA Retirement details (Asset Cost, NBV, Gain Loss) and FA R…Sridevi Srikanth 33 views 0 comments 0 points Most recent by Sridevi Srikanth Reporting and Analytics for ERP -
Total Purchases for Tier I SuppliersSummary I need to create an analysis that shows total purchases for specific suppliers.Content I need to create an analysis that shows purchase order line details such a…User_2025-01-28-00-30-46-187 49 views 1 comment 0 points Most recent by User_2025-01-28-00-30-46-187 Reporting and Analytics for SCM
-
Addition of New Field withing Subject AreaSummary How to add new filed (proejct classification) within a particular subject areaContent We have created Project Classification such as "Accounting Business Objecti…User_2025-01-30-19-08-20-842 54 views 1 comment 0 points Most recent by Dustin Grabowski-Oracle Reporting and Analytics for ERP
-
Payroll Activity ReportSummary Page breaks in Payroll Activity ReportContent Hello, It would be really nice if the payroll activity report could page break between person. I think it would mak…Susan Anderson 158 views 3 comments 1 point Most recent by Richard Marko-47911 Reporting and Analytics for HCM -
I Cant find the Flexfield AR_CASH_RECEIPTS in OTBIContent Hi All, I did add Descriptive Flexfield to account receivable - Receipt Screen - under Additional Information ( global segment - Descriptive Flexfield name ( AR_…User_2025-01-29-22-38-36-974 80 views 3 comments 0 points Most recent by alexey.shtrakhov Reporting and Analytics for ERP
-
Publishing a custom dashboard to one user from OTBI in HCM FusionSummary Need assistance in publishing a custom dashboard in OTBI out to a single userContent I have a custom dashboard that I only want one user to have access to. I kno…User_2025-01-25-04-17-41-399 143 views 8 comments 0 points Most recent by Caroline Gladwin-Oracle Reporting and Analytics for HCM
-
Cross Subject Area Search Missing in OTBISummary Recently the instance we are working on (R12) Lost the ability to "Add a Subject Area" for OTBI reportsContent When we try to create a New Analysis and choose a …Sridevi Srikanth 107 views 7 comments 0 points Most recent by User_2025-01-30-21-01-20-715 Reporting and Analytics for ERP
-
Lost 'Add subject area' functionality in OTBISummary Lost 'Add subject area' functionality in OTBIContent Hello, Since this morning, we lost icon that lets you to add additional subject-area during report creation.…SantoshKumarBhairi 58 views 12 comments 2 points Most recent by Aaron Leggett Reporting and Analytics for HCM -
Search a date un value of columns that containts multiple date (DD/MM/YYYY ~DD/MM/YYYY ~DD/MM/YYYY )Summary How to search for date of birth in the actual year from value which contains many datesContent Hello, I want to find persons which their date of birth is in the …User_I6AXL 29 views 3 comments 0 points Most recent by Aaron Leggett Reporting and Analytics for HCM -
Absence leave duration issueContent Hi, I am unable to get the correct leave duration in the analysis , employee has applied for 0.5 days leave , but in the analysis it is showing as 1 day , I have…
-
OTBI Analysis merging columns when exporting to Excel 2010Summary OTBI has starting merging columns since R12 upgradeContent Hi Hopefully someone can help - since our recent R12 patch was applied, a number of our custom OTBI re…JennyB 159 views 2 comments 0 points Most recent by User_2025-01-30-21-01-20-715 Reporting and Analytics for ERP -
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