SQL
Discussion List
-
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 7 views 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 26 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 28 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 15 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 148 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 51 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 57 views 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 17 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
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 70 views 12 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Login In, Login Out and Login Duration of a user in an OTBI analysis.Summary Login In, Login Out and Login Duration of a user in an OTBI analysis.Content Hi, We need to find a subject area that gives the login time of the user into fusion…User_MC37Q 303 views 3 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Bursting - Multiple Templates - Multiple DestinationsSummary: Bursting Query for sending email notifications to an employee and line manager, each with their own template. Content (required): Hello, We have a requirement w…
-
BIP Query to pull unapproved/pending absences from last 10 daysHi Team, Could you please help me with the BIP Query to pull unapproved/pending absences from the last 10 days? It would be great if you can share DM or query for the sa…
-
Performance Issue in OTL BI reportSummary: Performance Issue in OTL report Content (required): We have existing report on OTL which is taking 3-4 minutes for generating data. Is there anyway that we can …Priyanka More-Oracle 16 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Sql query for employment term numberSummary Does someone have a query for the employment term number?Content Hi, I'm really need an sql query for that shows the person number, person f.name, person l.name,…
-
Query to fetch existing and proposed information of pending transaction in oracle hcmSummary: We have a requirement to develop a BIP report to display the existing and proposed information of pending transaction like Promotion. Content (required): Need t…Meenakshi K 600 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI Analysis > Time Displayed IncorrectlySummary: Hello All, I will appreciate your support on the following issue: The Start Time and Stop Time reported from the Time Device Machine are displayed correctly on …Bernard T 29 views 7 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Issue when creating a BI report on Investigation QuestionnairesSummary: When creating an BI report on investigation questionnaires we are running into an issue where it is not possible to limit the investigation questionnaire to the…
-
Issue in weekly schedule Bi report with effective date parameterSummary: Issue in weekly schedule Bi report with effective date parameter Content (required): Hi Team, Recently I was schedule a report which is weakly basis and it cont…
-
Running OTBI based upon the Results of another OTBI getting Error getting Drill InformationSummary: We are trying to base the results of one OTBI analysis off the results of a second OTBI analysis. Both analysis run successfully on their own. However, once con…Denise Izzi 57 views 19 comments 0 points Most recent by Denise Izzi Reporting and Analytics for HCM -
Is there a compensation event real time subject area similar to worker assignment event real time?Summary: Is there a compensation event real time subject area similar to worker assignment event real time? Content (required): We created a report using the worker assi…TerryM01 33 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
HCM OTBI Index ColumnsSummary This workbook documents index columns in HCM OTBI subject areas.Content This document is published by Oracle OTBI Development. Index columns use database index f…User720640-Oracle 330 views 4 comments 10 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Printing details on a single row using a EText Fixed Position TemplateSummary Need help in printing both parent and child XML details in the same rowContent Hi All, Need your suggestions on how to solve the below requirement: 1. Applicatio…Brendon Charles-24581 143 views 8 comments 2 points Most recent by Bhupendra Singh Rawat-Oracle Reporting and Analytics for HCM -
SQL for Costing for ElementsSummary: We are working on SQL to fetch the Element Entry details with costing information. I am finding it difficult to fetch the costing information from the Element E…Mohan Murali 352 views 5 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
P45 filing dateSummary: P45 filing date in OTBI (or SQL code if not in OTBI) Content (required): Does anyone know where in OTBI I can find the P45 filed date (see bottom of screenshot)…
-
Error in SQL created by SQL AssemblerSummary: I get the following error Error generating view. Error getting cursor in GenerateHead in a SQL statement created by SQL Assembler Content (required): I get the …Donna Valentine 51 views 9 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Rtf template special character errorSummary: Content (required): Hello everybody, I was having a problem concerning the extraction of certain data to insert in an rtf template in word. In particular, extra…Gerardo Peluso 49 views 3 comments 0 points Most recent by MilanMohanty Reporting and Analytics for HCM
-
Positions Filled in less than # daysSummary: Need to track positions filled that took less than/more than 60 days to fill. Content (required): I need to find a way to not only track the # of positions fill…Scott Conaway 17 views 1 comment 0 points Most recent by Ellen Manthei Reporting and Analytics for HCM
-
Locate Job Requisition Submissions Questionnaire ResponsesSummary: Hi all, I am attempting to write a BI report that will show an applicants response to a specific question asked during the job application submission. Can you p… -
How can I query uploaded learning content?Summary: Is there an easy way in BIP to query learning content title and file name? In my particular case they have been batch uploaded via REST API, but I don't think t…