SQL
Discussion List
-
Query to extract the list of available Locations based on the Legal EntitySummary: Content (required): Hello experts, is it possible to build a SQL query to retrieve the list of applicable locations based on the legal entity? Thanks in advance…Valerio Curzi 705 views 7 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
need a payroll element costing reportSummary: Need to write a payroll element costing report that includes highlighted information from picture below Content (required): need a report that shows all the inf…Bernadette Dorris 150 views 6 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Etext Report output is not coming correctly.Summary: Hi Everyone. I am trying to create a etext report in the HDL format, EDI(delimited type). When i view the report, instead of getting the output value, i am gett…ShawShankk 114 views 11 comments 1 point Most recent by Ankam Vasantha Reporting and Analytics for HCM
-
Oracle BI tables to retrieve Talent RatingsSummary: Content (please ensure you mask any confidential information): Hello experts, which tables allows to extract Talent Ratings as that one attached? Thanks in adva…Valerio Curzi 11 views 1 comment 0 points Most recent by Joe Dorrian Reporting and Analytics for HCM
-
Report to find employees without any presentative (AoR HRBP)Summary: Hi, I'd like to create a report to find if any employees haven't been assigned to any HR Business Partner with an AoR. Do you know if this is feasible and how t…Alberto Americi 42 views 5 comments 0 points Most recent by Alberto Americi Reporting and Analytics for HCM
-
Need query to get who submitted resignation in last 24hourswe have a requirement to get the report of employees who submitted resignation. Can anyone share me the query to get employees data or atleast how can we get data of emp…Dara Nagasai 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to fetch PREVIOUS Grade and Grade Step using BIP?I need to pull the latest previous Grade/Grade Step in a single row because we don't need to back track all the changes on their Grade/Grade Step. How to construct the B… -
How to report on Owner Person Email in Workforce Management - Checklist Real Time subject areaSummary: Content (please ensure you mask any confidential information): We are building an OTBI report to display Journey tasks metrics using the Workforce Management - …Giuseppe Cannova 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to cancel double row in changes BIP report?I have a BI PUBLISHER report that shows changes in addresses and marital status of an employee. I use the table HRC_EVT_OBJ_CHANGE_COMPONENTS, The problem is that it sho…Alex_Balanovsky 12 views 1 comment 0 points Most recent by User_4XX09 Reporting and Analytics for HCM
-
Is there any way to get all BI folder level permission details via report?Hi Team, I have a requirement to fetch details of folder level permissions set on each folder in BI catalog. I see different roles/users have different level of access o…Narula Shray 324 views 5 comments 0 points Most recent by Narula Shray Reporting and Analytics for HCM
-
BIP Schedule ReportSummary: BIP Schedule Report Content (please ensure you mask any confidential information): Hi Team, Greetings! There are multiple BIP Reports scheduled at the different…Parag Hiremath 51 views 5 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM -
3rd Substring from a Field in OTBISummary: Need 3rd Substring from "Job"."Job Name" Content (please ensure you mask any confidential information): I have "Job"."Job Name" field and the data looks like "U…Pradnya_Pampatwar 5 views 2 comments 0 points Most recent by Pradnya_Pampatwar Reporting and Analytics for HCM
-
OBIEE Data Model Error: ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actuSummary Data Model Error: ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual: 5389, maximum: 4000)Content Hi, I am trying to create a data mo… -
Tables to fetch queries used in DataModelsSummary: Hello Team, Is there any specific tables that are being used to fetch queries used in Data Models? Is there any way to achieve this? Thanks, Paramesh Content (p…Kurva Paramesh 21 views 3 comments 0 points Most recent by Kurva Paramesh Reporting and Analytics for HCM
-
Need 2 Date Fields having Case or Filter functionality in OTBI ReportSummary: Interim Review Date ("Performance Document"."Performance Document Period Name" like '%Interim%') and Final Review Date ("Performance Document"."Performance Docu…Pradnya_Pampatwar 43 views 9 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
BIP report or data model for fetching the data of all the employees with their Hire date, terminatioSummary Can anyone help me with BIP report or data model for fetching the data of all the employees with their Hire date, termination date, rehire date along with depart…User_2025-01-29-01-34-30-592 193 views 2 comments 0 points Most recent by Becki Willard Reporting and Analytics for HCM -
Help with Query optimization - Sum of Payroll Balance DimensionSummary: Only months into our post-implementation and our pension report query is consistently timing out. I believe I have narrowed down the offending portion of the da… -
Secured List Views: For any information related to SLVs please raise a Service RequestSummary: I raised an SR some days ago asking for some additional information on Secured List Views (as instructed by Doc ID 2708546.1). I got this response: Your questio… -
how to read webcenter files using python script and extract informationcan we read the files which we uploaded through bi reports bursting into webcenter servers. while i'm the downloading the files in the webcenters they are not readable.Dara Nagasai 11 views 3 comments 0 points Most recent by Aaron Leggett Reporting and Analytics for HCM
-
is there a way to get data from tables?Apologies for the basic question but is there a way to get data from the Geog Trees, calendar events, work patterns and work schedules please? This is from the backgroun… -
BIP report to fetch employees that are included in Automated Grade Step ProgressionSummary: Other than GSP_ELIGIBILITY_FLAG from PER_ALL_ASSIGNMENTS_M, is there any tables which can identify employees that are included in Automated Grade Step Progressi…
-
excel output, splitd linesSummary: Content (please ensure you mask any confidential information): HI team, I have a report that one of the field is HTML with new lines, the problm starts where I …Hadassah Friedman 26 views 3 comments 0 points Most recent by Hadassah Friedman Reporting and Analytics for HCM
-
Requirement to have a report that provides details of changes made to UDTSummary: We have a requirement to have a report that provides details of changes made to User defined tables. can anyone please help us on this requirement? Content (ple…Jagadesh S 21 views 2 comments 0 points Most recent by Satyabrata Nanda Reporting and Analytics for HCM
-
Bringing the latest record of the person instead of all records in the OTBI reportHi, I have an Analysis report that contains employee background information, and an employee may log in and leave work more than once, and all records of this person com…Cansel Karasoy 42 views 10 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
SQL to get current and proposed assignment DFF values for notifiationSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Krishna Manoj-Oracle 34 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Worksheet Proration ReportSummary: Worksheet Proration Report Content (please ensure you mask any confidential information): Hi All, Greetings! This is about the reporting requirement including c…Parag Hiremath 11 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to use a dashboard prompt in Case When query for a fieldSummary: Content (please ensure you mask any confidential information): We have a custom field in OTBI report that uses Person Number as a prompt on a dashboard. Below i…Giuseppe Cannova 32 views 1 comment 0 points Most recent by Giuseppe Cannova Reporting and Analytics for HCM
-
Is it possible to authorize manager-based reports?We added the SQL reports we prepared to the spring board screen and we want to make an authorization here. But is it possible to make it manager-based rather than person…Cansel Karasoy 11 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How do we track bypass Approval Rules - Bypass TrackingSummary: Need Audit record of Approval Rules - Bypass Tracking Content (required): Hi Team, We got a requirement from customer that we need to get the Audit details when…ankit.j.kumar-Oracle 122 views 2 comments 1 point Most recent by Sowdha Murugan Reporting and Analytics for HCM
-
How to get "Person Type" and Assignment Details from Fusion TablesSummary: Hi All, We are seeing a difference between the "Users license Usage" numbers in the Usage reports for HCM Base cloud Licenses and number of "actual user report …