Reports
Discussion List
-
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 -
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
-
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
-
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…
-
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
-
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 -
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
-
How do I retain drill-down reporting with a null value in a data setSummary: Hello. I have a dashboard which has several pies on it that draw data from talent review categories. I need to enable drill-down person reports from the pies fo…User_2025-02-05-22-55-58-511 31 views 2 comments 0 points Most recent by User_2025-02-05-22-55-58-511 Reporting and Analytics for HCM
-
(QUERY) Fix null value isn't show in csv outputSummary: When export as xls or view online it show header with all of null value, but header is disappear in csv output Content (required): Hi, I wanted to fix the data … -
Need to print sum of Position FTEs by Business Units in OTBISummary:We have a requirement in OTBI to fetch business unit name and Position FTEs. But we have to print the sum of FTEs grouping it by each business unit. We are using…Sovan Mishra-Oracle 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Attendance Summary ReportSummary: Does anyone have a report where you can see a summary of absences by plan type for an employee? Would like to audit and keep track of usage against balances. Al…Tristan Aquino 41 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Custom Balance ReportHi We have a requirement to display custom balance details in the report along with some other employee/payroll details , so I would like know whether to go with BIP or …
-
Assignment Expense InformationSummary Sourcing/Auditing the assignment Expense informationContent Hello, We're trying to audit the Expenses Information stored on the on the Manage Employment screen w… -
Do analyses run with Agents log to "OTBI Usage Real Time" subject area?Summary: Do analyses run with Agents log to "OTBI Usage Real Time" subject area? Content (required): Version (include the version you are using, if applicable): Code Sni…Andrew_Schmitz 11 views 2 comments 0 points Most recent by Ghanshyam M-Oracle Reporting and Analytics for ERP -
Folder/Report Last Modified DateHI Team, After a refresh/upgrade/patch getting applied does the folder last modified date change for each folder. We could see some folders have different last modified …Swapnil Kashid 172 views 3 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP -
Migrating Reports between applicationsSummary: Hi all, I am trying to migrate reports between the Oracle EPM applications to use the report as a basis to build an other report but so far this does not seem t…
-
Can we report on screening questions responses?Summary: Is there a possibility to report on screening questions in OR? I am not able to find them in the subject area. i.e. the yes or no responses Content (required): …Mitch_123456 11 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Newly Created Attribute Dimension not showing in Reporting StudioSummary: Newly Created Attribute Dimension not showing in Reporting Studio Content (required): Hi All- I have created a new attribute dimension in out application for al…Amit Agarwal-158816 21 views 4 comments 0 points Most recent by Amit Agarwal-158816 Profitability and Cost Management -
Notes Columns appear to have no boundaries when placed side by sideSummary: Notes Columns appear to have no boundaries when placed side by side unless there is different type of column separating them or the Note text spreads to the edg… -
Use of MAX function to get current Tax CodeSummary: I need to tweak a repot which shows all the tax codes under one employee with dates against them, however I just need the current tax code that is applied. Cont…
-
Reporting transaction history in HCMContent Hi all, We are currently looking for a way to report transaction history specifically for terminations. We've found what were using shows the most recent update …User_2025-02-05-20-24-10-848 63 views 4 comments 0 points Most recent by User_2025-02-11-05-19-35-410 Reporting and Analytics for HCM
-
which table in fusion hcm tracks changes to user status from Active to inactive and vice-vercaSummary: which table in fusion hcm tracks changes to user status from Active to inactive and vice-verca Content (required): which table in fusion hcm tracks changes to u… -
Min and Max columns on Assignment Effective Dates are blank in OTBI analysisSummary: 'Latest Assignment Start Date', 'Earliest Assignment End Date' columns showed data while building the report. After adding more columns and filter condition the…Vinay Hardas 271 views 9 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to edit annotation in FRS reports?Summary: Content (required): I created an FRS report, I add a column to display annotations. I have to users with the sames access, but only one can modify the annotatio…