SQL
Discussion List
-
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…Andrew-180341 76 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 421 views 1 comment 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Could not find the lookup HRC_TRANSACTION_STATUSSummary Could not find the lookup HRC_TRANSACTION_STATUSContent Hi Experts, As a part of pulling the Approval Transaction Details, I have used the table HRC_TXN_DATA. Th…Charan Kollipara 60 views 3 comments 0 points Most recent by Seiichiro Yasui Reporting and Analytics for HCM
-
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 …PamS 42 views 1 comment 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
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…Rosiel Cristobal-39176 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_HF4N3 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…JYOTI MAURYA 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 34 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…Nicola Petri 19 views 4 comments 0 points Most recent by Karen Costakes Reporting and Analytics for HCM
-
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"…David Nguyen-188124 30 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…Matthew Voss 126 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.…
-
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 43 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…
-
Manager_type = Timecard_Approver in OTBISummary Manager_type = Timecard_Approver in OTBIContent Hi ALL, In OTBI when I see "Manager Type" ( "Workforce Management - Worker Assignment Real Time"."Worker"."Manage…Vijay_Ahire 36 views 7 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Unable To Export To CSVSummary Enable CSV is enabled in the data model, but am not able to export to CSV.Content We have an existing report that the business would like to be able to export to…Matt Isaacs 57 views 3 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Shared mailing addressesSummary Require a report to show employees that have the same mailing addressContent Is it possible to generate a report that shows 2 employees residing at the same addr…
-
Instance name - TableSummary Instance name - TableContent Hi Team, I want to know the Instance details available table or DBI or UE. We are using email options in the extract to send the out…User_4VVG2 42 views 2 comments 1 point Most recent by Sricharan Monigari Reporting and Analytics for HCM
-
Deriving column value based in ROLE.Summary Deriving column value based in ROLE.Content Hi All, Need HELP I'm creating report in OTBI and in report there is field call"Is Manager" and logic for this field …Vijay_Ahire 16 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
BI Table Name to fetch Data Type under Column Assignment of Global SegmentContent Hi Team, I am trying to fetch Data Type under Column Assignment of the Global Segment Details. Please let me know the backend table name which stores that. Thank…Sandip Karmakar 34 views 2 comments 1 point Most recent by Sricharan Monigari Reporting and Analytics for HCM
-
Need tables in fusion that store the Salary Details and Salary Component Breakup detailsSummary Need tables in fusion that store the Salary Details and Salary Component Breakup detailsContent Hi, Can anyone please provide me the table names that store the s…User_MC37Q 122 views 8 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
HCM BI Report - table to extract value set data (table type)Summary HCM BI Report - table to extract value set definition (table type)Content Hi, I'm creating a BI report to show Value Set Definition (Table Type) and wonder which…
-
Deriving IS Manager column in OTBISummary Deriving IS Manager column in OTBIContent Hi ALL, I'm building OTBI Report. And I want to derive column "IS MANAGER" ( Note we are not maintaining in WorkerAssig…
-
How to get SalaryId information from ReportingContent Hello experts, I have noticed that in Compensation subject areas I cannot retrieve the SalaryId information. I need this information to massively correct Salary …Valerio Curzi 37 views 1 comment 2 points Most recent by Sricharan Monigari Reporting and Analytics for HCM
-
Reporting on Active User Role EmailSummary Email address for non-employee active user.Content Hi, I am developing a BIP report for Non-Employee Active User. But cannot find the table email address that wa…