SQL
Discussion List
-
BI publisher report for persons who ticked yes for an interview with their HR contact .Summary Tables where I can find question and responses for interview between salaries and their managerContent Hello, I want to create a report to display alls persons w… -
OTBI ACTIVE HEADCOUNT By CONTRACT TYPESummary Cross active headcount and contract typeContent Hello, I want to create a simple report that display active headcount by contract type and by Business Unit. BU e…User_NVBN4 50 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Share information on how the security works with bi publisher example with PER_PERSON_SECURED_LIST_VContent Hello, I want to share with you some research we have done on this subject and how the security works. first the security is done with Virtual Private Database (…User_2025-01-25-01-33-46-269 418 views 2 comments 3 points Most recent by User_2025-01-25-01-33-46-269 Reporting and Analytics for HCM -
Seeking BIP report for Worker, Potential Life event and Processed Life EventSummary Seeking BIP report for Worker, Potential Life event and Processed Life EventContent I need a list of workers and their event information - Potential and Processe…User_2025-01-23-21-24-21-434 96 views 8 comments 0 points Most recent by User_2025-01-23-21-24-21-434 Reporting and Analytics for HCM
-
Dynamic Image according to different legal employerSummary Dynamic Image according to different legal employerContent Hi, is it possible to create a report (rtf template trough Word BI Publisher add-on) with a dynamic im…User_2025-01-28-21-18-09-074 83 views 6 comments 0 points Most recent by Vikram Agarwal-43618 Reporting and Analytics for HCM
-
Issue in SQL script to get Overall Summary section commentsContent Hi All, I have written a script to get comments entered by both Manager and Worker in the Overall Summary Section (OS) in the Performance Document. (See my scree…Achala Munasinghe 122 views 4 comments 1 point Most recent by Achala Munasinghe Reporting and Analytics for HCM -
Learning Evaluations Report in OTBISummary Cannot Report Learning Evaluations DataContent I am trying to create an OTBI report that contains data from the Learning Evaluations folder in Workforce Learning…User_2025-01-28-17-24-53-863 193 views 3 comments 0 points Most recent by User_2025-01-28-17-24-53-863 Reporting and Analytics for HCM
-
Problem when filtring on OTBI to take MAX(date) for many userSummary I want to filter for max(date) for many users , It works only for one user .Content Hello, I create a report to display person id with a item_text,but for each i…User_I6AXL 98 views 7 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Email BurstingSummary How to send BI report pdf output as attachmentContent There is a requirement to send the pdf output of a custom BI report to employees. I have added the bursting…Vivek Pathak-71652 95 views 9 comments 0 points Most recent by Mansur Khalil Reporting and Analytics for HCM -
Job Grade ReportSummary Report to connect Job Info to GradesContent I am looking for a way to pull on a single report Job Code, Job Name, Family, Function, Management Level, Job Level, …User_2025-01-23-23-44-45-599 169 views 6 comments 0 points Most recent by User_2025-01-23-23-44-45-599 Reporting and Analytics for HCM
-
Date format 'DD-Mon-YYYY' in OTBI Analysis PromptContent Can anyone please guide how to get the date format 'DD-Mon-YYYY' in the OTBI Analysis prompt. Please see the screen-shot attached, where I want to achieve it.Amrit 232 views 1 comment 3 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
how to get business unit name from assignments?Summary how to get business unit name of assignments in BI reportContent Hi, I'm developing BI report using SQL script on HCM Cloud. User requested to add business unit …
-
SQL Script for Worker's departmentContent Hi All, I am trying to get the worker's department along with his name, person number, manager etc. I use the following script to get the department; SELECT DIST…Achala Munasinghe 84 views 4 comments 0 points Most recent by Achala Munasinghe Reporting and Analytics for HCM
-
How security works in case of custom report?Content Hello everyone, When we are using OTBI report it is following the security profile of the user logged in and in case of bip reports we have to use secured tables…User_2025-01-25-06-20-12-259 131 views 4 comments 2 points Most recent by User_2025-01-25-06-20-12-259 Reporting and Analytics for HCM
-
Tables and Views against OTBI Subject AreasContent Hi, Is there any resource available to refer Tables and Views against OTBI Subject Areas? Because referring OER is quite time consuming. Thanks and Regards AchalaAchala Munasinghe 101 views 3 comments 0 points Most recent by Vinit Kumar-47692 Reporting and Analytics for HCM
-
performance document - get date of transferContent Hello, I am trying to find when a performance document have been transferred to a new manager. Is someone know in with table (bi publisher or otbi) I can get the…User_2025-01-25-01-33-46-269 41 views 4 comments 1 point Most recent by User_2025-01-25-01-33-46-269 Reporting and Analytics for HCM
-
Limit Prompt Choice List Values by UserSummary I'd like the choice list values for my prompts to be only the values the logged in user should see.Content My dashboard prompts are Business Unit, Department Nam…User_2025-01-25-00-37-41-739 91 views 2 comments 2 points Most recent by User_2025-01-25-00-37-41-739 Reporting and Analytics for HCM
-
OTBI Report in DashboardContent I need to build a graph for the person headcount for different actions and then embed that graph in the dashboard. I understand that the person having the HR spe…
-
Reading file from Content ServerSummary Reading file from Content ServerContent We have a requirement to read a document/attachment from content server and display it on a report as either a link or to…Srihari Murthy 112 views 1 comment 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
Users doesn't have BI Reports access based custom roles after R12Summary Users doesn't have BI Reports access based custom roles after R12Content Users doesn't have BI Reports access based custom roles after R12. Will be appreciated f…User_AEMC1 55 views 1 comment 0 points Most recent by User_2025-01-22-18-30-18-571 Reporting and Analytics for HCM -
Taleo Recruiting SA Mapped to Tables?Summary Is there a document that details the subject area tables and columns mapped to the physical table and columns in Taleo for the Recruiting subject area?Content Is…Callen Raveret-67982 30 views 0 comments 1 point Most recent by Callen Raveret-67982 Reporting and Analytics for HCM
-
Number of hires by contract type in OTBI reportSummary I want to use 2 subject areas (contract type) and assi event real time to display number of hires by contractContent Hello, I m not able to join the number of hi…User_I6AXL 36 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Termination report with subquerySummary Looking for a subquery that would eliminate currently active employees form termination reportContent Hello, I am trying to build a termination report for our or…User_2025-01-29-23-59-58-976 96 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How get approver comments?Content Hi All, I am just trying to find a subject area to get the approval comments at the point of approval of a performance document? Is it possible to get from subje…Achala Munasinghe 57 views 5 comments 0 points Most recent by Dr Surlina Yin-Oracle Reporting and Analytics for HCM
-
OTBI Comp Report That Restricts ViewsSummary OTBI Compensation Report using a custom DM needs restriction on dataContent We've created an OTBI comp report using a custom data model. This report is allows mg…User_2025-01-25-00-37-41-739 42 views 7 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to enable graph report export option from UI Dash boardsSummary How to enable graph and report export option from UI Dash boardsContent We are not able to find export option on UI Dash board for graphs and reports. Client req…User_AEMC1 70 views 10 comments 1 point Most recent by Melanie Mahon-Oracle Reporting and Analytics for HCM
-
Report to Include Employees Who Have Gone from one Employee Type to anotherContent I need to create a report that shows me all employees who have moved from person type = Employee to person type = Manager (in Assignment Details). How do I compa…User_2025-01-25-03-28-26-914 36 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Tip: SQL Query to check existence of HCM EnterpriseSummary Tip: SQL Query to check existence of HCM EnterpriseContent Tip: SQL Query to check existence of HCM Enterprise ,which can be used in data model. select name,orga…Abhishek Sood HCM 58 views 3 comments 4 points Most recent by Prudence K Reporting and Analytics for HCM -
Number of current contracts in the actual month and in the previous MonthSummary Number of current contracts in the actual month and in the previous MonthContent Hello, I want to create report displaying number of employees by the contract ty…User_I6AXL 48 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Dashboard Prompt: Not show Inactive values in Search selectionSummary Control dashboard prompt to not show the Inactive values for users in search selectionContent Hi All, We have built a dashboard with dashboard prompt for 'Goal P…User_2025-01-23-22-36-48-692 58 views 3 comments 0 points Most recent by Caroline Gladwin-Oracle Reporting and Analytics for HCM