SQL
Discussion List
-
SQL Query to fetch Talent Profile History DataSummary SQL Query to fetch Talent Profile History DataContent Hi Experts, How to fetch Talent Profile History Data. Please provide SQL Query. Regards, Bala Version 20AUser_2025-02-05-04-17-04-394 388 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Using LIKE with FILTER() in an AnalysisContent I am trying to build a simple tile that gives the total number of employees with a job name that contains 'Director'. Example - 'Director of Compliance' I run in…User_2025-02-10-08-27-16-805 32 views 3 comments 2 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
SQL to pull Previous Line ManagerSummary Sample SQL to pull Line Manager from the Previous Assignment RowContent We have created a data model that pulls most current assignment row where actions = Promo… -
How to identify resubmitted goals for approval?Content Hi, I am creating a goal status report where I am able to get proper goal status from the table HRG_GOALS with column GOAL_VERSION_TYPE_CODE except for those who…Nivya Mathire 56 views 6 comments 2 points Most recent by Nivya Mathire Reporting and Analytics for HCM -
User Role Historical DataSummary Getting the Historical data of RoleContent Hi, Is it possible to get the historical data of User Role in HCM? We are not using the End_date on the user role, but…User_2025-02-04-07-19-57-588 62 views 5 comments 1 point Most recent by Ravi Shinde Reporting and Analytics for HCM
-
Logical SQL not recognizing Custom Fields in OTBIContent Morning all, I'm amending the Logical SQL for a report, but every time I try to reference our custom fields, the report errors out (see picture). It recognizes O…User_2025-01-28-05-39-23-766 30 views 4 comments 1 point Most recent by User_2025-01-28-05-39-23-766 Reporting and Analytics for HCM
-
How to link Person Real Time Subject Area with Workforce Management - Worker Assignment Event Real TSummary Is it possible to do this using logical SQL?Content Hi, I'm new to OTBI and I'm experiencing a lot of frustration regarding the Person Real Time Subject Area not…User_2025-02-05-22-44-35-842 86 views 7 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Error on Report Template - java.lang.ClassCastExceptionSummary In the data model, all is good, data is is showing but when I run the report template this error pops out "java.lang.ClassCastException". Please see attached ima…Mark kristan De los Reyes 18 views 3 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Is there any way to connect Oracle Fusion OBI from SQL ServerContent H Is there a way to connect to Oracle Fusion OBI server to our local SQL Server? We would like to report on Data in conjunction to our local HRIS system. Thanks,…Nizar Kassam 50 views 8 comments 2 points Most recent by Nizar Kassam Reporting and Analytics for HCM -
Data Models Best PracticesSummary Are the Best Practices for Building Data Models using Tables vs. ViewsContent Wondering if there are best practice guidelines for building Data Models? For examp…Denise Izzi 54 views 4 comments 0 points Most recent by Valeriy Gorbunov-80491 Reporting and Analytics for HCM
-
Logical and Relational Data Model Diagrams For Fusion Applications HCMSummary Logical and Relational Data Model Diagrams For Fusion Applications HCMContent I wondered if there was an updated Fusion Cloud HCM data model to easily identify t…Ruzwan Akram 515 views 1 comment 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Use text box for user in analysisContent Hi, I am trying to create analysis that return data for selected reference designator. I succeeded to create analysis that let the user to select reference desig…
-
Single day Entry for each absence durationSummary Single day Entry for each absence durationContent Hi All, We have requirement where we need to fetch all the absences of employees as a single day entry. for exa…
-
Adding 2 date parameters to a reportSummary Report needs to report either by Termination Date Range OR Last Update Date RangeContent I have built a report that has 2 date Ranges on it Change Date From and …User_2025-02-04-08-51-08-912 42 views 1 comment 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Report for all items name + item code + barcode numberSummary Report for all items + item code + barcode numberContent Hello All, I need a report to display the Item Name + Item Code + Barcode Number. I have the below table…User_2025-02-05-12-20-44-163 193 views 1 comment 0 points Most recent by User_2025-02-05-12-20-44-163 Reporting and Analytics for SCM
-
Benefits ReportingSummary Dependent that is an employee OTBI or BIPContent how do we determine that a dependent is an active dependent or a certain plan and an active employee at the same…User_2025-01-28-01-44-03-184 127 views 2 comments 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM
-
Intermittent Error Preventing Report FilteringSummary When applying filters to our Business Unit Column we are intermittently unable to do so when creating OTBI analyses and when using previously created analyses.Co…Thomas Griffiths 24 views 5 comments 0 points Most recent by User_2025-01-30-21-52-52-008 Reporting and Analytics for HCM
-
Free text parameterContent Hi, I have a requirement to include a free text parameter for termination Letter where HR will enter Termination reason in the Parameter while generating the Let…User_2025-02-06-14-37-05-233 28 views 3 comments 1 point Most recent by Sahil_Makhiza Reporting and Analytics for HCM
-
BI Table Name to Fetch Career Development Details (Features,Enable and Selected ChoiceContent Hi Team, Please help to fetch Career Development Details (Feature,Enable,Selected Choice) from the attached screenshot. Thanks Sandip Version 20B (11.13.20.04.0)Sandip Karmakar 33 views 3 comments 0 points Most recent by Sandip Karmakar Reporting and Analytics for HCM -
Get the date of change if a field in BI reportSummary Get the date of change if a field Work from home in BI reportContent Hi, we need to get the date of change if a field Work from home in BI report. Pls find the q…
-
Change column to NumericSummary I want to change a column to numeric so I can add formulas. How would I do so in the SQL?Code Snippet SELECT "Workforce Management - Worker Assignment Real Time"…User_2025-02-06-07-21-22-662 29 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Parent Manager Name FormatContent How to switch format from First Name Last name to Last Name, First name/ Any ideas? Thank you.Mike Borghoff 24 views 10 comments 0 points Most recent by Mike Borghoff Reporting and Analytics for HCM
-
US Affirmative Action ReportingContent Hello, I was wondering if any had report examples that they use for AAP reporting? I have a few job change reports, but none that combine job change values and s…User_2025-01-31-00-25-12-234 133 views 4 comments 1 point Most recent by AlyssiaKing Reporting and Analytics for HCM
-
Department to User Login report helpSummary Adding department to data modelContent Can anyone help add department to this user last login report please? It was built with a data model and I don't know sql.…User_2025-02-05-07-51-01-504 20 views 8 comments 0 points Most recent by User_2025-02-05-07-51-01-504 Reporting and Analytics for HCM
-
Oracle Fusion Cloud Audit Reports - Changes in Static Data (Before and After Values)Summary Audit Reports - Additional Functionality (Before and After Values)Content Hi, My client wishes to have a more detailed Audit Report functionality Currently the A…Stuart Hackney 55 views 2 comments 0 points Most recent by Stuart Hackney Reporting and Analytics for SCM
-
How to get a list of all languages from HRT_CONTENT_ITEMS_TLContent Hi, Under talent profile and language skills - how do I just get a list of all available languages? See they are hiding in HRT_CONTENT_ITEMS_TL but not sure how …King Jack 40 views 1 comment 2 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Performance issue while fetching details from data_cache columnSummary I am facing performance issue while fetching details from data_cache column.Content Hi Team, I am using below query for fetching all kind of approval transaction… -
Remove merged cells from report in reports & analyticsSummary Remove merged cells from report in reports & analyticsContent Hello, Please note that we have a report : Scott Marketing report which has merged columns B & C AN…User_2025-02-05-12-20-44-163 274 views 7 comments 0 points Most recent by Lucky Sharma Reporting and Analytics for SCM