Reports
Discussion List
-
Inputs Needed for BIP Folder Setup.Summary: Inputs Needed for BIP Folder Setup. Content (please ensure you mask any confidential information): By mistake, we removed My Folders in the lower environment. W… -
In reports and analytics, from which table I can get engineering change order approver's name?Trying to get this info to build a report for the customer. Table EGO_CHANGE_ACTIONS_B is supposed to show the change events, but independently of the event, it always g…Alberto Redondo 21 views 4 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP
-
Issue in Salary Certificate DORSummary: Issue in Salary Certificate DOR Content (required): Hi All, We are facing the issue in salary certificate DOR. Salary certificate is working fine in draft versi…Venkatesan 41 views 3 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Has anyone created a costing by job report using the Payroll Run Costing Real TIme subject area?I need a report to show costing by job for last year. I've written one but can only get it to work for one person at a time, it does not produce results when I try to ru…
-
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 32 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 31 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.6K 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 422 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 31 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 44 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 358 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 83 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 94 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
-
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…