Reports
Discussion List
-
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 50 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 38 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 23 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 -
CASE statement with IFSummary Need help with a CASE statement where it displays element input value if they have the element, else shows nullContent Hello, We have element set up like below t…User_2025-02-04-15-06-22-759 56 views 6 comments 0 points Most recent by User_2025-02-04-15-06-22-759 Reporting and Analytics for HCM -
Reporting on Rejected DORSummary Requirement to report on rejected DORContent Some of the DORs in our system pass through the Approval cycle. I have checked "Workforce Management - Documents of …User_2025-02-05-23-02-10-916 35 views 6 comments 1 point Most recent by Aliasgar Khambhaty-Oracle Reporting and Analytics for HCM -
Customization in Seeded Line Manager Dashboard for Absence pageContent Hi Experts, In the Seeded Line Manager Dashboard, the Absence page has an Absence for Today and Tomorrow analysis which displays absentees for Today and Tomorrow…Jaswant Prajapati 33 views 1 comment 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Need Year-End Tax reporting for PayrollContent As we approach year-end down the line, I was looking if we have any year-end tax reports available with anyone which can be shared on HCM report sharing center. …PankajRK 27 views 1 comment 0 points Most recent by Jim Kirkpatrick-Oracle Reporting and Analytics for HCM -
Data Export from PBCSSummary PBCS Data Export using a groovy business ruleContent Hello Friends - Hope all are doing well and staying safe!! I need some help on Data Export in PBCS. I have w… -
Error tables in Oracle for Unit of Measure Intraclass Conversion FSM importSummary I am trying to fetch the errors that occured while importing Unit of Measure Intraclass Conversion using FSMContent Hi, I am searching for tables where I can fin… -
NI Category Letter in OTBISummary NI Category Letter in OTBIContent I am looking for NI Category Letter in the OTBI subject area 'Payroll - Calculation Card Real Time'. Could anyone please confir…Jay A 44 views 3 comments 0 points Most recent by Henry Winsor-Oracle Reporting and Analytics for HCM -
Supplier Spend ReportSummary Supplier Spend ReportContent Hi, As stated, we would like to ask for your help if there is a standard supplier spend report in Oracle. What we need is the actual…Gene Garcia 664 views 2 comments 0 points Most recent by Kent Sarmiento Reporting and Analytics for ERP -
how we can use gif in flash template through bi publisherSummary how we can use gif in flash template through bi publisherContent how we can use gif in flash template through bi publisherSidhartha Wadhwa 32 views 1 comment 1 point Most recent by Karina Ogata Reporting and Analytics for HCM -
List of all the recurring scheduled processes?Summary How to get a list of all the recurring scheduled processes?Content How to get a list of all the recurring scheduled processes?Yasmin Kennedy 60 views 3 comments 0 points Most recent by SankarBalu Reporting and Analytics for ERP -
Unable to open/view the xdmz format ( data model) and xdoz format ( report ) uploaded in Report CataSummary Unable to open/view the xdmz format ( data model) and xdoz format ( report ) uploaded in Report Catalog pageContent Hi Team, I'm new to reporting area and need s…User_2025-02-10-05-51-05-868 50 views 3 comments 1 point Most recent by User_2025-01-30-00-54-17-530 Reporting and Analytics for ERP -
Dashboard promptsSummary Creating a dashboard prompt using a formula based columnContent Hi We are using below formula to show the actual "Start date" of employees in the reports. IFNULL…Ridma Karunanathan 41 views 2 comments 1 point Most recent by Ridma Karunanathan Reporting and Analytics for HCM -
OTBI reports sent via Email are causing performance issuesSummary OTBIContent Hi. I have noticed that most of the OTBI reports I schedule using the agent and send via Email are causing lagging issues when the user tries to open… -
BPM tablesSummary BPM tablesContent Team, BPM tables (FND_BPM_TASK_VL and FND_BPM_TASK_ASSIGNEE) have the initiated_by column as null or blank for few transaction? Could you help …acmhari 219 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Preferred Browser for OracleSummary I would like to know what is the preferred browser to use for Oracle applications. Can you provide documentations?User_2025-02-06-07-21-22-662 31 views 2 comments 1 point Most recent by Harish Vummidi Reporting and Analytics for HCM -
Report on selected bank accountSummary I need to report on the selected/default bank account where a colleague may have more than one in the systemContent Hello, I need to report on the selected/defau…User_2025-01-28-05-32-59-092 62 views 5 comments 1 point Most recent by Gopikrishna Nerella Reporting and Analytics for ERP -
Day Difference excluding weekends in OTBISummary Day Difference excluding weekends in OTBI From Workforce Management - Absence Real TimeContent Hi All, I need to calulate the difference between two dates - Abse…Dharmendra Jha 41 views 6 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM