Reports
Discussion List
-
FCC demo application for client demoDo we have Demo FCC application for a client demo. I imported snapshot form one of the Oracle tutorials link, but it does not have good demo ready data, inserting data t…HarryEPMUser 31 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Table that stores the file contents of an attachmentHello, We need a table that stores the base64 format of the attachment uploaded in a work order or if there is any table that stores the binary format of the file conten…
-
Highlight static variables used in word docletIs there a way to highlight static variables that are used in the word doclet. The user wants to see where are those static variables embeded in the word doclet. I am us…
-
Changed account type as Expense but still at closing balance I am getting data as Closing+OpeningI have changed the account type from Asset to Expense Account Type. How can I get the current year movement data on Closing balance without opening balance addition?KIRTI SETH 33 views 13 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
How to output a list of all reports and their folders in Production environmentSummary: We are trying to map all reports in our production environment, with their folder locations. Does anyone know of an administrative tool that might be able to ou…Rich R 1.5K views 31 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM -
How can we query the error message in BI Server's Report Job History?Summary: Error Log Report that will display the error message like in the Report Job History Content (required): Hi, We wanted to create a custom report that will output…Kristelle 424 views 17 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP
-
Audit log showing Application administration activity for a standard userSummary: Every month we send a copy of the audit log to the finance team for review and discussion - we also supply them with a script to annotate the log (so its easier…Jeremy Stubbs 32 views 5 comments 0 points Most recent by Alyssa Longo Financial Consolidation and Close -
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 40 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…Vishal Purohit 2 views 0 comments 0 points Started by Vishal Purohit Reporting and Analytics for HCM -
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 343 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 86 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 88 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 76 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 22 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 14 views 5 comments 0 points Most recent by Abhishek Premchandra BI Publisher Learning Center
-
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 125 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