Reports
Discussion List
-
Need a query to derive current cost, Netbook value in Oracle Fusion Fixed assets module with the peContent Hello all, I need a query that gives me the current cost and the netbook value for a specific asset within a period range. Need a parameter too to run the query.…Sushan Peiris 2K views 7 comments 3 points Most recent by Sushan Peiris Reporting and Analytics for ERP -
Base Salary and Payroll elements tablesContent Hello experts, I need to extract by SQL compensation data for a specific employee. Do you know in which table I can find the following information: -Base Salary …Valerio Curzi 44 views 5 comments 1 point Most recent by Dharmendra Shukla Reporting and Analytics for HCM -
Need query to pull finalised or processed pay period namesSummary Need query to pull finalised or processed pay period namesContent Need query to pull only finalised or processed pay period details?ViswanathaReddyKetireddy 32 views 2 comments 0 points Most recent by ViswanathaReddyKetireddy Reporting and Analytics for HCM -
Hierarchies within EDM vs Reporting NeedsSummary How many hierarchies maintained within EDM drive your reports?Content My organization has a large number of reporting needs, each with unique reporting requireme… -
call Dashboard from HCM page -how to keep BIP paramsContent MY BIP report has two params (one dependent on another). I need to create a dashboard and display the dashboard under 'My Client Groups'. I did it all. However, …
-
Last Update Date in OTBIContent Hi, Can someone help me to find where to get Last Update Date for "About This Record" in Person tab for "Extra Information". Flow will be go to Person=> Extra In…User_2025-02-07-19-03-14-525 42 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
What is recommended approach - Financial Statement reports - with FRS tool in Oracle GL or with EPMSummary What is recommended approach - Financial Statement reports - with FRS tool in Oracle GL or with EPM toolContent Looking for some expert advice about the best app…
-
Service Status legend - What does Green Indicate?Content Hi All, I was curious if anyone had any insight on what the service status green "Service up" means? Shouldn't we expect each day to be yellow (Planned Maintenan…Preston Oakes 17 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Can we accommodate wider tables in landscape format by rotating the table 90 degreeContent To accommodate the wider embedded grids in the doclet, can we rotate the grid to 90 degree. If yes, let me know how to work on it. -
Current Performance Task by Org TreeContent Hello, I feel like this is a tough one to figure out. I have an analysis where I isolate the current performance task on a performance document. I'm trying to en…Rob F 22 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
New hire report - Need to remove Global Transfers with changes afterwardsContent Hello, We are creating a new hire report that would show employees with a work relationship start date within the past year but we do not want to include global …Shanna Oppenheim 43 views 10 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
-
BI Publisher - tracking of an email notificationSummary Schedule Report JobContent Hi All, One of users has complained about some of their scheduled processes not sending email notification even though she filled up t…Alvaro Couto 79 views 6 comments 0 points Most recent by Skolli-Oracle Reporting and Analytics for HCM -
Log for emails sent through scheduled Reports jobContent Hi, We have scheduled a report job. So some are going under failed. Can i know how to fetch log daily how many reports are successfully sent and how many were fa…User_2025-02-10-17-13-07-021 40 views 1 comment 0 points Most recent by Skolli-Oracle Reporting and Analytics for HCM
-
Convert OTBI analysis / report to BI Publisher reportSummary Convert OTBI analysis / report to BI Publisher reportContent At our company the OTBI reports are running slow and long. I am tasked to convert OTBI analysis / re…User_5F4G3 544 views 10 comments 0 points Most recent by User_2025-02-11-18-46-39-346 Reporting and Analytics for ERP
-
HR Help Desk report availabilitySummary Looking for recommendations and examples of reports for managing HR Help DeskContent Does anyone have any tips or suggestions for creating reports for HR Help De…Len M. 39 views 10 comments 0 points Most recent by User_2025-02-10-08-27-16-805 Reporting and Analytics for HCM
-
How to calculate next Anniversary date in OTBISummary How to calculate next Anniversary date in OTBIContent Hi All, How to calculate next Anniversary date based on the employee hire date? Example: Number Hire date N…Reddykrishna Chidella-Oracle 239 views 3 comments 0 points Most recent by Reddykrishna Chidella-Oracle Reporting and Analytics for HCM -
Make a REST call from an ESS Job - Ideas needed!Summary Make a REST call from an ESS Job - Ideas needed!Content Hi Guys, Is there an option to call a REST service from an ESS Job? Please share your inputs. Thanks, Abh…Abhilash K - Deloitte USI 50 views 3 comments 1 point Most recent by Arun Raj Reporting and Analytics for ERP -
HCM Audit tablesSummary Need to find a table where audit information will be stored.Content Hi All, I need to find the tables where audit data is stored. Columns such as Data, User, Eve…User_2025-02-10-16-28-01-402 1.8K views 2 comments 0 points Most recent by B S Aravind Rao-Oracle Reporting and Analytics for HCM
-
How to implement Segment Value Data Security in BI Publisher ReportContent Hi All, Can someone provide insights on how to implement implement Segment Value Data Security (SVS) in BI Publisher Report. We have a requirement to create BIP …Himanshu245 330 views 2 comments 1 point Most recent by Matt Luscombe Reporting and Analytics for ERP
-
Multiple rows converted to columns grouped by employeeSummary Would like to display multiple phone types by column instead of having separate rows for each oneContent Hi - I am creating a report that shows specific phone ty…
-
Location of the Standard Account Analysis ReportContent Hi all, Are there any direct way to find the location of the standard report ( Account Analysis Report ) in the report and analytics section. Current it shows ma…Vipusha Chandrakumaran 27 views 2 comments 1 point Most recent by ravikiran goda-Oracle Reporting and Analytics for ERP
-
How to convert numbering format from Indian currency to Dutch (10.13 t0 10,13) to OTBI Report.Summary How to convert numbering format from Indian currency to Dutch (Amount 10.13 to 10,13) to OTBI Report.Content Hi All, We have a requirement to convert amount/curr…User_2025-02-10-16-28-01-402 39 views 5 comments 0 points Most recent by Ninja Reporting and Analytics for HCM
-
Disclosure for DiversitySummary Diversity TrendContent Hi Experts, We are trying to track diversity eg. Gender , ethnicity, Sexual Orientation, Disability etc over time Has anyone attempted thi… -
Reporting on "In Progress" Talent Review MeetingsSummary Talent Review ReportingContent Is it possible to pull talent review meeting data on meetings that are still "In Progress"? Right now all of our meeting notes and…User_2025-01-28-08-47-04-905 130 views 13 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Date & time of SubmissionSummary Date & time neededContent Hi, Is there a way to know the exact time and date the 360 review and performance review was submitted?Thanks AndrewVersion 20BUser_2025-02-05-22-44-35-842 20 views 4 comments 0 points Most recent by Andrew Gillibrand-Oracle Reporting and Analytics for HCM