Public Sector
Discussion List
-
Employee Salary ReportContent Is there a seeded report (or a custom report you would share), that includes the wages for a period (entire year), including the employee name, date of hire, tot…Annette M 236 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Filter Logical SQL based on dashboard prompt with multiple valuesContent Hi Thurrock are developing a customised version of the Line Manager Dashboard to suit their needs. An important aspect is having the ability to drill-down throug…Andrew Collins-174647 171 views 13 comments 0 points Most recent by Raymund Jerome Reporting and Analytics for HCM -
Joining iby_ext_bank_accounts_ audit table with the person recordSummary Joining iby_ext_bank_accounts_ audit table with the person recordContent Hi All, I am trying to create the audit report for the Bank Account Changes and want to …Dharmendra Jha 39 views 1 comment 0 points Most recent by Aaron Leggett Reporting and Analytics for HCM
-
Deliver OTBI report to SFTPContent I could see there is limitation in sending OTBI report output to SFTP folder. Is there any workaround that is being followed or is it just via BIP report?Sowdha Murugan 62 views 3 comments 2 points Most recent by Srinivas Pendyala-Oracle Reporting and Analytics for HCM
-
Retrieving Historical Data on all fields in Worker Assignment Real TimeContent I have built a report a report pulling fields from worker and department and have entered SET VARIABLE PARM_EFFECTIVE_DATE = '@{report_Date}{@{system.currentTime…Sharon Harper 37 views 4 comments 0 points Most recent by Sharon Harper Reporting and Analytics for HCM
-
Date Filter with Default value FailsContent I am new to OTBI and have tried to follow the various posts etc. about creating a report with a filter on the criteria and have used a presentation variable. How…Sharon Harper 41 views 4 comments 1 point Most recent by Anil Kola-Oracle Reporting and Analytics for HCM
-
Where is the Current Incumbent field located in BI reporting?Content I can't find the CURRENT INCUMBENT field in BI reporting, only level incumbents. We had a report built for us by our implementer that had the CURRENT INCUMBENT f…Halle 43 views 3 comments 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
FPPA ReportSummary FPPA ReportContent Does anyone have an FPPA report in BI that they would be willing to share? We are new to Oracle and struggling with Reports.Jenna Savage 20 views 2 comments 0 points Most recent by Jenna Savage Reporting and Analytics for HCM -
Absence cases and Details linked to absenceContent I am looking to build a report that includes the absence cases and the associated absence and details from the documents that have been attached in order to prov…Sharon Harper 28 views 2 comments 1 point Most recent by Sharon Harper Reporting and Analytics for HCM
-
Scheduled Absences FieldSummary How do I get scheduled absences for this plan year only?Content Hi I need to run an accrual report for Finance and they need the absences booked but not taken in… -
Monitoring License Metrics - Transactional Business Intelligence Cloud ServiceSummary What drives the license usage for Oracle Fusion Transactional Business Intelligence Cloud Service?Content Hi all, Many of the subscriptions are driven by a speci…Sian S 25 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Who hasnt submitted a TimecardContent Hi all We have been live with HCM for a year and i have been tasked with providing a report that shows who has not submitted a time card. The seeded reports dont…Dawn Cawston - CPS 73 views 1 comment 0 points Most recent by SameerJain Reporting and Analytics for HCM -
New DFF Segment Not Appearing in OTBIContent Hello, I've added some new segments to the Document Record DFF. I ticked the box labelled "BI Enabled" for each segment, and both verified/deployed the DFF. Its …Edward Cowne 173 views 16 comments 2 points Most recent by Akshay Aiyer Reporting and Analytics for HCM
-
Error in Report - Date not filtering properly with other variables in Oracle ReportSummary dates not filtering correctly with other variableContent I am trying to filter dates with step increases in a custom Oracle Report; the objective is to show how …Noël Frempter 9 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Starters as at Start DateSummary Data must be returned as at the Start DateContent Hi all I have a starters report that provides me with all the starters between two points in time however the d…Dawn Cawston - CPS 28 views 26 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Reporting Folder StructureSummary People in the business keep dragging and dropping the folders by accidentContent Good afternoon all We have an ongoing problem with people within our wider busin…Dawn Cawston - CPS 32 views 3 comments 0 points Most recent by Lucky Sharma Reporting and Analytics for HCM
-
Day wise break up of absences in OTBIContent Hi Team We have a very basic requirement that absences for multiple days need to be broken down into individual days and be displayed on OTBI When i ran the Abse…
-
Report not showing own itemsSummary An report from timecards does not show own itemsContent We use time and labour to claim overtime as well as to record our flexi. With all our reports in OTBI, th…Dawn Cawston - CPS 44 views 4 comments 0 points Most recent by Dawn Cawston - CPS Reporting and Analytics for HCM
-
OTBI Worker Assignment Real time cannot report on Substantive ManagersSummary OTBI Worker Assignment Real time cannot report on Substantive ManagersContent Hi We need to report on all employees in a Managers chain of command and that inclu…Paresh Mulye-159565 38 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Report on Terminated Employees Sickness AbsenceSummary We cannot report on sickness absence data for terminated employeesContent Hello, We have a requirement to report on the average working days lost for all employe…Dawn Cawston - CPS 32 views 2 comments 0 points Most recent by Dawn Cawston - CPS Reporting and Analytics for HCM
-
Absence Days between DatesSummary Data must be returned where the absence is between two datesContent Hi all Can anyone help me with a problem where the Workforce Management - Absence Calendar De…Dawn Cawston - CPS 59 views 4 comments 0 points Most recent by Dawn Cawston - CPS Reporting and Analytics for HCM
-
Editable checkbox in BIP ReportSummary Need a checkbox in report where users can check/uncheckContent Hello - We have a requirement where the BIP report should display checkboxes with options and the …
-
Termination ActionSummary Where is Termination Action in OTBIContent Good afternoon We have created a leaving report in Work Relationship Real Time subject area however the Termination Ac…Dawn Cawston - CPS 62 views 16 comments 0 points Most recent by Dawn Cawston - CPS Reporting and Analytics for HCM
-
Feedback on Useful Seeded Manager Dashboards or Reports AvailableSummary Keen to learn from others of some basic reports that might be useful for managers to self-serveContent Cornwall Council went live with Oracle HCM, for HR and Pay…Abby Cockings 34 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to get a list of all languages from HRT_CONTENT_ITEMS_TLContent Hi, Under talent profile and language skills - how do I just get a list of all available languages? See they are hiding in HRT_CONTENT_ITEMS_TL but not sure how …King Jack 46 views 1 comment 2 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
00/00/0Summary Cannot filter on report returnContent Hi all I am looking at working pattern reporting. All our full time standard working hours peeps inherit their working patt…Dawn Cawston - CPS 36 views 7 comments 0 points Most recent by Dawn Cawston - CPS Reporting and Analytics for HCM
-
HCM DeeplinkSummary Deeplink to view absence recordContent Has anyone created a deep link in a report to view an absence record?User_939BK 66 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
OTBI HCM Employee ReportSummary Required HCM OTBI database mapping with UI screensContent Dear All, I'm new to OTBI reporting. I need to create a employee report using OTBI and I'm unable to fi…Suresh Veesam 129 views 6 comments 1 point Most recent by Tejaswini-Oracle Reporting and Analytics for HCM
-
Return the Line Manager at a Point in TimeSummary Return the line manager at a PITContent Hi all I am trying to build a report that displays the line manager against the person at a specific point in time howeve…Dawn Cawston - CPS 28 views 16 comments 0 points Most recent by Dawn Cawston - CPS Reporting and Analytics for HCM
-
Getting the P_DATE as a columnSummary Getting the prompted date to be the date in a column.Content Is there anyway of being able to get the P_DATE that you have set as a prompt to show in a column? I…Rebekah Moore 47 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM