SQL
Discussion List
-
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 201 views 2 comments 0 points Most recent by User_2025-01-29-01-38-21-058 Reporting and Analytics for HCM -
![[Deleted User]](https://us.v-cdn.net/6034893/uploads/defaultavatar/nUDT79VNNXZBX.jpg)
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] 66 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 167 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 121 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 349 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 72 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 30 views 1 comment 0 points Most recent by Rebecca Emerson Reporting and Analytics for HCM
-
Is there a way to create a sql viewSummary Is there a way to create a sql viewContent We want to create a sql view (e.g. employee hierarchy) and use it in various reports rather than repeat the code in ev…User_2025-01-24-00-06-12-585 54 views 4 comments 1 point Most recent by AshishERPCloud Reporting and Analytics for HCM
-
Amounts getting duplicated in OTBISummary Amounts getting duplicated in OTBIContent Hello - We build a custom OTBi report using 'Compensation - Workforce Compensation Real Time' SA. There are few columns…User_2025-01-25-04-02-13-126 132 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Two part question regarding CEO's manager and Assignment Manager (Unsecured)Summary Reporting with CEO and Assignment Manager (Unsecured)Content This is a two part question. 1.) Our CEO does not currently report to any manager in HCM. Is this co…User_2025-01-28-20-24-47-566 76 views 4 comments 0 points Most recent by Ashok S Raj Reporting and Analytics for HCM
-
BI Report to draw Absence Balance mismatchSummary Need to develop a OTBI/BI report in Fusion to draw Absence Balance mismatch in front endContent Hello Team, There is a balance mismatch in Fusion front end. The …Aahiri_Sarma 86 views 7 comments 0 points Most recent by Ashok S Raj Reporting and Analytics for HCM -
Unable to fetch few tasknumber from approval related tablesContent Hi Team, We have a requirement to generate report for approval transactions (i.e approved/rejected). For that we have built a query based on the below tables 1)h…User_1B10X 113 views 1 comment 0 points Most recent by Dr Surlina Yin-Oracle Reporting and Analytics for HCM
-
Years in Job calculationSummary How to calculate years in jobContent We are trying to calculate the number of years an employe has been in a specific job, but since there is no "start date" for…Karen B 106 views 4 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to handle null values while Summing in RTF TemplateSummary How to handle null values while Summing in RTF TemplateContent Hi Team, Please advise with syntax for to handle null values while Summing values in RTF Template …User_2025-01-29-00-33-34-534 932 views 3 comments 0 points Most recent by Dr Surlina Yin-Oracle Reporting and Analytics for HCM
-
BI Publisher report with Variable CoveragesSummary Trying to connect Benefit Plans to Variable Coverage data in BIPContent We used Variable Coverages to administer our Health Savings Account Plan. We regularly up…User_2025-01-23-21-24-21-434 79 views 4 comments 1 point Most recent by User_2025-01-23-21-24-21-434 Reporting and Analytics for HCM
-
Bursting in BIP report using the rolesContent Is bursting possible based on the roles the user is assigned. For Example, if I have a report containing the data for US and UK, then all the person who has the …