Reports
Discussion List
-
How to Generate a Unique Reference Number for Each Report in Oracle Fusion HCMHello Oracle Community, We have a requirement to generate a unique reference number for each report generated in Oracle Fusion HCM, specifically for documents like lette…Harish Vummidi 73 views 6 comments 1 point Most recent by User_N5HC6 Reporting and Analytics for HCM -
Is it possible to report on Workforce Compensation Change Statement Volumes executed by managers?Summary: We have our Compensation Change statements configured to Printed and delivered by managers, we would like to monitor and report on how many managers are accessi…Adam_Cantwell 11 views 3 comments 0 points Most recent by Adam_Cantwell Reporting and Analytics for HCM -
Traffic light indicators or variance indicators in reportsGreetings! Is it possible to customise reports using conditional formatting with traffic light indicators 🔴🟡🟢or variance indicators ▲🔺▼ with colours and these colour…Amara Sai Sandeep 26 views 2 comments 0 points Most recent by Dave Roberts_-Oracle Financial Consolidation and Close
-
Reduce size of pie chart to embed in report packageI am creating a Pie chart which will be eventually embedded into a word report package. Is there a way I can reduce the size of each block in the pie chart but keep the …
-
Report data grid: Conditional Year member selection based on user's Period POV selectionHi everyone, I am creating our half-year and full-year financial statements as a single Narrative report / report package and am trying to minimise the user's POV and pr…
-
In OM can we change data model report layout completely for standard Sales Order Report to view PDFIn OM, we veiw PDF as follows: ACTIONS—>CREATE DOCUMENT—>VIEW Behind this there is a standard Sales Order Report Layout and DM with XML /Supply Chain Management/Order Ma…essdee 17 views 5 comments 0 points Most recent by Abhishek Premchandra BI Publisher Learning Center
-
How to send attachment from content server to email through BI bursting in fusionSummary: Let’s say we have uploaded a PDF attachment in the contract, and the uploaded attachment gets saved in the content server. Now, we want to send this attachment …
-
Dynamic Data field on Interactive DashboardSummary: Dynamic Data field on Interactive Dashboard Content (please ensure you mask any confidential information): I am building a dashboard (in online template builder…
-
Automatically update report package next yearWhen we create a report package for a year. What is the best approach to keep it dynamic so that it will work for next year too. The report package has management report…
-
Gaps between multiple grid in MR reportI have created multiple grids for the table due to encountering limit errors. However, this approach has resulted in large blank spaces appearing between the grids. I ha…
-
Changes to expense approval template does not reflect after 24hoursHi all, We have a requirement to modify expense approval template to add the account number to show up on the email notifications. To achieve this, I have modified the '…
-
Combining Oracle HCM Source and data from Microsoft Excel file sourceSummary: Combining Oracle HCM Source and data from Microsoft Excel file source Content (required): We have created a report where we have defined a data model with a joi…Vasanthakumar Ravi 121 views 8 comments 1 point Most recent by ViswanadhK Reporting and Analytics for HCM -
How to Add a Table of Contents (TOC) to a Book in FCCSSummary: I have created a Book in FCCS that consists of multiple books and reports. I would like to include a Table of Contents (TOC) document as part of this book. Whil…Athithya.N 21 views 3 comments 0 points Most recent by Dave Roberts_-Oracle Financial Consolidation and Close -
Pay Period End date Retroactive CostingFor reporting on payroll costing, how are people populating pay period start and end date for payroll actions Retroactive Costing, Estimate Costing or Balance adjustment…Sean-B-01 21 views 9 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
how to pass dynamically the flow name and instance Id from HCM Extract to SFP FileSummary: In an HCM EXTRACT, We enabled SFTP bursting need to save the file name with flow instance name and flow instance Id dynamically in SFTP server when we ran the e…
-
HDL Error ReportingSummary HDL Error ReportingContent Hi Experts, Does anyone have user friendly error reports for HDL Loads. Because PBL is deprecated, we are looking for a good reporting…
-
Only access seeded reports and subject areas in OTBISummary: Client wants a role to allow them to access seeded reports and OTBI subject areas but not any fusion tasks. Is it possible? Can you please guide us?Amit Dey 12 views 2 comments 0 points Most recent by Jehosheba Amruthaluri Reporting and Analytics for ERP
-
Base-level account under TRCS_CurrentAddtlManualTotal not calculating correct amountHello Everyone, We are observing an issue in Oracle Tax Reporting Cloud Service where we entered amounts into base-level accounts under the "TRCS_CurrentAddtlManualTotal…
-
Working report stopped and throwing an error ORA-01722: invalid numberSummary: I was able to use a custom BI Report a week ago. But it stopped working and throwing an error "ORA-01722: invalid number" when running. I am not sure what is ca…Ankurzen 405 views 7 comments 0 points Most recent by Ashok Pavithran Reporting and Analytics for ERP
-
Use of dynamic URL to run the report on Home page linkWe have created a BIP report and used that URL to create a page link on the Fusion Home page. At present, configured using Static URL on the link and it works fine. The …Vijay Ramani VJ 2.1K views 12 comments 0 points Most recent by Lisa Carter Reporting and Analytics for HCM -
how to add 2 different fonts in same sentence in cell in report Grid ?Summary: how to add 2 different fonts in same sentence in cell in report Grid like we do in Excel? Content (please ensure you mask any confidential information): Version… -
Using Formulas to Reference a Grid in different Report in narrative reportingSummary: I created a book containing multiple reports. On the cover page/table of contents page, i would like to reference the period (eg. May 2024) for which the book i…
-
Unable to perform bursting because the specified POV members are not found in the bursting query.Summary: We are trying to execute a Bursting Definition but we are getting the error message; Unable to perform bursting because the specified POV members are not found …
-
How to convert numbering format from Indian currency to Dutch (10.13 t0 10,13) to OTBI Report.Summary How to convert numbering format from Indian currency to Dutch (Amount 10.13 to 10,13) to OTBI Report.Content Hi All, We have a requirement to convert amount/curr…User_2025-02-10-16-28-01-402 39 views 7 comments 0 points Most recent by Anil Sangwan Reporting and Analytics for HCM -
Negative number not coming below zero line in Bar ChartSummary: In Bar Chart, customer wants negative number should look as below i.e. below zero line Client Version: Content (please ensure you mask any confidential informat…
-
OTBI - Calculate age in years and monthsSummary How to calculate the age in years and months?Content Hi, In OTBI I want to create a column which present the full age of the employee, for example 43.12 (means 4…
-
not able to view future dated hires in my reportSummary: not able to view future dated hires in my report. I added the prefix SET VARIABLE PARAM_EFFECTIVE_DATE='2050-12-31' but still not showing Content (please ensure…Consultant1 11 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Excel report is not printing the parameter when used with burstingSummary: Excel report is not printing the parameter when used with bursting Content (please ensure you mask any confidential information): Hello All, I have an Excel tem…Pritam Das 21 views 5 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
Audit Reports History Retention for Work Definitions – How many days?Hi all, I’m trying to understand the retention period for audit reports history, specifically regarding work definitions / records. I know that audit history is not kept…Tiago Duarte 21 views 1 comment 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP