SQL
Discussion List
-
BI Publisher GUI Outer Join QueryContent Hi, We have created a query which is comprised of 3 data sets.They are joined by the elements within the data models. Background: We used to have this pending ap…User_KOLMZ 36 views 3 comments 0 points Most recent by User_2025-01-22-18-30-18-571 Reporting and Analytics for HCM -
Percentage of columnSummary Need to calculate a percentage off Median salary by various attributesContent Attached sample. I can get the first 4 columns. However, I can't come up with the r…Mike Borghoff 59 views 8 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Calculations - level downContent I need to build three charts that hinge off one another: 1. Average or Median salary by Gender/BU/Management level. 2. From the chart above, I need to just get a…Mike Borghoff 41 views 1 comment 0 points Most recent by Aaron Leggett Reporting and Analytics for HCM
-
BIP report and sql injectionContent Hello Experts, While creating BIP reports in the Oracle fusion environment , do we need to consider Sql injection? If we have a BIP report that takes input value…User_2025-01-30-00-14-06-021 78 views 2 comments 2 points Most recent by User_2025-01-22-18-30-18-571 Reporting and Analytics for HCM -
OTBI - Manager person number as the main keySummary Is it possible to refer the manager person number as the primary key in OTBIContent Hi, Can I make a report in OTBI so all the fields (assignment status, job, de…Yaniv 66 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
BIP Report to view the UCM file and its contentsSummary BIP Report to view the UCM file and its contentsContent Hello, In PROD we can't give UCM access to developers due to SOX compliance. Is there any way we can acce… -
HR_LOOKUPS vs HCM_LOOKUPS ViewSummary Need to know the difference between HR Lookup and HCM Lookup viewContent Can anyone let me know the difference between HR Lookup and HCM Lookup view. From view S…Parthiban Vaithiyanathan 189 views 1 comment 0 points Most recent by Janardhana K Reporting and Analytics for HCM
-
BI Publisher model to find stuck transactions in HCMSummary Has anyone a data model that will find stuck transactions within the HCM moduleContent Has anyone developed a data model that will find all of the stuck transact… -
Audit Report using BIPSummary Looking for a custom BIP report query for Audit purpose. #AuditContent Hi, We enabled the Audit for multiple products using the task 'Manage Audit Policies' and …MadhuVitta 240 views 2 comments 0 points Most recent by Janardhana K Reporting and Analytics for HCM
-
Error when consulting a report with parameters of start date and end dateSummary Error when consulting a report with parameters of start date and end dateContent Hi everyone, I have created a report that must show information according to two…Cesar Tepetla Corte 20 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
TopicSummary Ora TestContent Testing topic commVictor Modoran 30 views 1 comment 0 points Most recent by Mihai Uruc Reporting and Analytics for HCM
-
Drill back using SQL query from GL_JE_LINES to PAY_COSTS tableContent We are building a report to get the related Pay Cost data from the GL Journals that gets created after transferred to GL. We have few documents for EBS which men…Satish Kumar-21650 44 views 0 comments 0 points Most recent by Satish Kumar-21650 Reporting and Analytics for HCM -
SQL to get Level 1,2,3,4... for an employee?Content What is the SQL (Not analysis) to get the different department levels for an employee? -
Using Max function for bank account highest process orderSummary Issue with using MAX for selecting highest processing order (Priority) within PAY_PERSON_PAY_METHODS_FContent Hi, We are setting up an extract of bank accounts w…User_2025-01-30-03-54-32-528 47 views 7 comments 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
probation confirmation Letter automation in oracle fusion HCMSummary Probation Confirmation letter Automation in Oracle fusion HCMContent Hi Team, I have to create the bursting report, in which whenever probation status for an emp…nitin Sharma 565 views 2 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Significance of default Data Source 'AuditDB' in BI PublisherContent Hello What is the Significance of default Data Source 'AuditDB' in BI Publisher while creating the new data set. My Oracle Cloud Application is: 19A (11.13.19.01…Janardhana K 20 views 6 comments 1 point Most recent by Janardhana K Reporting and Analytics for HCM -
Row disappearing in the output of RTF when the XML group tag is not thereContent Hi All, I have built one RTF template and have 5 fixed absence plans. If any of the plans is not there then the row is not appearing in the output file. My requi… -
FTE based on Processed HoursContent Hi All, I'm trying to get an FTE number for each department based on actual hours entered in processed time cards. It works fine for my nonexempt population who …
-
Performance Document each task statusContent Hi All, We need to display Task Status in each level of the Performance Document in BIP (BI Publisher). For ex: We have different task flows like Worker Self-eva…Visu 249 views 8 comments 0 points Most recent by User_2025-01-30-23-22-56-745 Reporting and Analytics for HCM
-
BI Report - Performance Management, Task Name for Employee/Manager RoleSummary BI Report - Performance Management, Task Name for Employee/Manager RoleContent Hi, I'm currently developing BI Report using SQL query in HCM Cloud. User requeste…Suyoung 138 views 6 comments 1 point Most recent by User_2025-01-30-23-22-56-745 Reporting and Analytics for HCM
-
Date Issue in Oracle fusion HCM BIP Excel templateSummary Date Issue in Oracle fusion HCM BIP Excel templateContent Hi All, We have created new report to get employee nominee details using Excel Template. Report Output …User_2025-02-01-06-07-07-886 48 views 11 comments 0 points Most recent by User_2025-02-01-06-07-07-886 Reporting and Analytics for HCM
-
Audit Table InformationSummary Audit Table Information - AUDIT_CHANGE_BIT_MAP_Content Hi, Our business requirement is to do an Audit on the changed attributes. So as per Doc ID 1923367.1, we e…Sivakumaran Muthusamy-Oracle 276 views 3 comments 2 points Most recent by Janardhana K Reporting and Analytics for HCM -
Manager hierarchy not updatingSummary Manager changes aren't updating in the flattened hierarchy table despite the scheduled process running successfullyContent Since upgrading to 19A a couple weeks …User_2025-01-25-02-35-56-629 192 views 7 comments 2 points Most recent by User_2025-01-25-02-35-56-629 Reporting and Analytics for HCM
-
create Graphs from an "analysis from simple logical sql"Summary I have a report created using "analysis from simple logical sql", and I wnat to add some graphsContent Hi, I hope you are doing well. I have created a report usi…Rogelio H 51 views 4 comments 1 point Most recent by Caroline Gladwin-Oracle Reporting and Analytics for HCM
-
Time and Labor OTBI Report ErrorSummary Time and Labor OTBI Report ErrorContent Hi All, I am attempting to create my first Time and Labor report in OTBI. I am currently using the subject aread Human Re…Clara 156 views 7 comments 0 points Most recent by Vibha Pandey - Oracle Reporting and Analytics for HCM
-
BPM Transaction Report (R13) StruggleSummary Making use of the SOAINFRA tables to replace HRC_TXN_HEADER_archive and HRC_TXN_data_archiveContent Greetings Everyone, Hope you are all well :) Since we are upg…User_2025-01-30-02-36-54-478 98 views 5 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM
-
BI report to get changes made in both update and correct mode in HCMSummary Hi all, i just want to know is it possible to build changes report in BI that can pull both corrected and updated values.User_2025-02-04-16-34-56-920 59 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Reporting on employee's contacts' phone numbersSummary User unable to report on employee's contacts' phone numbers, even though they have access to the fieldContent Hello Experts! One of our HR reps is unable to repo…User_2025-01-29-23-59-58-976 148 views 17 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Is it possible to insert SQL into OTBI reports to pull correct version of Enterprise Seniority Date?Summary Is there a way to pull in a small piece of custom SQL to pull the right version of Enterprise Seniority Date into our custom OTBI reports?Content We know we want…User_KNIL2 67 views 2 comments 2 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
Add Column to Reflect whether Measurement is Present in an Employee's GoalSummary There needs to be 1 column added to a Goal report namely "SUCCESS_MEASURE_EXISTS" which will reflect any of the following values: Complete, Incomplete, PartiaCon…Aahiri_Sarma 43 views 2 comments 0 points Most recent by Rebecca Emerson Reporting and Analytics for HCM