SQL
Discussion List
-
Leave Balance Calculation date showing different than UI in BIP reportSummary: Hi Team, Leave Balance Caluclation date showing diffrent than UI in BIP report Content (required): Version (include the version you are using, if applicable): C…AjayKumar Maddipati 43 views 16 comments 0 points Most recent by MilanMohanty Reporting and Analytics for HCM -
Select Max (Last Update Date) from "FUSION"."IRC_JA_EXTRA_INFO"Summary: Calling all SQL Experts: Trying to select the most current record (based upon last_updated_date field) from table "FUSION"."IRC_JA_EXTRA_INFO" in a data model. …Denise Izzi 162 views 7 comments 0 points Most recent by Denise Izzi Reporting and Analytics for HCM -
When we apply filter below for particular process not working on pending transactions reportSummary: Hi Team, we have developed pending transactions report in that all process are coming like change manger,'Resignation', location, and etc but we need only Resig…AjayKumar Maddipati 31 views 2 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
How do you join WLF_ATTACHED_DOCUMENTS with other learn tables of coure? For example WLF_LEARNING_ITSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Bhasha Desai 11 views 2 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Leave Balance showing incorrect IN Custom BIP reportSummary: Hi Team, Some of emplyoees showing incorrect leave balance that zero and some of have showing corret value . Could you please assit on ? Thanks AJAY Content (re…AjayKumar Maddipati 22 views 6 comments 0 points Most recent by MilanMohanty Reporting and Analytics for HCM
-
Table for Public Info (Me-> Directory-> My Public Info)Summary: We need to fetch the representatives information for an employee. I have tried with PER_ASG_RESPONSIBILITIES but unable to find the information. Please guide me…
-
in my below only getting for india data and one processSummary: Hi sir, for above query with out put country parameter or process name parameter only geting india and regination process ? when i scedule the report but i seei…AjayKumar Maddipati 1 view 1 comment 0 points Most recent by MilanMohanty Reporting and Analytics for HCM
-
How can I exctract Work Terms Number field in OTBI?Summary: Content (required): Hello experts, I need to extract in some way the Work Term Number field to update employee managers by HDL. Is it possible to find this fiel…Valerio Curzi 451 views 14 comments 1 point Most recent by Girish Singh-Oracle Reporting and Analytics for HCM -
What is the Table that stores Oraganization EFF details.Summary: What is the Table that stores Oraganization EFF details. Content (required): What is the Table that stores Oraganization EFF details. Version (include the versi…User_2025-02-12-17-19-33-738 11 views 2 comments 0 points Most recent by User_2025-02-12-17-19-33-738 Reporting and Analytics for HCM -
when we using full name column, we are missing the middle name of employee any another column ?Summary: Hi Team, when we using full name column, we are missing the middle name of employee but when we try to using first name , middle name, last name but it is takin…AjayKumar Maddipati 31 views 3 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
Active Profile QuerySummary: Looking for help on how to build a query that checks for active profiles within different environments Content (required): Hi all, I'm looking to see if anyone …
-
Is there a way for an Analysis to retrieve the results of a data model?Content Hi, I currently have a data model but I need its results to get displayed via OTBI. Any way to achieve that? Thanks, IsaacICO 27 views 10 comments 2 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
Only issue with one person number of the querySummary: HI Team, for below working fine but coming to one person number not getting the data. below error coming error:Data_das Could u please assist on this.@Mandeep G…AjayKumar Maddipati 51 views 5 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
How to get multiple value from table in Array format in Oracle BISummary: How can get Multiple value for the same data in Array format in one single row Content (required): Get the value in Array format in oracle need sql query Versio…
-
How to change date format in 30-06-2022 to 30-June-2022Summary: Hi Team, we have developed date as of now 30-06-2022 but business wants this format 30-June-2022. to_char(CURRENT_DATE,'DD-MM-YYYY'), -- 30-06-2022 May I know t…AjayKumar Maddipati 21 views 4 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
Filter to pull employees with anniversaries in the following monthSummary We need to build a report that is emailed monthly and pulls any employees that have service anniversaries in the following monthContent We need to create a repor… -
Table/Views required which contains all the created data model ,report/analysis in the instanceSummary: Hi, I need table/view name which contains all the data model, report, analysis information created in the system and all the fields which are being used by that… -
Employees Performance goal BI report not showing properly in excel outputSummary Employees Performance goal BI report not showing properly in excel outputContent Hi , We have requirement to create bi reports to fetch the below goal columns fo…nitin Sharma 24 views 3 comments 0 points Most recent by User_2025-02-11-22-13-57-078 Reporting and Analytics for HCM
-
Report on Structure (Quick Actions, Apps) with default seeded Expression Languages from Vanilla versSummary OTBI Report on Structure (Quick Actions, Apps) with default seeded Expression Languages from Vanilla version as old value and new value as custom expression lang… -
Reusable Data Model SQL QueriesSummary: Reusable Data Model SQL Queries Content (required): Hi Team, Greetings! Does any have Reusable Data Model SQL Queries for HCM modules (HR, Payroll , Benefits, O…Parag Hiremath 21 views 1 comment 1 point Most recent by Andrew_Schmitz Reporting and Analytics for HCM -
Event Triggers in Data ModelSummary: Can someone explain how to use the event triggers in the Data Model Content (required): Can someone explain how to use the event triggers in the Data Model Vers…Mark kristan De los Reyes 11 views 1 comment 0 points Most recent by Jbgood Reporting and Analytics for HCM -
Reusable Data Model SQL QueriesSummary: Reusable Data Model SQL Queries Content (required): Hi Team, Greetings! Does any have Reusable Data Model SQL Queries for HCM modules (HR, Payroll , Benefits, O…Parag Hiremath 92 views 0 comments 0 points Started by Parag Hiremath Reporting and Analytics for HCM
-
Query to Display the employee and the supervisor chain bottom upSummary: Does someone have a query for the employment and Supervisor/Manager hierarchy ? Content (required): Hello , I have very little experience in HCM tables, hence I…Cesar Saveedra 2.9K views 5 comments 0 points Most recent by Cesar Saveedra Reporting and Analytics for HCM
-
BI Publisher versionSummary: Need inputs to find the BI Publisher version in Fusion. Content (required): Need steps/sql query to find the BI Publisher version in Fusion. Version (include th…
-
Incorrectly formatted phone number in OTBI tableSummary: Content (required): Hello! I have noticed a situation in our Fusion tables that I'm curious about resolving. We are currently seeing two phone numbers for two d… -
Narrow Chart Down to Top 10Summary: We are trying to create a bar graph of the top 10 jobs that termed for the year. Is there a way to only show the top 10 rather than all the jobs?Rebekah Gilday 11 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Termination Bar Chart by MonthSummary: We are trying to make a Bar Chart to show # of term by Calendar Month but the format of the month looks strange. Is there a way to list Calendar month with name…Rebekah Gilday 1 view 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Last Day of the Previous Month Active HeadcountSummary: SQL for Period Start Active Headcount minus 24 hours Content: We are looking for a SQL formula that takes the delivered measure Period Start Active Headcount mi…Rebekah Gilday 21 views 2 comments 0 points Most recent by Rebekah Gilday Reporting and Analytics for HCM
-
Query to extract ExternalWorkerDataId by Start/End Date and Person NumberSummary: Hello experts, I should update external worker data. However, ExternalWorkerDataId information is not available in OTBI analysis. Is there a query available to …Valerio Curzi 21 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Talent Score - deep link in BIPSummary: Does anyone know if you can deep link from BIP to the Talent Score screen? I think it is here: My Team > Career and Performance path, page titled “Goals and Per…Andrew_Schmitz 11 views 0 comments 0 points Started by Andrew_Schmitz Reporting and Analytics for HCM