SQL
Discussion List
-
Handling Invalid Dates in a CASE statement in OTBISummary: How do you replace 00--0 with an actual date in OTBI? Getting error with CASE statement below Content (required): My CASE statement is coming back with an error… -
Need the field from the table to use the alternate email for internal cand to build the customBI repSummary: Need the field from the table to use the alternate email for internal candidate to build the custom BI report and i am not able to find this field in IRC_CANDID…
-
Need inputs for 401k Contribution ReportSummary: Need inputs for 401k Contribution Report Content (required): Hi Team Greetings! This is about getting the details for 401k contributions report including deferr…Parag Hiremath 72 views 0 comments 0 points Started by Parag Hiremath Reporting and Analytics for HCM -
report of all list of ESS jobs which are Running more than 24 hrsSummary: report of all list of ESS jobs which are Running more than 24 hrs Content (required): report of all list of ESS jobs which are Running more than 24 hrs Version …Swati U 31 views 2 comments 0 points Most recent by Amol Patil HCM-Oracle Reporting and Analytics for HCM
-
How are users interacting with systemSummary: Content (required): Hello We would like to know how our users are interacting with our system. The ASE_USER_LOGIN_INFO table shows the date of the last login, b…Helen Thomas 41 views 3 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
How to use FND Archive tables to get all HCM Transaction details of WorkflowSummary Need to report, both active , recent completed and histroical Workflow transaction details.Content Hi I am currently using this tables to get Active and recently…User_2025-01-30-23-14-03-928 1.3K views 4 comments 0 points Most recent by User_X6V3T Reporting and Analytics for HCM -
Which table stores the "Assign as" information for initiativeSummary: Hello All, I am trying to build a report to fetch learning initiative details but i am not finding any information regarding the assign as column in the UI.Plea…minati_behera-Oracle 51 views 3 comments 0 points Most recent by minati_behera-Oracle Reporting and Analytics for HCM
-
Need function condition to exclude any character other than numbers and alphabets for address in BISummary: Need function condition to exclude any character other than numbers and alphabets for address in BI Content (required): Address should not have any characters o…
-
Query to extract Mail address Effective start dateSummary: Content (required): Hello experts, please, could you share the SQL query to extract employees effective start date? Thanks in advance for your time! Kind Regard…Valerio Curzi 61 views 9 comments 0 points Most recent by DavidBlake Reporting and Analytics for HCM -
Table and field references for compensation manager hierarchySummary: Content (required): Hello experts, for this compensation campaign we should change the manager hierarchy workflow and we set the primary hierarchy as in the att…Valerio Curzi 62 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Understanding Actual Termination Date and Per_Periods_Of_ServiceSummary: Looking for SQL to pull in an accurate termination date given a point in time. And if that point in time is BEFORE the termination, then the business is wanting…SeanWesche 1.2K views 4 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Audit report For Tax Withholding Calculation cards and table for Association, Federal & RegionalSummary: Need to develop a report that captures any changes made to the employee’s Tax Withholding cards such as Association,Federal, Regional. This report will be run u…User_2025-02-12-00-53-03-661 178 views 2 comments 0 points Most recent by Monika_Dubey Reporting and Analytics for HCM
-
Query to extract Goal Measurement IDSummary: Content (required): Hello experts, as MeasurementId is not available in OTBI analysis, please could you share the query to extract this information? Thanks a lo…Valerio Curzi 23 views 4 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Is it possible to build workforce compensation approval workflow by OTBI or BI?Summary: Hello experts, our customer would like to represent the workforce compensation approval workflow by report. Do you know if it is possible to do it by OTBI or BI…Valerio Curzi 22 views 4 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
SQL Query to retrieve User Status both Active and InactiveSummary: Query to retrieve User Status both Active and Inactive Content (required): Trying to put together a query that will tell which users and how many of those are e…Edwin Martinez 2.7K views 2 comments 0 points Most recent by Edwin Martinez Reporting and Analytics for HCM
-
Function to replace accent characters with respective characterSummary: Function to replace accent characters with respective character ex: O'Brian to O Brian, Noël to be Noel I need something like ascii using which it will directly…
-
Using COUNT function in Excel Template in BI PublisherSummary Using COUNT function in Excel Template in BI PublisherContent Hi All, Can someone please provide an example of how to use the count function in BI Publisher Exce…Aloka Bhattacharya 307 views 2 comments 1 point Most recent by Valeriy Gorbunov Reporting and Analytics for HCM -
Address Validation report for USSummary: Hi, Do you have sample address validation report for US? Thanks, Content (required): Version (include the version you are using, if applicable): Code Snippet (a…
-
Link to the offer in the personalized notificationSummary: Content (required): Good morning everyone, we are developing a package of custom notifications on rtf templates and excel attachments to be provided to a custom…
-
Query to extract the last update author for document record fieldsSummary: Hello experts, please, could you share the query to execute in order to find the author of the last update on document record fields? Thanks in advance for your…Valerio Curzi 13 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Can we have any job process to run HDL(.dat) file which output of BI reportSummary: Can we have any job process to run HDL(.dat) file which is output of BI report Content (required): Can we have any job process to run HDL(.dat) file which is ou…
-
Looking for HDL to upload Calc Cards for bulk employee movements from PT to FTSummary: Looking for HDL to upload Calc Cards for bulk employee movements from PT to FT Content (required): Version (include the version you are using, if applicable): C…
-
BI Publisher - Filter Action NameSummary: I have a SQL query that was created by our vendor. I am still a beginner in using SQL so I am seeking assistance in how to filter the report to pull certain act…
-
SQL for compa ratioSummary: Need correct SQL to find Compa Ratio Content (required): Hello, I am writing a report for the business that includes the compa ratio as one of the columns. And …SeanWesche 54 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Looking for table for salary change action and reasonSummary: Looking for table for salary change action and reason Content (required): Which table holds the salary change reason and action? This is not the same table whic…Parag Hiremath 1.3K views 7 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Report on Salary Change Action and ReasonSummary I'm looking to report on Action and Reason within Manage SalaryContent Using the Compensation - Salary Details Real Time subject area I'm able to pull Action and…User_2025-01-25-00-37-41-739 194 views 6 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Calculation Cards TRUSummary: I would need to get the value of TRU in Calculation Card. I am unable to find the table name. If anyone could help on this, would be really great. Screenshot At…
-
OTBI Hospital Custom TableSummary: Dear All, Where can i find this table is maintained in Oracle system? Thank you Izliana Content (required): Version (include the version you are using, if appli…Izlianas 31 views 1 comment 0 points Most recent by Maria Croitoru-Oracle Reporting and Analytics for HCM -
Is it possible to get the list of all the Data Models using a specific keyword in Dataset SQL?Summary: Is it possible to get the list of all the Data Models using a specific keyword in Dataset SQL? Content (required): Looking for a query that can be used to check…