Reports
Discussion List
-
How to find the difference between two date attributes in eText templateSummary: We need to find out the difference between two dates and add 1 to the result in eText template. Content (required): We need to find out the difference between t…Meenakshi K 1.2K views 9 comments 0 points Most recent by Ruma Bhatnagar-Oracle Reporting and Analytics for HCM -
Formatting not working in In Line Grid Notes in report previewSummary: Formatting not working in In Line Grid Notes in report like bold, italics, font color change etc. when previewing reports in HTML Content (please ensure you mas… -
HCM Custom Extract Guide for Payroll ReportsSummary Sample extract with modularized UEs for customized payroll reportsContent Change Notes Date Version Change Reference 16-May-2018 v1 First Version 18-Sep-2018 v1.…Jianzhong Tian 1.6K views 7 comments 7 points Most recent by Tia Bly Reporting and Analytics for HCM -
Could not establish connection. java.net.ConnectException: Connection timed outSummary: Could not establish connection. java.net.ConnectException: Connection timed out Content (please ensure you mask any confidential information): We are trying to …Sai Krisna 31 views 5 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
per_pos_tree_node_rf and PER_POS_TREE_NODE_RF tables empty, though it is visible from frontendSummary: I am developing an HCM Extract to send Position Structure data external source. One of the required fields is the Parent Position Code for each position. When n… -
OTBI Dashboard Reverted to Old UISummary: Hi team, We have a dashboard that has reverted to an older UI in both Test and Production environments. However, the same dashboard in DEV looks fine and retain…Josel Pleyto 121 views 4 comments 0 points Most recent by Nicolas-Vahman Reporting and Analytics for HCM
-
SQL Query for timecard approval to BPM workflowObjective : SQL Query to get Approver Name, Approval Date and Status of Timecards Imported in Project Cost Issue : I am unable to find a link between HWM_TM_REC and Work…Palash Kumar Singh 324 views 4 comments 0 points Most recent by Gangadhara S Ariga Reporting and Analytics for HCM
-
Add Business Unit as an additional parameter in the Run Gross-to-Net ReportWe have a requirement to include Business Unit as an additional parameter in the Run Gross-to-Net Report (Gross to Net Summary Archive) so that the report can be generat…
-
Annualized Full Time Salary not in Compensation TablesSummary: Looking for a workaround for CMP_SALARY table not reflecting the actual salary information ()Doc ID 2403581.1) Content (please ensure you mask any confidential …Joe Dorrian 81 views 5 comments 1 point Most recent by Rajesh Jupudi -Oracle Reporting and Analytics for HCM -
Table name of language Level in skill and qualification sectionSummary: Does anyone know the table name of the language Level table name in the skill and qualification section? Currently, I'm using attached BI query to fetch the oth…Saher 81 views 3 comments 0 points Most recent by YashaswaniSrivastava Reporting and Analytics for HCM
-
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 71 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 21 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 11 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 11 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 407 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