Public Sector
Discussion List
-
BIP Query to get only base elementsSummary BIP Query to get only base elementsContent While creating elements, there will be shadow elements that will get created automatically. Is there anyway to get onl…Sowdha Murugan 334 views 4 comments 0 points Most recent by Rakesh Kanukanti Reporting and Analytics for HCM -
Export Element RatesSummary Need to pull element rates out of HCM/PayrollContent Has anyone been successful in pulling element rates out of HCM/Payroll? By Element Rates, I am not referring…Brittani Roltgen 35 views 8 comments 0 points Most recent by RichardBrazil Reporting and Analytics for HCM -
Worker HDL Error A primary assignment already exists.Summary: We are trying to load worker data with historical Data in Dev1. We are getting this error(A primary assignment already exists.)for lot of inactive employees. We…Krishna Manmohan 39 views 2 comments 0 points Most recent by Krishna Manmohan Reporting and Analytics for HCM -
Sickness Absence ReportingSummary: We have work schedules entered for all employees showing their working days. We need to export this in our absence reports so we can calculate working days lost…Karen Wilson 11 views 4 comments 0 points Most recent by Karen Wilson Reporting and Analytics for HCM -
Benefit & Pension Calculation Card HistoryIs there an analysis or report that shows the history of a calculation card? I have an employee who was enrolled in main LGPS scheme up to 30 September 2023 but as of 1 … -
Where in OTBI subject areas can I find the actual start date of an assignment?Summary When trying to find the start date of an assignment, I can only find all actions related to the assignment. How to show only the actual starting date of the assi…Matti Bugge 462 views 6 comments 0 points Most recent by Nitin.Goswami Reporting and Analytics for HCM -
How to deep link for employment info page for specific assignment?Summary Looking for a way to create a deep link to individual assignments on the employment info pageContent Hi! I've created an OTBI analysis that shows terminations sp…Matti Bugge 325 views 11 comments 0 points Most recent by Michelle Dragojlov Reporting and Analytics for HCM
-
Is there an option to redact information, including PII data, in Cloud attachments?Summary: We have a requirement to redact information, including but not limited to PII data, in attachments that may be requested by outside sources. Are there any capab…AshleyT 5 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Update Affiliation or Professional BodySummary Trying to update the field in Talent Profile/MembershipsContent Hello, We are attempting to bulk update to the field labelled Affiliation or Professional Body ho…Dawn Cawston - CPS 26 views 25 comments 0 points Most recent by Silvia Stangarone Reporting and Analytics for HCM -
Query to get the rollover balance of Annual Absence Plan on January-1-2024Summary: Hi Guys, i have i have scenario, Plan A and Plan B. Plan A is Base plan and Plan B is target Plan where rollover is being transferred. for example Plan A has 20…
-
Payroll Balances Real Time not returning zero valuesContent We are using the folder Payroll balances Real Time to bring back for a payroll run those people who have zero gross pay, however, although in the person results …
-
People Group Flexfield segments not available in OTBISummary Unable to report on People group flexfield segments in OTBIContent Unable to report on individual People group flexfield segments in OTBI. People group is a key …User_939BK 119 views 5 comments 0 points Most recent by Hazel De Castro Reporting and Analytics for HCM
-
Length of Service calculation OTBISummary Calculation of LOS based on either Current Date or Termination Date for former employees.Content I am looking to calculate an individual's length of service base…Stephen Prentice 437 views 8 comments 0 points Most recent by Rahul K-Oracle Reporting and Analytics for HCM
-
Due Date dashboard prompt in OTBI gives precision_scale errorSummary: OTBI Learning Dashboard prompt for Due Date set to between gives a precision_scale error across all analytics Content (please ensure you mask any confidential i…Kevin Robertson 11 views 1 comment 0 points Most recent by David --Oracle Reporting and Analytics for HCM
-
Pass Parameter to Order By condition in Data Model (BI Publisher)Summary I'm trying to configure a Data Model to use a Parameter. I want a user to be able to choose a column to Order By.Content Hi, I'm trying to configure a Data Model…
-
Active Qualifying Scheme Name showing id rather than name in Payroll - Calculation cards Real TimeContent We have been starting to build a report using Payroll - Calculation cards Real Time looking at the pension auto enrollment card, however when we bring in the fie…Sharon Harper 32 views 3 comments 1 point Most recent by Sharon Harper Reporting and Analytics for HCM
-
Bring back Headcount Data from 12 months agoSummary I want headcount data from 12 months agoContent I have a simple report that sums headcount up and gives me numbers for today however I want to return the numbers…Richard Talbot 115 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Payroll Audit ReportSummary Payroll Audit ReportContent Hi, I have a requirement to create the Payroll Audit Report. Below is the requirement details. Has anyone developed this report or so…Dharmendra Jha 91 views 5 comments 0 points Most recent by Dharmendra Jha Reporting and Analytics for HCM
-
Pending worker Not converted report in OTBISummary Pending worker Not converted report in OTBIContent Hi, I am trying to create a Pending Worker Not Converted to Employee/Contingent worker report in OTBI. I am cu…Dharmendra Jha 89 views 6 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
How to get plan start and end dates for a persons absenceSummary: I want to build a report to show the start and end dates of a person enrolment in a plan as we need to write to each person when a plan will expire. Content (re…Sharon Harper 11 views 6 comments 0 points Most recent by Sharon Harper Reporting and Analytics for HCM
-
Calculating the number of days between 2 prompt datesSummary Calculating the number of days between 2 prompt datesContent I have set up a prompt to get the absences with start dates between 2 dates but I would like to be a…Rebekah Moore 47 views 2 comments 1 point Most recent by Mohamed Hasan Reporting and Analytics for HCM
-
EEO-4 Report - any ETA from Oracle?Summary EEO-4 Report - any ETA from Oracle?Content As every customer need a standard EEO-4 report as part of requirement, I understand it is in scope of future release. …
-
Report of Assignments in a flowContent I was hoping to have a report of assignments within a flow so that we can use that as the basis to check whether people will be paid during the calculate payroll…Sharon Harper 35 views 1 comment 1 point Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM
-
Statement of EarningsSummary Subject area for creating an Analysis in OTBIContent I would like to create an analysis using much of the information from the Statement of Earnings but adding m…Annette M 17 views 1 comment 0 points Most recent by user526585-Oracle Reporting and Analytics for HCM
-
Error when joining subject areasSummary Receving "View display error" when trying to join subject areasContent I'm trying to make an analysis where I need information from the subject area "Workforce m…
-
Trend report for Disability and Sexual orientationSummary incorrect calculations when trend subject are is joined with Person real Time Subject are.Content HI, I am having a requirement to show the trend of sexula orien…Su Ma 25 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Reporting Error with Worker.AssignmentNumber fieldSummary OTBI error being generated when user attempts to access report - specifically states user does not have access to Worker.AssignmentNumber fieldContent Hi all, We…
-
Error when trying to save an analysis - don't have sufficient privilegesContent Recently we started to receive the following error after editing and analysis and trying to save it. "You do not currently have sufficient privileges to save a r…
-
Database Table and Database Column for Target Bank presentation tableSummary Need the parameters to build a BIP report for outputContent I am building a report that displays as a form completed for each new starter however it will not out…Dawn Cawston - CPS 30 views 4 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM