SQL
Discussion List
-
Learning Evaluations ReportSummary Genarating a report with Learning Assessment and evaluationContent Hello Team, I need a bi report for learning assessment and evaluations. I am done with the ass…Aditya Srivastava-Oracle 222 views 2 comments 2 points Most recent by Raymund Jerome Reporting and Analytics for HCM -
Report on Absence AttachmentSummary: Report on Absence Attachment. Is it possible to create a Report which will say who has attachment on Absence Content (required): Hi Experts, Is it possible to d… -
Accessing the content server data in BIPContent Is there a way by which we can access the content server data in BIP data model. We want to place certain number of person id in a csv file in content server and… -
Sample BI workforce compensation notificationSummary: Hello experts, do you have some examples of BI workforce compensation notification to share? In particular, we need Worksheet Overridden by Another Manager BI n… -
restrict salary report by security profileSummary: We created a security profile for salary access based on department hierarchy (secured by aor) and assigned this security profile to specific custom roles. In t… -
How can I Embed Links within BI Publisher Interactive View?Summary: How can I Embed Links within BI Publisher Interactive View? Content (required): Hi all, I have created a BI publisher data model that includes an html formatted… -
BIP Report Bursting - Need to split a large file into multiple small filesSummary: Need to split a large file into multiple small files Content (required): We developed few reports to send data to 3rd party systems. For the initial run, these …
-
I need to prepare pension payover report for Uk legislation in BIPSummary: Condition for this Report is that Employees should not come in Report during opt-out period end date and after opt-out end date employees Employee Contribution …Tiw.Jyotsna-Oracle 1 view 0 comments 0 points Started by Tiw.Jyotsna-Oracle Reporting and Analytics for HCM
-
How to create a printable report?Summary: Content (required): Hello everyone, We are trying to understand what are the needed steps to give the opportunity to the users to print the performance report. …Agapi 22 views 3 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM -
Difference between SQL Data Sources?Summary: Content (required): Hello everyone, We are trying to create a new Data Model for Performance Management in HCM by using an SQL Query. However, we are not sure w…Agapi 52 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Double Column PromptSummary Can we do double column prompt in OTBI like we can in data model?Content In data models, we can create double column LOV similar to... select description, id fro…User_2025-01-22-18-30-18-571 39 views 5 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Query to Fetch withdrawn assignments in LearningSummary: I am trying to fetch the learners who got withdrawn from the courses in Learning. Content (required): We discover that thousands of learning assignment records …Thulasi Ram 73 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Table to pull the Highest Education Level in BIPSummary: Need to determine the table that retrieves the Highest Education Level under Person details Content (required): Version (include the version you are using, if a…RenzelkeithCoquia 773 views 2 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Audit log or report for configuration changes to the systemSummary: Is there a report or change log that can be obtained from system on application configuration changes ? Does anyone know of an audit log or report for configura…MilanMohanty 714 views 4 comments 2 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Query to get statement of earningsSummary: Can someone share query to get all the balances on statement of earnings screen along with its element and values. I wrote a where I am getting the expected val…Jaeyshree Kumaran Kalpana 499 views 1 comment 0 points Most recent by MilanMohanty Reporting and Analytics for HCM
-
How to obtain Source System ID for absence entriesSummary: Content (required): I have a requirement to use HDL to delete and then re-submit a large quantity of annual leave absence entries. I have an HDL file that I can…
-
Unable to find the USER_GUID for few employees in ASE_PWD_RESET_REQ tableSummary: Hi All, We have a report which we send to the new hired employee. In the email, we are sending the password reset link as well. For some of the employees the da…Peeyush Chandel 26 views 0 comments 0 points Started by Peeyush Chandel Reporting and Analytics for HCM -
Create Temporary Table or View for complex agreement templateSummary: Seeking advice regarding BI publisher capabilities to create temporary data tables. Content (required): Hi team, I am seeking advice as to whether it is possibl…
-
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 3.7K views 1 comment 0 points Most recent by Nagaraju Godasi Reporting and Analytics for HCM
-
Sql Query to Fetch the Last Modification Date and Last Modified By Details of SSOSummary: Can any one please help with a sql query to get the last modification date, last modified by, Created by details for SSO configuration. Content (required): Vers…MilanMohanty 277 views 2 comments 0 points Most recent by MilanMohanty Reporting and Analytics for HCM
-
Embed bursting report content in body of email?Summary: Embed bursting report content in body of email? Content (required): Hi all, Hoping someone can advise if it is possible to embed report content within the body …Luke.Findex 51 views 3 comments 0 points Most recent by Aaron Hager Associated Bank Reporting and Analytics for HCM
-
How to query if a pending worker to EMP was converted with manual or auto conversion?Summary: Is there a query to determine how a pending worker was converted to EMP (ex: "include in auto conversion" or "quick convert")? Content (required): Is there a qu…Jessica DiCerbo 628 views 2 comments 0 points Most recent by Jessica DiCerbo Reporting and Analytics for HCM -
Need a table or Query to get the IRS Limit values for 401K elements in PayrollSummary Need a table or Query to get the IRS Limit values for 401K elements in PayrollContent Hi Team, Need a table or Query to get the IRS Limit values for 401K element…User_2025-02-04-07-00-18-658 66 views 2 comments 0 points Most recent by Raghavendra M Reporting and Analytics for HCM
-
Careers of Interest - ReportHi, Anyone has sample report for "Careers of Interest" which comes under development goals? Or can anyone help me with the tables? Regards, NivyaNivya Mathire 32 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Report on Temporary Global TransferHello Is it possible to report on the field 'When do you expect the new work relationship to end?' available on Temporary Global Transfer through OTBI?
-
New user account password reset statusSummary: Is there a way to fetch the new user account details if the password was reset successfully or not? Content (required): As part of Onboarding process, user acco…
-
Below code only getting only for India data and remaining country Not comingSummary: Hi Team, we have code but only coming data for one country. Could you please help on where i need enhance to get all other countries data also. Thanks Content (…AjayKumar Maddipati 31 views 7 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
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…
-
DD-MON-YYYY format is not workingSummary: We have a requirement to display the date format as "DD-MON-YYYY'. Ex. 14-FEB-2025. We are using RTF Template. In the query I am not doing any kind of formattin…
-
Fetching Data from the Legal Entity DFFSummary: Content (required): Hello experts, We've run into a bit of an odd issue, and was looking out for any advice. We've written a snippet of code to fetch the ATTRIB…