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 41 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 53 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 33 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.7K 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 446 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 33 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.3K 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 72 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 4 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 132 views 4 comments 0 points Most recent by Nicolas-Vahman 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 92 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
-
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 14 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 24 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 16 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 '…