OTBI
Discussion List
-
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
-
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
-
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 101 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 77 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 -
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 32 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 116 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 70 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 66 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
-
Report failing when using 3 subject areasContent Hi I have a report pulling data from 3 different subject areas, which is failing despite they all include a fact from each, they all contain a common dimension (…User_2025-01-29-19-59-51-150 32 views 2 comments 0 points Most recent by User_2025-01-29-19-59-51-150 Reporting and Analytics for HCM
-
InfoletSummary The duplicate column is appering once click on the one of the column in the Trigger Report ( Expanded View)Content Hi All, I am facing the below issue can any on…Swaroopa Chenagarapu-130214 58 views 7 comments 1 point Most recent by Thiru Ch Reporting and Analytics for HCM
-
Employees with Work NumbersSummary Return report for all employees and just list work numberContent Trying to build a report that lists all employees and in the phone type column only return Work …Mike Borghoff 34 views 3 comments 2 points Most recent by Mike Borghoff Reporting and Analytics for HCM
-
How to merge Direct database request Analysis and analysis which is developed by subject areaSummary i need to combine the columns of direct database request analysis with other analysisContent My requirement is to count the employees with status of the goal. so…User_MC37Q 51 views 1 comment 0 points Most recent by Rebecca Emerson Reporting and Analytics for HCM
-
ORA-00600: internal error code, arguments:Summary I am creating an analysis by Using direct database request.I am getting An error code: 00600Content I am creating an analysis by using direct database request.I …
-
OTBI Date DifferenceSummary Attempting to determine the number of days between record update and record effective dateContent I have reviewed other posts related to date difference within C…User_2025-01-28-08-47-04-905 134 views 10 comments 0 points Most recent by Joey Domhof Reporting and Analytics for HCM
-
Print Dashboard vs Print AnalysesContent Hi all - I have seen a few posts about this but have not seen a solution and am hoping you can assist. Our users access reporting by signing into Fusion and then…
-
"Approval Delegate to others" table nameSummary "Approval Delegate to others" table nameContent Hi All, i have an requirement to get report of all the "Approval delegate to others" in oracle fusion .i am unabl…nitin Sharma 69 views 2 comments 0 points Most recent by nitin Sharma Reporting and Analytics for HCM
-
How to restrict access of dashboard prompt depends on the user roleSummary Can we restrict access of dashboard prompt depends on the user roleContent My requirement is to create one dashboard releated goals.so if the user is line manage…
-
Pay Cost Allocation in OTBISummary Department Costing information in OTBIContent Hello Guys, Do you know which Subject Area I can find Pay Cost Allocation details? More specifically, I need to bui…Alvaro Couto 116 views 4 comments 0 points Most recent by Alvaro Couto Reporting and Analytics for HCM -
Can we get Parent Business Unit Name of business Unit name in Analysis?Summary How to get Parent Business Unit Name of business Unit name in AnalysisContent How to get Parent Business Unit Name of business Unit name in Analysis.My requireme…