SQL
Discussion List
-
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 43 views 0 comments 0 points Started by Peeyush Chandel Reporting and Analytics for HCM -
How to schedule a job which will autogenerate a report on monthly basisSummary: We have a business requirement where we need to create a job that will automatically schedule and fetch the data from previous month on the first week of every …Gauri Lande 41 views 1 comment 1 point Most recent by Raghavan p-Oracle Reporting and Analytics for SCM -
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.9K 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 271 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 676 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 64 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 41 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 -
On Boarding e-signature forms?Summary: I am creating e-signature form report that report path should should attach the UI LEVEL Content (required): as of now i have created e-signature report that re…
-
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…
-
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 51 views 16 comments 0 points Most recent by MilanMohanty Reporting and Analytics for HCM
-
Why the Fast formula pick up only primary phones?Summary: Hello, we have the following FF that pickup only the primary phones (we understand it launching the extract). How to pickup all the phones without the constrain…
-
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 194 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 21 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 530 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