OTBI
Discussion List
-
XML/Catalog for sample dashboardSummary XML/Catalog for sample dashboardContent Hi All, I am looking for some help on sample dashboards based around below pointer, if someone can please share some XML/…Sachin Sirohi 101 views 5 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM -
Calculation using Pivot Table SumSummary Pivot Table Sum * Hourly rate for General LedgerContent Hello, We are currently trying to use an Absence Balance Report to identify any outstanding liabilities f…User_2025-01-31-00-25-12-234 71 views 2 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM -
Custom OTBI View Only Role for use across subject areas in ERP CloudSummary Need instructions to create customl OTBI View Only Role for use across subject areas in ERP CloudContent Hi Experts, I've searched and read lots of related docum…User_2025-01-31-01-53-04-402 87 views 1 comment 0 points Most recent by Milind Dalvi Reporting and Analytics for ERP
-
Multiple lines of data on "Extra Information"Summary Pulling data from extra information, appears to produce duplicate lines when changes are madeContent Hi I'm trying to build a report using the Personal / Extra I…User_2025-02-03-23-33-26-899 46 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Roundup Values in reportsContent We have created a OTBI report and a SQL based BI report. Both of them showing values with decimal numbers. We need to round up values. Is it possible ? Please sh…User_2025-01-28-21-18-43-496 42 views 2 comments 0 points Most recent by User_2025-01-28-21-18-43-496 Reporting and Analytics for HCM
-
Unarchive error message: Error saving security accountSummary Error saving security accountContent When I Try to Unarchive a catalog in BI publisher, I'm getting the error message "Error saving security account" -
Payroll - Element Entries subject area not returning data in productionSummary In production, for the Payroll subject are, adding more than one dimensions results in no dataContent We have a report with multiple UNIONS, but the main subject…User_2025-01-30-04-37-05-780 40 views 2 comments 0 points Most recent by User_2025-01-30-04-37-05-780 Reporting and Analytics for HCM
-
How to Calculate MTD and YTD in Oracle BI Analysis ReportsSummary How to Calculate MTD and YTD in Oracle BI Analysis Reports using Project Costing Actual Costs Real Time and Project Control Budgets Real TimeContent Hi, I am try…Avesh Ganodwala-57885 250 views 2 comments 0 points Most recent by Avesh Ganodwala-57885 Reporting and Analytics for ERP -
Add Account Parmeter to Custom BI Puslisher ReportContent Hi Friends, I want to add account form and account to parameters to custom bi publisher report. I tried using add flex field process but unable to create paramet…User_2025-02-03-21-33-20-159 50 views 0 comments 0 points Most recent by User_2025-02-03-21-33-20-159 Reporting and Analytics for ERP
-
Default Presentation Variable Prompt to AllContent Hello Customer Connect community, Is there a way to default a presentation variable to default to all? I am using the following syntax in my logical SQL: AND Cou…User_2025-01-22-19-43-38-766 110 views 5 comments 0 points Most recent by User_2025-01-22-19-43-38-766 Reporting and Analytics for HCM
-
OTBI Feedback Survey closing Nov 30thContent https://oraclehcm.influitive.com/challenges/486 Please use the above link to provide us with feedback on OTBI to help us improve our product. The short questionn…Julian Challenger-Oracle 78 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
R13.18A OTBI BI Catalog LockdownSummary With 13.18A release customers will no longer be able to modify the shipped BI catalog content.Content R13.18A OTBI Product Alert This product alert is published …User720640-Oracle 718 views 7 comments 9 points Most recent by User720640-Oracle Reporting and Analytics for HCM -
Workers Missing from Performance Document Eligibility Subject AreaSummary Population in Performance Document Eligibility Not the same as Assignment Real timeContent Hello, I'm trying to produce a simple report that shows the list of wo…Rob F 66 views 5 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Changing date format from 2018-07 to Jul-2017Summary Changing date format from 2018-07 to Jul-2017Content ello, What is the syntax to change from Time Dimension Month Code from 2018-07 to Jul-2017. When I try to ch…Sanjay Shah-135946 34 views 2 comments 0 points Most recent by Sanjay Shah-135946 Reporting and Analytics for SCM
-
Scheduled report doesn't have all rows. Stops at 25k rowsSummary Scheduled report doesn't have all rowsContent One of my OBTI report gives me 65k rows. IF i were to schedule this and deliver my excel2007+, it generates only to…User_2025-01-25-04-02-13-126 63 views 1 comment 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI REPORTS DO NOT SHOW DATA WITH NON-ENGLISH LANGUAGESummary As a HR person from France, the OTBI report for performance evals summary does not work when the user is connected in frenchContent Steps: 1. Login as a HR user …User_2025-01-25-04-15-38-949 38 views 1 comment 3 points Most recent by User_2025-01-22-18-30-18-571 Reporting and Analytics for HCM
-
Assignment Manager - Performance / GoalsSummary Issue with Displaying Performance / Goals with Assignment ManagerContent I cannot figure this out I have added the Assignment Manager to a report for Goals for L…User_9EWTS 54 views 5 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
How to pass the string values from the dashboard prompt to analysisSummary passing string values to the analysis which is created from direct database request from the dashboard promptContent I am creating a analysis using direct databa… -
Some business unit employee data missing while working on Organization HierarchySummary Some business unit employee data missing while working on Organization Hierarchy in AnalysisContent My requirement is to count employees as per business unit nam…User_MC37Q 31 views 4 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Send a report to SFTP siteSummary How to send reports to a SFTP siteContent Very new to Oracle, but wondering how we can send reports to SFTP sites? Is there a good reference material on this? Th…Mike Borghoff 123 views 5 comments 1 point Most recent by Scott Gallup Reporting and Analytics for HCM
-
One page entry with several dashboardsContent I need to enable one page entry for a specific user with several dashboards. I have created a page entry in the welcome page and now it is showing. Then how to s…User_2025-01-28-21-18-43-496 69 views 4 comments 1 point Most recent by User_2025-01-28-21-18-43-496 Reporting and Analytics for HCM
-
Can you add a prompt to an analysis that uses a left outer join (or any join)?Content I have created an analysis that pulls in data from the "Workforce Succession Management - Talent Pools Real Time" subject area and the "Workforce Profiles - Pers…Duane Gay-Oracle 80 views 5 comments 1 point Most recent by Sandra Barr Reporting and Analytics for HCM -
Show blob image in OTBI report.Summary Blob image in OTBI report.Content Hi I have a requirement in which I must show an image in a report found in the per_images table. When I am building my .rtf fil…Cesar Tepetla Corte 84 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Length of service - GroupsSummary How to group length of serviceContent Hi, I'm doing some reporting & dashboards and was looking for a way to group the years of service into groups. i.e. number …User_2025-02-03-23-33-26-899 65 views 8 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Filter slowing down report?Content Hi all - we are working on reporting through our Compensation - Workforce Compensation Real Time subject area. We are only using the one subject area. It's a sum…Prudence K 46 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Absence Reason in Calendar Details Subject AreaContent Hi A new Subject Area was added in R13 for Absence Reporting - Workforce Management - Absence Calendar Details Real Time. This is populated by a background proce…User_2025-01-25-01-23-28-110 69 views 4 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Procurement - Spend Real Time Field mappingSummary Incorrect field mapping observedContent I have observed that the " Accounting Date" and "Accounting Period" columns in the "Time-Fiscal Calendar" presentation ta…Rohith Thomas 52 views 2 comments 0 points Most recent by User578443-Oracle Reporting and Analytics for ERP -
Spend in functional currency and what is "Invoice measures OBSOLETE"?Summary How to get spend in functional currencyContent I have created a spend analysis based on "Spend Real Time" subject area. Problem is, some of our suppliers invoice…User_2025-01-29-01-07-02-312 45 views 2 comments 0 points Most recent by User_2025-01-29-01-07-02-312 Reporting and Analytics for ERP