Public Sector
Discussion List
-
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… -
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 52 views 5 comments 0 points Most recent by Dharmendra Jha Reporting and Analytics for HCM -
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…Sowdhaminya Murugan 48 views 3 comments 0 points Most recent by Raghu Seregar 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 147 views 7 comments 0 points Most recent by Julian Challenger-Oracle 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 26 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 12 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 38 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. …Sowdhaminya Murugan 62 views 4 comments 1 point Most recent by Jesus N 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 7 views 22 comments 0 points Most recent by Dawn Cawston - CPS Reporting and Analytics for HCM -
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 …Sharon Harper 19 views 5 comments 0 points Most recent by Mohini Dhasmana Reporting and Analytics for HCM
-
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 16 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 18 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 15 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…
-
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 12 views 1 comment 1 point Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM
-
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 11 views 4 comments 0 points Most recent by Mandeep Gupta Reporting and Analytics for HCM
-
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 88 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 60 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 9 views 1 comment 0 points Most recent by Aaron Leggett 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…
-
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?Sowdhaminya Murugan 32 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 28 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 22 views 4 comments 1 point Most recent by Anil Kola-Oracle Reporting and Analytics for HCM
-
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 30 views 4 comments 0 points Most recent by Sharon Harper 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 14 views 3 comments 1 point 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 11 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 19 views 2 comments 1 point Most recent by Sharon Harper Reporting and Analytics for HCM