SQL
Discussion List
-
BIP Report for batch monitoring of Scheduled HCM ExtractsSummary: Feasibility of BI Report for batch monitoring of Scheduled HCM Extracts. Content (required): Would like to know if it's possible to pull Scheduled HCM extracts …Kate Calderon 21 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM -
Bursting body and pdf attachmentHello, I want the message body of an e-mail I prepared with bursting to appear as follows, and I also want to add a pdf to this e-mail. How can I do that?
-
Impossible to get report output for only some usersSummary: Impossible to get report output for only some users when launching them Content (required): Hello experts, we have been having problems since November 2022 for …Oriana L. 131 views 3 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM -
From which table can I add the Synchronization From Position field to the sql report?Hi, I want to bring the field where Synchronization From Position field returns 'Yes,No' on the assignment details page in the employee record to my report. Which column…Cansel Karasoy 31 views 2 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
Benefit Certifications tableSummary: We have a requirement to fetch "Certifications" tab related data in the BIP report. May I know in which tables holds the information on certification? Content (…Satyabrata Nanda 52 views 5 comments 2 points Most recent by Viral Abotiyawala-Oracle Reporting and Analytics for HCM -
how can I get correct seniority date when multiple seniority dates are there for a person in OTBISummary: I am reporting from Workforce Goals - Goal Status Overview Real Time and Workforce Management - Person Seniority Real Time. When I have Seniority Date showing, …User_2025-07-18-06-45-42-477 105 views 4 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Performance Task Status subject area is not pulling data belongs to old org structure.Summary: Performance Task Status subject area is not pulling data belongs to old org structure. Content (required): We have created new organization structure version in…Swati U 31 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Need a Query to Exclude the Terminated Record after 7 daysSummary: First 7 days , The Record should show with Status= Inactive Status and after 7 days The Record should not be shown in the Report. Content (required): Version (i…MilanMohanty 91 views 10 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
How can I combine multiple templates in a publisher?I have a report that returns the absence records of the people I prepared from SQL and it will work according to the absence type parameter. The report will be prepared …Cansel Karasoy 41 views 1 comment 0 points Most recent by Sandeep S. Chauhan-Oracle Reporting and Analytics for HCM
-
How to fetch Arrear balance details for terminated EmployeesSummary: Content (required): Hello, Our requirement is to fetch the arrears details for the terminated employees, adjust them accordingly. Deduction report has a section… -
How to set up time period for 12 week rolling percentageIn the "Workforce Management - Workforce Trend Real Time" subject area, in the "Workforce Trend" folder, there are the following fields: I need to use these in a calcula…rd17 11 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Learning Module | Sql query to get details of default assignment rules of the courseContent I have a requirement where I need to create refresher alerts for mandatory courses – based on the renewal period set for the course. Notification will be trigger…Mani Venkataraman 154 views 10 comments 0 points Most recent by User_14HUA Reporting and Analytics for HCM
-
regexp_replace not working in etext templateSummary: regexp_replace not working in etext template Content (required): We have a requirement to remove extra semicolon from the string. Using regexp_replace, we are a…Meenakshi K 415 views 2 comments 0 points Most recent by Meenakshi K Reporting and Analytics for HCM
-
Can I put a link inside my Bursting query?I want to add an oracle link to send it in the mail notification in the message I print inside my bursting query, is this possible?Cansel Karasoy 51 views 3 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM
-
Impossible to open an OTBI reportSummary: Impossible to open an OTBI report Content (required): Hello experts, we have seen that, since a couple of weeks, a specific user is not able to open a report an…
-
How to take Length of service(in years), Service category and transfer detailsSummary: How to take Length of service(in years), Service category and transfer details? Content (required): Hi All, We got a BI report requirement to show employee's Le…
-
What does it mean to have 'INITIAL' in the 'STATE' field in the hrc_txn_data table?When I query the records with 'DRAFT' from the transaction table, the STATE field is reflected as 'INITIAL' AND 'SAVED'. What exactly does INITIAL mean?Cansel Karasoy 11 views 0 comments 0 points Started by Cansel Karasoy Reporting and Analytics for HCM
-
How can I create dependent working parameters in SQL report?Hi, I have 'person number' and 'absence start date' parameters that I will use in my sql report and I have defined lov value set for them. But I want start date to come …Cansel Karasoy 51 views 2 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM
-
BI Publisher SQL helpHello Team, i have written below sql to fetch count of time entries. select REC.RESOURCE_ID, count(distinct(to_char(start_time ,'yyyy-MM-dd'))) as Counter from HWM_TM_RE…minati_behera-Oracle 31 views 3 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
How to Pull Future Dated InformationSummary: How to Pull Future Dated Information from HCM Content (required): I have created a report in OTBI using the Payroll - Calculation Cards Real Time Subject Area. …User_2025-03-07-06-11-23-192 38 views 4 comments 0 points Most recent by User_2025-03-07-06-11-23-192 Reporting and Analytics for HCM
-
Add "Business Object Type" and "Attribute" columns to the Delete Audit ReportSummary: We had a custom report called 'Delete Audit Report' and the client wants to add columns on it for 'Business Object Type' and 'Attribute' same on what we see on …Maria Cristina L. San Jose 31 views 1 comment 0 points Most recent by Maria Cristina L. San Jose Reporting and Analytics for HCM
-
Termination Headcount MeasureSummary: Subject Area: Workforce Management - Work Assignment Event Real Time, Assignment Event, Termination Headcount calculating terms on the last day of the month in …Rebekah Gilday 92 views 5 comments 0 points Most recent by Yves Blanc Reporting and Analytics for HCM -
DATE_ADD function ErrorSummary: Hi Everyone! I am try to add specific year to the hire date using Date_add function, but it is throwing "Missing right parenthesis error". Could any one help me…
-
SQL for PER_EMAIL_ADDRESSES to obtain Email Address IDSummary: Email Address ID required for HDL worker.dat file to mass upload email address changes. Content (required): We want to use HDL to mass upload email address chan…Michelle Hughes 3.2K views 6 comments 0 points Most recent by Michelle Hughes Reporting and Analytics for HCM
-
Restricting the values of a dashboard promtSummary: Hello, We have made a BIP report on an Assessment which will show the candidates who have reached the assessment state and their results/current status etc. The…Shreya Datir 41 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
How to link Top Manager to a username within "Workforce Management - Worker Assignment Real Time"Summary: Hi all I'm trying to create an emergency contact report that allows managers to see their entire reporting line population and the emergency contact details on …
-
Help getting interview date - BI report for ORC.Summary: Hello experts, Need input for getting interview date for an ORC report i am working on. This is my first time working on ORC related tables. I can see this tabl…Jithin Mathews 86 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
We have option to Scheduled the BIP report in more option but why we go with ESS Job any difference?Summary: Hi Team, We have option to Scheduled the BIP report in more option but why we go with ESS Job any difference? what is the main purpose of ESS JOB . How can we u…AjayKumar Maddipati 112 views 3 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM -
Unbale to get Notice Period UOM token details for Offer creation in XML file?Summary: Unbale to get Notice Period UOM token details for Offer creation in XML file? Content (required): Unbale to get Notice Period UOM token details for Offer creati…
-
Special Characters in BIP ReportSummary: have requirement of replacing special characters coming in the description column of the BIP report with following: Double quotes replace with '"' need to …Rajdeep Chavda 233 views 0 comments 0 points Started by Rajdeep Chavda Reporting and Analytics for HCM