SQL
Discussion List
-
Fusion Field - OTBI Subject / Folder MatrixContent Afternoon all, Is there a master matrix anywhere that lists fields in Fusion and cross-references them to their location subject area / folder / sub folder in OT…User_2025-01-28-05-39-23-766 117 views 2 comments 1 point Most recent by User_2025-01-28-05-39-23-766 Reporting and Analytics for HCM -
Valid Job Grade reportingSummary We are trying to determine if we have muliple Valid Grades for Job CodesContent We found some Job Codes with multiple Valid Grades and I am having difficulty wri…User_2025-01-23-21-24-21-434 146 views 5 comments 2 points Most recent by Nitin.Goswami Reporting and Analytics for HCM
-
Table Name for Scheduled ProcessesSummary Am looking for the Database TABLE name for querying all scheduled/processes with their PROCESS_IDContent Hi, Am looking for the Database TABLE name for querying …User_2025-01-30-03-39-56-442 1.5K views 2 comments 1 point Most recent by Sricharan Monigari Reporting and Analytics for HCM
-
Changes only data in BI ReportsContent Please consider the following scenario: The Department of an employee is updated from 'Department A' to 'Department B' on 15th December 2017. The report is run o…Amrit 324 views 9 comments 0 points Most recent by User_2025-01-25-06-20-12-259 Reporting and Analytics for HCM -
Report on Comments from Performance FormsSummary I'd like to report on the manager and employee comments from a performance docContent Managers and employees are asked to provide a rating and comment on each co…User_2025-01-25-00-37-41-739 239 views 2 comments 1 point Most recent by User_2025-01-25-00-37-41-739 Reporting and Analytics for HCM
-
Table for getting the Scheduled HCM Extracts listSummary Need table names for getting the scheduled payroll flows listContent Hi All, I have a requirement to generate BIP report with all the scheduled payroll flows and…Sricharan Monigari 67 views 2 comments 0 points Most recent by Sricharan Monigari Reporting and Analytics for HCM -
OTBI Head count report sorting by Division(Error: No Result Found)Summary OTBI Head count report sorting by Division(Error: No Result Found)Content Hi Team, I am looking for a report in OTBI with Division , Employee count and System pe…User_2025-01-30-05-05-05-573 82 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Salary History report errors outContent I need to create a report that pulls future dated salaries loaded from Workforce Comp. I'm trying to create a simple analysis using the "Compensation - Salary Hi…Gala Meyerovich 73 views 11 comments 0 points Most recent by Gala Meyerovich Reporting and Analytics for HCM -
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 51 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 94 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 196 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 101 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 94 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 92 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 34 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM