Reports
Discussion List
-
can we group the output using any templateSummary my report is displaying 300 rows but user needs to display the output in grouping ,example each 100 rows as one group ,is it possible to using templateContent Hi…User_VR8E0 20 views 1 comment 1 point Most recent by Pradeep Sharma-14802 Reporting and Analytics for HCM -
REST to Get List of FR ReportsSummary Is there a way to "get" all FR Reports using REST?Content Is there a way to "get" all FR Reports using REST? I did a couple documentation searches but could only… -
Supplemental data ReportSummary Is there any way to generate report based on Supplemental dataContent Hi Is there anyway in FCCS to generate report based on Supplemental data in Report section.…Jai Prakash 37 views 2 comments 0 points Most recent by Jai Prakash Financial Consolidation and Close -
oracle.xdo.dataengine.datasource.plugin.DataAccessException: java.net.SocketTimeoutException: Read tContent Hi Experts, I have Anniversary BI Report using OTBI analysis. Which has following filter criteria CONCAT(CONCAT (CAST(MONTHNAME("Workforce Management - Person Re…User_2025-02-07-19-03-14-525 473 views 2 comments 0 points Most recent by User_2025-02-07-19-03-14-525 Reporting and Analytics for HCM -
Service error while previewing the reportContent I am trying to run a report which has a prompt for the column dimension along with Zoom option enabled and function used to generate the row dimension. Once prev…
-
How to validate Project Cost import from PayablesSummary How to validate Project Cost import from PayablesContent How do I validate the total cost imported from Payables into Project Cost. I am unable to find a report …
-
OTBI vs BIP filtering clarificationSummary HOw OTBI handles filtering verse BIPContent Hi, Seeking clarification/advice on the following scenario. We have an OTBI report that pulls in a person's work exte…Denise Izzi 30 views 12 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Dashboards graph PropertiesContent Hello! I added some pie charts in a Dashboard but they are displaying misaligned even if they have the same graph properties. In attachment a screen showing the …Chiara Arcidiacono 30 views 4 comments 1 point Most recent by Anil Kola-Oracle Reporting and Analytics for HCM -
oracle.xdo.dataengine.datasource.plugin.DataAccessException: java.net.SocketTimeoutException: Read tContent Hi Experts, I have Anniversary BI Report using OTBI analysis. Which has following filter criteria CONCAT(CONCAT (CAST(MONTHNAME("Workforce Management - Person Re…User_2025-02-07-19-03-14-525 32 views 1 comment 0 points Most recent by Anil Kola-Oracle Reporting and Analytics for HCM
-
Page Break of Columns in MR vs Embed ContentContent We have a set of reports which have many columns which are populated dynamically. Looking for suggestions to handle the page break of the columns. 1. In MR, PDF …Sandeep Hardikar N S 36 views 7 comments 0 points Most recent by Sandeep Hardikar N S Narrative Reporting -
How to define Chldren of in FR reportSummary Define Children of in FR report by using functionContent Hi Experts I want to know how to define Children of (....) in FR report by using function i tried the de…Karthikeyan 29 views 1 comment 0 points Most recent by Khushbu Premlani Profitability and Cost Management
-
Custom Columns with field from different Subject AreasContent Hello, I am working on a report that has 2 subject areas (SA). I am trying to include a column with a formula (CASE WHEN statement) using fields from the 2 subje…User_2025-02-05-06-26-19-951 57 views 5 comments 1 point Most recent by user5070067 Reporting and Analytics for HCM
-
Is there a way in which we can schedule reports in Narrative reportingContent Bursting option is available but do we have a way in which we can schedule reports (MR) in Narrative Reporting Version 21.02.85
-
Effective End Date not pulling in element reportSummary Effective End Date not pulling when reporting on element entriesContent Hi, I'm using the Payroll - Element Entries Real Time subject area to show pay element in…
-
Analysis failing with error: Exceeded configured maximum number of allowed output prompts, sections,Content Hello Experts, I had built a dashboard using the Absence Calendar Details Real Time subject area having two sections - Summary and Detail Analysis reports. I had…Akash Kiran Jana 27 views 4 comments 0 points Most recent by Akash Kiran Jana Reporting and Analytics for HCM
-
Infolet Dashboard to be Printed as a Page for Management ReportingSummary Infolet Dashboard to be Printed as a Page for Management ReportingContent We have built Risk Management Infolet section and Client wants to download this as a re…ArunMajumdar 25 views 3 comments 3 points Most recent by SantoshKumarBhairi Reporting and Analytics for ERP -
Financial Reporting Studio Desktop - DecommissionSummary Transition from Desktop to Web toolContent Hi, We are using Financial Reporting Studio Desktop tool since 5 years ago for development of ERP Financial Reports, a…Patricia Gonzalez 48 views 9 comments 4 points Most recent by Rich Merkel Reporting and Analytics for ERP -
Proper Case Function in OTBIContent Is there a function in OTBI that transforms character strings from their current state into PROPER case format? For example: 'JOHN SMITH' or 'John SMITH' to 'Joh…Dustin Dominic 41 views 2 comments 2 points Most recent by Dustin Dominic Reporting and Analytics for HCM -
Extract Cost Center from "Code Combination Description" field - (Procurement - Spend Real Time) subjSummary Extract Cost Center from "Code Combination Descpription" fieldContent I am using "Code Combination Description" field as one of my select columns from (Procureme…UjasB 252 views 5 comments 0 points Most recent by Anders W. Langholm Reporting and Analytics for ERP
-
Dynamic printing of column labels in OTBI or BI PublisherSummary Dynamic printing of column labels in OTBI or BI PublisherContent Hi All Kindly share your experiences on how you have been dynamically creating reports with titl…User_2025-02-08-03-05-58-849 18 views 1 comment 2 points Most recent by User_VLBBP Reporting and Analytics for HCM
-
Best practice for Developing Custom BIP reports and securing them in ERPSummary Looking for best practices for custom BIP reports for ERP which can be secured by Role and Data Access Sets similar to UIContent Hi, Our client has complex enter…Subhash Valiveti 395 views 15 comments 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for ERP -
Org Tree Flatenned TablesSummary Org Tree Flatenned TablesContent Hi All, Can someone share the SQL if available handy to get Org tree (Bottom -> Up) details using Flatenned tables in HCM? Regar…
-
Tables to query files imported to ERPSummary We want to create a report that list the files imported to the ERP from external systems for reconciliation purposes.Content Hello evryone, Anyone can hep me to …User_B9AX9 70 views 1 comment 0 points Most recent by Christian Guidibi Reporting and Analytics for ERP
-
Transaction Query exampleSummary example of a GL Transaction query flexible to a range of parametersContent Seeking an Oracle Cloud example of a GL transaction query that returns line item detai…User_2025-02-11-03-09-13-126 351 views 6 comments 2 points Most recent by Sahil_Makhiza Reporting and Analytics for ERP
-
Need to generate audit report for Person and Assignment EFFContent I need to be able to run the 'Generate audit Report' Scheduled Process for changes made to both an Assignment and Person EFF. I have turned it on and managed to …Jasmin S 53 views 18 comments 1 point Most recent by Jeff Hare CPA CISA CIA Reporting and Analytics for HCM
-
Model Profile - Employee Level - FUSION OTBISummary Model Profile - Employee Level - FUSION OTBIContent Hello We have the attached Model Profile Information report that details all the Role Profiles, as well as th…Andrew Braid 116 views 4 comments 2 points Most recent by Aman Malik Reporting and Analytics for HCM -
Documents of Records data in ReportSummary Need to open DOR (Documents of Records) from BIP reportContent Hi All, We have a requirement to display DOR (Documents of Records) data in BIP report and need to…
-
OTBI Report that shows the element details field "Description"Summary OTBI Report that shows the element details field "Description"Content I am trying to build a report where I can pull in the field 'Description' on an element. Fo…