SQL
Discussion List
-
Need to find out the Payroll Batch Loader Element Entry input value tablesSummary Need to find out the Payroll Batch Loader Element Entry input value tablesContent Hi All, I have a requirement to generate an error report for payroll batch load…Sricharan Monigari 117 views 6 comments 0 points Most recent by Sricharan Monigari Reporting and Analytics for HCM -
OTBI Security Risk - Seeded Reports Without User Security & OTBI Access for EmployeesSummary OTBI Security Risk - Seeded Reports Without User Security & OTBI Access for EmployeesContent Hi All, We have recently discovered that seeded Oracle reports do no…User_2025-01-29-23-59-58-976 138 views 12 comments 1 point Most recent by User_2025-01-29-23-59-58-976 Reporting and Analytics for HCM -
Displaying images in BI Publisher RTF TemplatesSummary Displaying images in BI Publisher RTF TemplatesContent Hi, I'm fetching employee images from PER_IMAGES to display in the report. I have provided size restrictio…Aloka Bhattacharya 61 views 4 comments 1 point Most recent by Aloka Bhattacharya Reporting and Analytics for HCM -
Reports not running since R13 18A appliedContent We upgraded to R13 and all Reports were running as expected, with no problems. Maintenance Pack 18A was then applied, and some reports are now experiencing issue…Rebecca Smith-27468 35 views 3 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Push Weekly Email Notifications to a particular group of Line Managers and EmployeesSummary Push Weekly Email Notifications to a particular group of Line Managers and EmployeesContent Hi Friends I need to send couple of weekly notifications to a group o…Mansur Khalil 54 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
EText Template: Count of rows not resetting at each LevelSummary Count the number of rows generated for each EmployeeContent Hi, We are trying to get a count of the rows generated for each Employee, but the count keeps increas…Brendon Charles-24581 217 views 3 comments 1 point Most recent by Brendon Charles-24581 Reporting and Analytics for HCM -
Reporting on KPI's of HR teams including metadataContent Hi Guys, I'm sourcing ideas on how tor report on KPI's that we need to report on around our HR team. Does anyone have any templates or ideas on how to create the…Ivy__Valverde 78 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Report on Active Employee count as of dateSummary I need a report that provides me an active employee (Active & LOA) as of start of each monthContent Hi, This is Shailesh. When I look at the counts from 'Workfor…User_2025-01-29-01-34-30-592 195 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
End of Year Active AssociatesSummary List of employees that were active the last day of last yearContent I have tried this every which way to Sunday and I can not get the right amount of employees. … -
New Hire and Termination ReportSummary Combining Active and Inactive Information in one ReportContent Hi, We currently have a BI Publisher report that were pulling all the New Starter base on the date…User_2025-01-29-01-38-21-058 200 views 2 comments 0 points Most recent by User_2025-01-29-01-38-21-058 Reporting and Analytics for HCM
-
Last calendar day of the previous month as default promptContent Hi Oracle Community, We are trying to have a prompt with the date automatically set on the last calendar day of the previous month (which is our closing day), bu…[Deleted User] 46 views 3 comments 0 points Most recent by [Deleted User] Reporting and Analytics for HCM
-
Fields for day start week and end weekSummary Create 2 fields in OTBI report for start date of the week and end dato of the weekContent Hi, Sorry for the dummy question but I couldn't figure out how to do it…
-
Has anyone built a report that lists all possible drop down menu option for HCM fields?Content Afternoon all, I was wondering if anyone has built a report that shows all configured data items for OOTB fields and DFF. We want to do an audit of all configure…User_2025-01-28-05-39-23-766 68 views 2 comments 0 points Most recent by User_2025-01-28-05-39-23-766 Reporting and Analytics for HCM
-
Count of Workers With No Performance GoalsSummary Need for building a report with workers without any performance goalContent Hi community, We currently have the report attached in BI to count workers per # of g…[Deleted User] 67 views 2 comments 0 points Most recent by [Deleted User] Reporting and Analytics for HCM
-
Future Dated RecordsSummary Future dated records/Inserted rowsContent I need to build a daily report for when managers/HR has entered a change when there are future dated records that need …User_2025-01-28-04-58-46-119 96 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Fast formula - Assignment History detailsContent Hi all, I need to export into a compensation worksheet the Last Updated Date from assignment history (please, see attachment) when it's been changed the custom f…User_2025-01-28-21-18-09-074 170 views 2 comments 1 point Most recent by User_2025-07-18-02-05-33-261 Reporting and Analytics for HCM
-
Fast formulas - standard fields & content typeContent Hi all, In order to build fast formulas, I'm lookig for the dbi for that standard fields: * PER_PERIODS_OF_SERVICE.ORIGINAL_DATE_OF_HIRE * PER_ALL_ASSIGNMENTS_M.…User_2025-01-28-21-18-09-074 47 views 5 comments 0 points Most recent by User_2025-01-22-18-30-18-571 Reporting and Analytics for HCM
-
Date effective OTBI report errorSummary Including Current date as default for presentation variable with PARAM_EFFECTIVE_DATEContent Hi I am trying to create an OTBI report which uses 'Effective_Date' …Mohit Gupta-45440 119 views 9 comments 0 points Most recent by Prudence K Reporting and Analytics for HCM -
After upgrade to Rel 13, compensation OTBI report is running into an error.Summary After upgrade to Rel 13, compensation OTBI report is running into an error. - Datatype: 17 is not supportedContent After upgrade to Rel 13, compensation OTBI rep…User_2025-01-25-04-02-13-126 35 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
How to receive assignmentId from Compensation Page & pull out Legal Employer based on itSummary How to receive assignmentId from Compensation Page & pull out Legal Employer based on itContent Hi guys, we are facing an issue related to compensation page. In …User_2025-01-28-21-18-09-074 40 views 14 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Scheduled processes reportSummary need to create a report to show all our scheduled processesContent hi, we have a lot of Scheduled processes who run every day. need to create a report showing al…User_2025-01-30-04-14-21-127 169 views 2 comments 0 points Most recent by Shakher Sharma Reporting and Analytics for HCM
-
Crossing Subject AreasSummary Certain dimensions will not populate even though I have linked by measures.Content I have created this report and I have been having the hardest time populating …Deb Luisi 123 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Calculating the Number of Business DaysSummary Count the number of Business Days between 2 datesContent I constantly get requests to provide reporting based on Business Days rather than Calendar Days. Calcula…Rick P Klassen 353 views 1 comment 1 point Most recent by Prudence K Reporting and Analytics for HCM -
Find all workers which are missing emergency contactSummary How to create a report which present the employees that missing an emergency contactContent Hi, Someone has an idea how to create a report in OTBI of all the emp…
-
Special caracter not displaying as expectedSummary In standard reports of notifications, the special caracter are not well displaying.Content Hello, Any ideas please how to display the caracter correctly in the s…User_I6AXL 42 views 2 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Benefit CreditsSummary We need a report that would display Benefit CreditsContent We need a report that would display Benefit Credits by Person Number on the left access and each benef…User_2025-01-29-19-59-40-005 44 views 1 comment 0 points Most recent by User_2025-01-29-19-59-40-005 Reporting and Analytics for HCM
-
Need to get count of employees as of date and as of first day of fiscal year i.e. 01-apr-20XXSummary Need to get count of employees as of date and as of first day of fiscal year i.e. 01-apr-20XXContent Hi, We have a requirement as below: ========================…Preethi Vadirajan 73 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Printing details on a single row using a XSL Fixed Position TemplateSummary Need help in printing both parent and child XML details in the same rowContent Hi All, Need your suggestions on how to solve the below requirement: 1. Applicatio…Brendon Charles-24581 29 views 8 comments 2 points Most recent by Mark Johnson Reporting and Analytics for HCM
-
Hierarchical prompt for org tree strucutre in BI Data Model ReportContent Is it possible to create a prompt in BI data model report that will give us the whole org tree structure in a cascading way according to different levels as we h…Amrit 78 views 2 comments 2 points Most recent by Farooq Syed, CPA, PMP, CISA Reporting and Analytics for HCM -
Maximum job proficiency in job profile competency in BI PublisherSummary where can I find the target level of competency job profile in BI publisherContent Hello, Do you have an idea where can I find the maximum proficiency in job com…User_I6AXL 31 views 1 comment 0 points Most recent by Rebecca Emerson Reporting and Analytics for HCM