SQL
Discussion List
-
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 45 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 142 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 -
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 …
-
Persons without data in organization level are missing in OTBI reportSummary if one person don't have data in the 5 level of organization will not appear in the reportsContent Hello, I hava some GID that are missing in my reports. When I …User_I6AXL 37 views 2 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
Impact to Custom BIP reporting due to R13 upgradeSummary Impact to Custom BIP reporting due to R13 upgradeContent Hi, Wanted to check if any customer needed to change custom BIP reports related to Compensation/Performa…User_2025-01-29-21-55-25-526 63 views 1 comment 1 point Most recent by Dr Surlina Yin-Oracle Reporting and Analytics for HCM
-
Extract the value 'WorkTermsAssignmentId'Summary I need the field WorkTermsAssignmentId for the HCM data loaderContent Hi, I'm trying to make mass update via the HCM data loader. One of the required field is 'W…
-
Error advanced sql request using two subject areasSummary avanced sql query errorContent Hello , Attached the request I did to display competeny proficiency and target for the job profile. I have an error message . Any …User_I6AXL 44 views 4 comments 0 points Most recent by Anil Pillaresetty Reporting and Analytics for HCM
-
Slow loading of a reportSummary OTBI report loading slow as ****Content Hi, I have a quite simple report in OTBI that shows the top 10 termination reasons by jobs, i.e which jobs have the most …
-
BIP - Merging rows using an eText Template based on a conditionSummary The XML returned contains multiple rows for an employee, the requirement is to merge them all into one row using an eText TemplateContent Hi, We have a requireme…Brendon Charles-24581 35 views 1 comment 2 points Most recent by Sricharan Monigari Reporting and Analytics for HCM
-
Competencies : target level and mine level in OTBISummary Competencies by target level and mine levelContent Hello, I cannot find in OTBI the mine level and target level . For example for the competency ITM_Architecture…
-
Many case statementSummary What is the correct syntax for many ifContent Hi, I would like to create a column (in OTBI report) that group the employees by their seniority (in years). So for…
-
Report capturing BPM workflow configurationSummary Can we create a report to capture workflow configuration rules for validation?Content Hi All - We have almost 100 rules configured for *VariableAllocation task.I…User_2025-01-25-04-02-13-126 102 views 4 comments 1 point Most recent by Piyush Mohapatra -OC Reporting and Analytics for HCM
-
calcul division , result wrong OTBISummary result of Division of sum (measure ) /sum(measure ) is not goodContent Hello , I want to calculate the percentage of headcount by competency So I have the number…User_I6AXL 61 views 8 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Assignment Audit ReportSummary Looking for a report that includes Updated, Corrected, and Deleted AssignmentsContent Hello, I am searching for an existing report or a way to report an audit of…User_2025-01-28-17-24-53-863 205 views 4 comments 0 points Most recent by User_2025-01-28-17-24-53-863 Reporting and Analytics for HCM
-
What does DATA_DS G_1 mean in BIP?Summary What does DATA_DS G_1 mean in BIP?Content Hello All, I am running a SQL in BIP and it is returning DATA_DS G_1 (see attached SQL and screenshot of DATA_DS G_1). …User_2025-03-07-21-07-25-805 478 views 6 comments 1 point Most recent by User_2025-07-18-02-05-33-261 Reporting and Analytics for HCM