SQL
Discussion List
-
Previous Termination Date and Assignment NumberSummary Previous Termination Date and Assignment NumberContent Hi Guys, Its my first time in here. Just want to know if there's a way to get the previous assignment numb…Anthony Albito-166048 40 views 8 comments 0 points Most recent by Anthony Albito-166048 Reporting and Analytics for HCM -
Termination Date Using Column ReferenceSummary Get a greater than term date if business unit = thisContent UPDATE: I have attached a copy of the XML of the original report. My goal is to only bring back termi… -
Org Chart in OTBISummary Ability to create Org Chart in OTBIContent Hi All, I am looking at ways to create an Org Chart in OTBI, which will display the Hierarchy in a Tree View similar t…User_FWOAZ 490 views 6 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Etext Template in csvSummary Etext template in csv drops leading 0's from reportContent when we export the file as text, the ID's keep leading 0's, but when it goes to csv leading 0's are dr…Mike Borghoff 28 views 2 comments 0 points Most recent by Mike Borghoff Reporting and Analytics for HCM
-
report to get list of direct reports for a managerContent Hi Experts, I am looking for a query where the manager can get the output as the name of all direct report specific to them, I am able to achieve it in analysis …GauravSushant 737 views 3 comments 1 point Most recent by User_FWOAZ Reporting and Analytics for HCM -
Headcount in Fusion ProfileSummary Do you know what table does Headcount belong to in Fusion>Person Management>Manage Person.Content Do you know what table does Headcount belong to in Fusion>Perso…Mark kristan De los Reyes 29 views 1 comment 0 points Most recent by Aaron Leggett Reporting and Analytics for HCM -
field that pulls number of direct reportsSummary I am working on a report that requires a field to pull 'Number of Direct Reports'. A non-manager would have 0 or null. Manager will pull active direct reports.Co…David Nguyen-188124 63 views 4 comments 0 points Most recent by Cyndi Quebbemann Reporting and Analytics for HCM
-
Has anyone seen custom reports timing out after 20A upgradeSummary BIP Reports timing outContent We have a custom BIP report built off a SQL data model. It used to run about 15 minutes. After upgrading to 20A in all our developm…TonyWo 38 views 3 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
Pull Question Library with SQLSummary Questionnaires:- My Workforce > performance > Setup and maintenance > Manage Questionnaires > Select “HR Checklists” in Subscriber > Select “Questionnaire Librar…David Nguyen-188124 43 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
BIP Report: Converting multiple row & multiple column values into single row and multiple column valSummary BIP Report: Converting multiple row & multiple column values into single row and multiple column valueContent Dear Experts I am working on a BIP report (SQL quer…Karthik K-Oracle 255 views 1 comment 0 points Most recent by Karthik K-Oracle Reporting and Analytics for HCM -
Concatenate a case statement with fieldsSummary I want to concatenate a case statement with a field in OTBI. How would i do so?Content "Worker"."Person Type", CASE WHEN ( "Assignment Manager List Unsecured"."M…David Nguyen-188124 61 views 3 comments 0 points Most recent by Susan Anderson Reporting and Analytics for HCM
-
Connect OTBI to SQL DeveloperSummary ReportingContent Is there a way to connect OTBI to SQL developer? I want to run queries and create reports through SQL developer.David Nguyen-188124 180 views 3 comments 1 point Most recent by Tom Strudley Reporting and Analytics for HCM
-
Can I report on System Entry Date?Summary How can I report on the system entry date of an action? Not the creation date or last update date.Content Hi all, Has anyone found a way to report on the actual …Bethany Aho 91 views 5 comments 0 points Most recent by Matthew Voss Reporting and Analytics for HCM
-
Using Multi-threading in BI Publisher Data ModelSummary Using Multi-threading in BI Publisher Data ModelContent Hi Experts, In order to improve performance , I see that BI publisher has option in Data Model Properties…Aloka Bhattacharya 435 views 1 comment 0 points Most recent by Mihaela M Reporting and Analytics for HCM -
Using WITH in SQL versus sub-query-which is better?Summary Using WITH in SQL versus sub-query-which is better?Content Hi Experts, Can someone help me understand if using WITH in SQL query really improve performance versu…Aloka Bhattacharya 112 views 1 comment 0 points Most recent by Mihaela M Reporting and Analytics for HCM
-
Attributes of Pay ElementsSummary Taxable, Niable and Pensionable flags associated with each pay elementContent Hello, I am trying to develop a report in Oracle Fusion to obtain every payroll ele…Richard Bowron 49 views 3 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM -
Making Changes to Standard Notification TemplatesSummary Is there a delay between a customized BIPublisher report and the workforce Notifications?Content Hello Experts! We've recently started venturing into changing so… -
How to get readiness level in reportContent Hi Everyone. I am trying to get the data of the succession plan in a report however I got all data except Readiness level. In HRM_PLAN_CANDIDATES table, the Read…Misbahul Khair 45 views 1 comment 0 points Most recent by Nancy Lang-Oracle Reporting and Analytics for HCM -
Potential assessment report on a specific talent reviewSummary Potential assessment report on a specific talent reviewContent Hello, we have a OTBI report for potential assessment, this report is accessible through > select …HeleneV 51 views 1 comment 0 points Most recent by Nancy Lang-Oracle Reporting and Analytics for HCM -
BI Publisher data model filter manager typeSummary Recently implemented second manager type which is causing multiple lines on BIP reportContent We have a daily BIP report that sends employee data based on action…Rob Stahly 25 views 4 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Leave adjustment detials for employeesSummary Leave adjustements for employees is available in any subject areas in OTBIContent HI, In the Absences sometime HC team are doing adjustment in the annual leave, …Farooq Syed, CPA, PMP, CISA 32 views 4 comments 1 point Most recent by Andrew Collins-174647 Reporting and Analytics for HCM -
Location informationSummary I need to run a report showing our locations, addresses etcContent Hi, Is there a subject area that holds the following information: Location Name, Office, City,…Andrew-180341 45 views 5 comments 0 points Most recent by Susan Anderson Reporting and Analytics for HCM
-
Converting Simple SQL into Direct Database SQLSummary Converting Simple SQL into Direct Database SQLContent I have a current report written in Simple SQL as I need to do some left joins on Subject Areas in OTBI. How…Lisa Whittleworth 59 views 3 comments 4 points Most recent by Karen Waddell Reporting and Analytics for HCM
-
Previous and current values flip in the OTBI ReportSummary Previous and current values for different action codes for an employeeContent Hi All, I have a requirement to fetch a report consisting of changes to Jobs, EEO1 …User_HF4N3 361 views 21 comments 1 point Most recent by Matthew Voss Reporting and Analytics for HCM -
Work Schedules in OTBIContent Afternoon all, Has anyone managed to report on all of the details that sit within Fusion Work Schedules from OTBI? I've built a fairly simple report, that pulls …Evan Jenkins 287 views 6 comments 3 points Most recent by Emily Robinson Reporting and Analytics for HCM -
Dashboards which Include a Date PromptSummary Dashboards which Include a Date Prompt and No Data ReturnedContent Hi, I have created a Dashboard with a Date Prompt and a BI Publisher Report. The BI Publisher …Karen Waddell 47 views 5 comments 0 points Most recent by Karen Waddell Reporting and Analytics for HCM -
Oracle BIP Report - Does not return results with 'French' as Application Interface LanguageSummary Oracle BIP Report - Does not return results with 'French' as Application Interface LanguageContent Hello, I have a BI-Publisher report which uses database tables…SantoshKumarBhairi 56 views 1 comment 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Manager NameSummary need manager name in report, but need it like First Name Last Name. Not Last Name, First NameContent Manager Name by default pulls Last Name, First Name. We need…Mike Borghoff 41 views 3 comments 0 points Most recent by Matthew Voss Reporting and Analytics for HCM
-
HCM BI report data model tables to check SQLquerySummary HCM BI report data model tables to check SQLqueryContent Hi, I wonder if there are tables that I can check SQL query for custom BI reports. We have multiple BI r…Suyoung 63 views 2 comments 0 points Most recent by Sricharan Monigari Reporting and Analytics for HCM
-
need a table name to get the "Payroll Transfer Status" field in time and laborSummary need a table name to get the "Payroll Transfer Status" field in time and laborContent Hi Team, i am looking for a table to get the "Payroll Transfer Status" fiel…Chaitanya Jogi 148 views 1 comment 0 points Most recent by Mark Erzen Reporting and Analytics for HCM