SQL
Discussion List
-
Employee number along with Candidate numberSummary: Hi, My requirement is to extract Employee details like employee number, name etc. from Core HCM along with Candidate Number, Requisition Number etc. from ORC in… -
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 16 views 3 comments 0 points Most recent by Banashri Biswas 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 …
-
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 4 views 1 comment 0 points 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 3 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 2 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 11 views 5 comments 0 points Most recent by Cesar Saveedra Reporting and Analytics for HCM
-
ODBC Error - ADFService11g on OTBI AnalysisSummary: After 22B went into our Test environment, a report built on a few subject areas no longer works. It is giving us the following error: State: HY000. Code: 77031.…HROps17 17 views 1 comment 0 points Most recent by Julian Challenger-Oracle 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 1 view 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 11 views 2 comments 0 points Most recent by Rebekah Gilday Reporting and Analytics for HCM
-
How to use Listagg functionality in OTBI AnalysisSummary Listagg in OTBI reportsContent Hi Team, Listagg function in OBIEE reports is used to display multiple lov's in a a single row with (,)separator. How can we achie…Kalyani Koylada 36 views 4 comments 0 points Most recent by Ruby Hui Reporting and Analytics for HCM
-
SQL Query to fetch SOE balances and elements.Summary: Hi all, I am working on a BIP report where I need to fetch all balances , earnings and deductions elements name along with it's value whatever is present in the…
-
Transpose rows to columns in OTBISummary I need to build a report that shows every employee as a column. Convert all rows to Columns in OTBIContent Hi I hope you can help me. I need to build a report th…Rogelio Hernandez Vela 46 views 3 comments 1 point Most recent by ManjuPLM 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 1 view 2 comments 0 points Most recent by Gail Langendorf-Oracle 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 1 view 10 comments 0 points Most recent by Julian Challenger-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 3 views 0 comments 0 points Started by Andrew_Schmitz Reporting and Analytics for HCM
-
How to get data in 2 fields for Payroll Relationship -> 'Time Card Required' ?Summary: There are two fields for 'Time Card Required' on the Payroll Relationship responsive page. One is at the Payroll Association level and other at Payroll Assignme…Vinay Hardas 11 views 4 comments 0 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM
-
Need help to build the sql logicSummary: Hi Team, I am working on a requirement for position incumbent. Here my code will get each positon with vacant positon details. And for each position one record …Mohan Murali 22 views 3 comments 0 points Most recent by Mohan Murali Reporting and Analytics for HCM
-
OTBI export to excel and lost data.Summary: Content (required): Hello everyone, I wanted to ask you if you could provide us with more information or if it has also happened to you regarding the loss of da…Gerardo Peluso 1 view 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Logical SQL Dashboard Not Working After 22BSummary: Hi - we have a report that pulls payroll information and salary information. It is run weekly by our compensation team. It was working fine through last week an…Kyle Norris 11 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Send automatic birthday wishes to employees via mail from organization.Summary: Send automatic birthday wishes to employees via mail from organization. Content (required): Hello All, I have a requirement, need to send automatic birthday wis…
-
Difference between data table join.Summary: Difference between data table join. Content (required): Hello All, I have some confusion on table joins. Please refer below example. I have two data tables. PER…
-
Logical SQL is not recommended?Summary If Logical SQL isn't the answer what is the recommended approach?Content Hello Everyone, I've been told through a recent Technical SR that Logical SQL is not a r…Rob F 36 views 12 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Need table name to fetch 'Plan Period Start Date' in the 'Accrual Plan Balance' Screen.Summary: Dear Experts, Which table stores the 'Plan Period Start Date' in the 'Accrual Plan Balance' Screen. Please find the attached Screenshot for your reference. Than…
-
Looking for a sql query to get the absence plan and corresponding element name associatedSummary: Hi, We have a requirement to get the data of the Absence Plan and corresponding element data using the sql. If anyone has come across such requirement then plea…Peeyush Chandel 14 views 0 comments 0 points Started by Peeyush Chandel Reporting and Analytics for HCM