SQL
Discussion List
-
Competency Rating in PerformanceSummary I need to pull item ratings and item comments a manager entered in the Competency section in a performance documentContent HELP!!!! I need to pull item ratings a…Gala Meyerovich 182 views 2 comments 0 points Most recent by Gala Meyerovich Reporting and Analytics for HCM
-
Slow performance in OTBI AnalysisSummary Slow performance in OTBI AnalysisContent Hello, I have created some Analysis in OTBI. I see that are very slow or they go in time out. The reports have 4 attribu…Giuseppe 1234 216 views 2 comments 0 points Most recent by Giuseppe 1234 Reporting and Analytics for HCM
-
Can Security Roles cause Duplicates in OTBI Analysis?Summary Troubleshooting Duplicates in AnalysisContent I have a user who is running a custom Analysis and getting duplicate and triplicate employee records returned. When…Brenda Jacks-49721 71 views 2 comments 0 points Most recent by Brenda Jacks-49721 Reporting and Analytics for HCM
-
degrees informations of profiles in tables fusion ?Summary I want to create a report using information of degrees of profiles in bi publisherContent Hello, Someone know please where can I found the information of degrees…User_I6AXL 68 views 2 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
BI Security - Secured view - real sqlContent Hello, I want to know if there is a way to get the real sql behind the secured view? For example: CMP_SALARY_SECURED_LIST_V or PER_PERSON_SECURED_LIST_V or PER_A…Amaury Blanc 166 views 15 comments 0 points Most recent by Amaury Blanc Reporting and Analytics for HCM
-
How to pull APR document through SQL?Summary How to pull APR document through SQL?Content We have a business requirement to pull Annual Performance Document of all employee. Oracle says there is an ER with …Abha Kumari 36 views 3 comments 0 points Most recent by Rebecca Emerson Reporting and Analytics for HCM
-
Bursting BIP QueryContent Hi All, We build BIP report with Bursting as per our requirement. The query which we build on the Performance Management module. If we run the report with Perfor…
-
Filtering Between Two "TimeStampDiff" DatesContent Good Day, I was wondering if anyone has had a similar query and has also found a solution. The query is i want to search between Two Dates and for then for it to…Clifford-Barrington Trett 89 views 5 comments 0 points Most recent by Colin Foyle-52651 Reporting and Analytics for HCM
-
Report doubling my values.Summary I have a report which should count every employee as 1, but for some reason counts them as 2.Content Hi, I have a traffic light report which counts employees who…Christopher Finnerty-30019 30 views 3 comments 0 points Most recent by Antony Hooper-29731 Reporting and Analytics for HCM
-
Remove expired dates from an end date report.Summary End dates of before the current date are appearing on my report.Content Hi, I have produced a report on end dates, such as fixed term and probation end dates. Th…Christopher Finnerty-30019 43 views 4 comments 0 points Most recent by Christopher Finnerty-30019 Reporting and Analytics for HCM
-
Changes in Hours / Grade / Salary / Organisation / Business Units etcContent Hello, We are looking for a way to create an analytical report or maybe even a dashboard that can show when "Historically" an employee has changed one of these f…Clifford-Barrington Trett 132 views 3 comments 2 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Unable to pick latest salary details for a person using subject area "Compensation - Salary HistoryContent Hello All, I am having a trouble in pulling out the latest salary details for a person using "Compensation - Salary History Details Real Time" Subject area. I ca…Puja Bharati-27866 134 views 18 comments 0 points Most recent by Puja Bharati-27866 Reporting and Analytics for HCM
-
Reporting on Working Pattern/ Work Schedules aswell as current assignment information in a single reSummary Possiblity of generating a report Including Working patterns/Work and Assignment information within an Analysis/ReportContent Hello, We are currently struggling …Brad Hughes 104 views 4 comments 0 points Most recent by Brad Hughes Reporting and Analytics for HCM
-
Comments of manager for annual performance interview information in BI publisherSummary Where can I find the comments of the manager for the annual performance interview in PI publisher (fusion tables)Content Hello, Someone know where can I find in …User_I6AXL 80 views 3 comments 0 points Most recent by Perumal Veerappan Reporting and Analytics for HCM
-
Location of Performance Document Manager for BIP in Release 11Summary I would like to know the location of Performance Document Manager for BIP reportContent I have a BIP report where the user, manager's name, and the last complete…Christina Anglin 90 views 6 comments 0 points Most recent by Perumal Veerappan Reporting and Analytics for HCM
-
Dialogue message when clicking on prompt in BI publisherSummary Message Dialog box when selecting a parameter as prompt in bi publisherContent Hello, Is it possible to create a message dialog box to inform the user form examp…User_I6AXL 37 views 1 comment 0 points Most recent by John Palethorpe 01 Reporting and Analytics for HCM
-
Citizenship OR Nationality In OTBISummary Which subjects areas contains Citizenship exept in subject area Workforce Person Profile Real TimeContent Hello, Someone knows where can I find the citizenship e…User_I6AXL 145 views 2 comments 1 point Most recent by Puja Bharati-27866 Reporting and Analytics for HCM
-
SIRET AND SIREN In BI publisherSummary I want to make a request with GID, SIRET AND SIRETContent Hello, Someone know where Can I find the information SIRET and SIREN in fusion tables please? What is t…User_I6AXL 80 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Pay Period Dates v Check DateSummary Table(s) needed to link pay period dates to check dateContent How do I link the check date from effective_date in pay_payroll_actions to pay begin and pay end da…Dena Swanson 357 views 2 comments 0 points Most recent by Dena Swanson Reporting and Analytics for HCM
-
List of direct reports in dashboard promptSummary Users select "Top" manager from dashboard prompt and another prompt lists all their direct reportsContent We have select performance tiles setup and want users t…Shawn McDonald 133 views 7 comments 2 points Most recent by fbarazan-Oracle Reporting and Analytics for HCM
-
National Identifier in fusion tablesSummary Finding the description of the national identifier for each employee in the tables fusionContent Hello, Someone know where can I find the descriptif column of th…
-
Join attributes(compensation amoun) with Organization HierarchySummary when trying to make the joint between compensation amount and oraganization hierarchy the result of compensation amount for each person_number is wrongContent He…
-
Advanced SQL filterSummary return max value from sql filterContent Hello, I built a Table view to display some data and some of that comes from the Matrix Manager folder in the Workforce P…Shawn McDonald 113 views 2 comments 0 points Most recent by Shawn McDonald Reporting and Analytics for HCM
-
Master Detail LinkingSummary I'm attempting to create a new hire report that will show a graph of new hires by month. However i would like to link the graph to the employee detail table.Cont…Margaret Harvey 77 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to fetch the forecast based on trending for Average terminationSummary Need to fetch Average Termination count for 2015FY,2016FYTD and 2016 Forecast Based on TrendingContent Hi All, I am having problem in the creation of analysis re…Rahul Mishra-19235 58 views 4 comments 0 points Most recent by Rahul Mishra-19235 Reporting and Analytics for HCM
-
How to create analysis report to pick employees who has not set the objective in performance documenSummary Need to pick employees with no objective details in the performance documentContent Hi All, As per the requirement of one of the report, We are having Annual Rev…Rahul Mishra-19235 104 views 1 comment 0 points Most recent by User720640-Oracle Reporting and Analytics for HCM
-
Email ID for Document Manager is Performance DocumentSummary This isn't available as a field within Performance OTBI. So wanted to see if anyone has the logical SQL to get this data.Content My company has release 11. We ar…Kristen Magno 21 views 6 comments 0 points Most recent by Kristen Magno Reporting and Analytics for HCM
-
How to convert data type of attributes for further manipulation in OTBISummary Executing mathematical functions on a numeric value in a character fieldContent This may have been answered before but I was not able to find it. I am trying to …Khalid Jamil-27648 78 views 2 comments 0 points Most recent by Wade Wilson Reporting and Analytics for HCM
-
How to make rows to show as column in reprt OBIEE?Content Hello, Is there a way to make rows to show as column in report OBIEE? For example phone type- to display as 2 column and not 2 rows - see screenshots. Thank you
-
Report of Users and Roles in OIM ?Summary HCM / Fusion Oracle Identity Manager (OIM) reportsContent Does anyone know of a report showing Users active in Fusion OIM and the roles assigned to those users? …Kim Forsen 159 views 4 comments 0 points Most recent by Constantin Tudor Urseiu Reporting and Analytics for HCM