Category 81
Discussion List
-
Can you change the date format in all the columns that have dates so that it filters by year/MonthSummary: we are using excel template to generate the excel output.Can you change the date format in all the columns that have dates so that it filters by year/Month? Thi…minati_behera-Oracle 31 views 2 comments 0 points Most recent by Abhishek Premchandra-Oracle Reporting and Analytics for HCM -
Bursting to get xml as an attachment from xsl templateSummary: Hello Experts, I have a report where I am using xsl template as layout. Our requirement is to send the report output in xml format to the destination email, but…Jaswant Prajapati 96 views 0 comments 0 points Started by Jaswant Prajapati Reporting and Analytics for HCM
-
How can I combine HCM and Projects subject areas in OTBISummary: I would like to know if it is possible to combine HCM subject areas with e.g. Projects subject areas in OTBI. Content (required): Hi! I'm creating a rather larg…Nicolas Vahman 21 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Phase/ State Application ReportsSummary: Content (required): Hello, We would create an simple OTBI analysis that show for each phase/state the number of active job application, We would order the phase…Giuseppe Iacono 11 views 2 comments 0 points Most recent by Giuseppe Iacono Reporting and Analytics for HCM -
Restrict Report Folder movements in the BI catalog areaSummary: Hi Experts, How do we restrict Folder Movement (Drag and Drop option) of BI Catalog Custom Shared Folders? Is anyone can advise on this? Recently we had a bad e…Mithun Abhisheka 103 views 2 comments 0 points Most recent by User_2025-03-07-21-51-04-421 Reporting and Analytics for HCM -
Sub query in Case Statement in OTBISummary: Hello , I would like to know if we can use subquery in case statement using OTBI Reporting subject areas . For Input Value , 'Payout Date 3' , I need to get the…User_C36BE 771 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI - Combining year and quarter in a date columnSummary: Need help to show both quarter and year in a table Content (required): Hi I'm running a learning completion report and want to show quarter and year in one colu…Jane Warwick 31 views 1 comment 0 points Most recent by Jane Warwick Reporting and Analytics for HCM
-
How do you manage reporting in OTBI for courses with reassignment rules?Summary: What is the best way to report on compliance courses with reassignment rules so that you can filter down to a report which only shows the lastest record for eac… -
How to report on training with active reassignment rules & multiple records per employee?Summary: We've got a number of courses with reassignment rules set up and our employees are starting to complete the course for a second time. How do you manage reportin…
-
Import Project Budget error message-A budget Version in Submitted status already existsSummary: Hello I am trying to upload a Budget through FBDI template, however I got the following error message. Will you please let me know how the remove the budget ver…
-
'Check' Function in Data Management giving error if we use alternate hierarchy for Entity in FCCSSummary: Im using 'Check' feature in Data Management (4th fish in Import-Validate-Export-Check ) 'Check' is giving me error if I use alternate hierarchy for entity dimen…Srinivas Hindupur-Oracle 51 views 8 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
New Manager type not showing in OTBISummary: We've added a new manager type in HCM and it's currently not showing in OTBI. I've ran the Refresh Manager Hierarchy and the Transfer the Flex fields to OTBI. I…User_2025-01-31-00-25-12-234 73 views 15 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Border Display Issue in HTML Preview of ReportSummary: In HTML Preview Border doesn't show Properly. But in PDF it shows correctly. Content (required): In HTML Preview Border doesn't show Properly. But in PDF it sho…Ayush Khandelwal 31 views 1 comment 2 points Most recent by Dave Roberts_-Oracle Narrative Reporting
-
HCM Extract for Payroll ProcessHi We have requirement to get employee details who are processed in a payroll based on the given period start and period end date , so we are planning to create extract …
-
Filtering turned on for excel templateIs there a way to create an excel template so that filtering is automatically turned on when the excel report is generated? (I know you can set the 'freeze' view...so ma…
-
Can we print Continuing Education Completion Certificates when a user completes a course?Summary: Our hospital provides continuing education courses for our nurses and other professionals. We need to generate a certificate of completion in the proper format … -
Custom flow is not producing the dataSummary i have attached custom BI Report to custom flow pattern when we are running the flow output is coming as blankContent Hi Team, we have a requirement to attach BI…User_2025-02-04-07-00-18-658 36 views 4 comments 0 points Most recent by Jon Taylor Reporting and Analytics for HCM
-
OTBI to fetch vacant and filled positionsSummary: We have a requirement to create an OTBI report which will fetch position details alongwith Employees present in those positions. Besides that, we also want to f…Sovan Mishra-Oracle 1.2K views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Can we add spaces in between bar on a stacked bar graph in OTBI Analysis OutputSummary: Adding spaces in between bars on a bar graph in OTBI Content (required): On the output of a bar graph, the bars are connected with each other. Can we add extra …Vibha Pandey - Oracle 31 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI report - export to Excel limitationSummary: We have OTBI reports that will exceed the 50,000 field limitation for exporting to Excel. Content (required): Can you "schedule" an OTBI report to get around th…User_2025-01-28-20-19-02-475 71 views 2 comments 0 points Most recent by Ghanshyam M-Oracle Reporting and Analytics for ERP
-
Unable to see Values BU wise Head countSummary: unable to see Business unit wise Count while select column Head Count and Business Unit Name. Content (required): In subject Areas "Workforce Management - Worke…
-
BIP Excel output always adds additional comma to end of values when saving as csvSummary: Content (required): In BI Publisher, I need to export a simple table report to XLS (not csv) to be used as a template. However, once completed and then saved as…Marcus131975 31 views 3 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP
-
How to remove unwanted Folders on Catalog?Summary: Content (required): How to remove unwanted Folders on Catalog? Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
How to Fetch Employee level details from comp worksheet and budget details in an OTBI reportSummary: We have a requirement to fetch comp worksheet details (i.e. Manager Recommendation amount based on department VS Budget Amount allocated for the employee manage…User_EJ1U2 51 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM