Reports
Discussion List
-
Connection to external data sources is not supported in Fusion and will be deprecated in a future reSummary Connection to external data sources is not supported in Fusion and will be deprecated in a future release.Content Hi Team, I am exploring the option of creating …MandeepKGupta 52 views 1 comment 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting and Analytics for HCM -
Unique Records via BIP for tables with Object Version NumberSummary I'm looking for a way to obtain the latest information for a given record via a BIP job, for tables with an Object_Version_Number columnContent Hi, As per the su… -
Is it possible to add a calculated SQL-based column in an OTBI Analysis?Summary Need to return a segment value name in a column from an OTBI analysis using a SQL QueryContent Hello, Our Financial users have created several OTBI reports based… -
User with View Role not able to view data in HFR Reports & ChartsContent Hello Experts, We have a user with the "User" role and View Role for 1 HFR report (including charts). He is able to open the report but not able to view data in … -
OBIEE BIP Report LogSummary Where to find report log which shows SQL that's generated by report while report executionContent Hello Everyone, I'm trying to find log of a BIP report which I … -
How to add OR condition in the input of the OTBI analysisSummary How to add OR condition in the input of the OTBI analysisContent There are suppliers whom we create only invoices and there are suppliers whom we create only PO …Manish Kumar Sinha 39 views 7 comments 2 points Most recent by Sahil_Makhiza Reporting and Analytics for ERP -
How to get count of child nodes in ETEXT templateSummary How to get count of child nodes in ETEXT templateContent Hi experts, how can i get the count of child nodes in etext template, ex : in attached xml i want to dis…Pradvin Prabhakar 137 views 6 comments 1 point Most recent by Pradvin Prabhakar Reporting and Analytics for HCM -
Custom ESS Parameter with TextBox and SearchSummary How can we have a Custom ESS Job with parameter as Textfield with Search option.Content One of the standard ESS Job has a parmeter which is a TextBox with a Sear…Balachander G-Oracle 69 views 2 comments 1 point Most recent by EdWho Reporting and Analytics for ERP -
Need a report for AOR with scope of responsibility ?Summary Need a report for AOR with scope of responsibility ?Content Hi Team, Need a report for AOR with scope of responsibility ? I need to create a report for AOR but n… -
Cannot view report with Person NumberContent Hi, I am using the subject area Workforce Management - Worker Assignment Real Time and when the report is created using Person Number from Worker folder could no…Mohammed Rafi 26 views 2 comments 3 points Most recent by Mohammed Rafi Reporting and Analytics for HCM -
AddIn is disable in VDI toolContent Hello, Can you help me out with this enable to AddIn in word in VDI tool. Thanks, Nupur Thakar Version VDI 5.4.3Nupur Thakar 15 views 0 comments 0 points Most recent by Nupur Thakar Reporting and Analytics for ERP -
Seeded Lookups with their values in HCMSummary Need a list of lookups with their valuesContent Hello, I need a seeded list of lookups types with their values, I was not able to find it in any subject area so …Akanksha Jain 72 views 3 comments 2 points Most recent by Akanksha Jain Reporting and Analytics for HCM -
oracle.xdo.servlet.data.DataException: org.xml.sax.SAXParseException; lineNumber: 600; columnNumber:Summary oracle.xdo.servlet.data.DataException: org.xml.sax.SAXParseException; lineNumber: 600; columnNumber: 145; : XML-20250: (Fatal Error) Missing entity 'bull'.Conten… -
Amendment need to an existing reportSummary Multiple NationalitiesContent Hi, How can I modify the attached report so that only the primary nationality is displayed? For context, there are many employees t…User_2025-02-05-22-44-35-842 31 views 1 comment 0 points Most recent by Caroline Gladwin-Oracle Reporting and Analytics for HCM -
Prior Salary not showing in reportSummary Prior salary not showingContent Hi, The report attached should show all prior salaries and current salaries - one of our users has said that the Prior salary is …User_2025-02-05-22-44-35-842 38 views 6 comments 0 points Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM -
SQL Cash Advance Report from ExpensesSummary SQL Cash Advance Report from ExpensesContent Hello I was wondering if you can share with me any SQL regarding open Cash Advances from Expenses. Thanks for your h…gabriel kinovisques-163562 49 views 2 comments 1 point Most recent by Balachander G-Oracle Reporting and Analytics for ERP -
Ancestor Member Pages Position in FR BooksSummary Ancestor Member Pages Position in FR BooksContent In Our FR books, Ancestor Member Pages used to be first in the sequence and then level 0 member pages in the bo… -
Join Expenses – Employees Expense Overview Real time and Workforce Management – Worker Assignment ReContent Hello Everyone, I am trying to join below 2 subject areas to get the default expense concatenated segments along with other employment-related information. Expen…Prateek Yadav 36 views 7 comments 0 points Most recent by Dawn Cawston - CPS Reporting and Analytics for HCM -
Dynamic List of Values for ESS JobSummary Dynamic List of Values for ESS JobContent Hi, How to create a 'Dynamic List of Values for ESS Job' , I cant use the lookup and table type valueset is not working…Soumya Prakash Parhi 140 views 12 comments 3 points Most recent by RaviThejaDarbha Reporting and Analytics for ERP
-
Generate SAFT Data Extract Norway is not populating with any dataSummary Generate SAFT Data Extract Norway is not populating with any dataContent The ESS job 'Generate SAFT Data Extract' is not populating with any data. Parameters scr…User_2025-02-05-22-11-22-331 58 views 2 comments 0 points Most recent by User_2025-02-05-22-11-22-331 Reporting and Analytics for ERP -
EL expression to restrict springboard group to a specific hierarchySummary EL expression to restrict springboard group to a specific hierarchyContent We are trying to let users have access to dashboards directly from the springboard. I …User_2025-02-10-08-27-16-805 36 views 5 comments 0 points Most recent by Vis Perera Reporting and Analytics for HCM -
OBIEE - Pivot Table add calculated columnSummary OBIEE - Pivot Table add calculated columnContent Hi, I have built a Pivot table Analysis in OBIEE and would like to add a addition column beside the Grand Total …Nizar Kassam 46 views 1 comment 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Adding days to the Date prompt in OTBISummary Adding days to the Date prompt in OTBIContent Hi Team, I have one requirement to add 6 days to the prompt date and fetch the value based on the new value. +6 or …SM-Oracle 161 views 1 comment 0 points Most recent by Mallikarjuna Maganti Reporting and Analytics for HCM -
How to enable export functionality in ReportsSummary How to enable export functionality in ReportsContent Hello, We created reports using OTBI and have put them under 'My Dashboards' but we are wondering why we can…Tony Puentes 42 views 3 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM -
Performance tile to show a 0 instead of no resultsContent Is it possible for a performance tile to show as a '0' if there are null counts instead of it showing a message saying 'no results'User_2025-02-06-11-18-47-896 45 views 7 comments 1 point Most recent by Rob F Reporting and Analytics for HCM -
Want to extract Data from Report & analytics by writing SQL QuerySummary Want to extract Data from Report & analytics by writing SQL QueryContent I Want to extract Data from Report & analytics by writing SQL Query. Previously i use ex… -
Report no longer workingSummary This report last worked before the April upgrade to 20BContent Hi, This report (see attached XML) no longer works - can anyone check why? There are no filters or…User_2025-02-05-22-44-35-842 25 views 5 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Performance - "My Organization" replacement report ideasContent With the transition from Classic UI to Responsive UX the "My Organization" tab in Performance is set to be deprecated at some point. We have not seen this as bei…Kayla Malecki 33 views 2 comments 0 points Most recent by Andrew Gillibrand-Oracle Reporting and Analytics for HCM