SQL
Discussion List
-
Why am I unable to report on the ratings given within a completed performance document?I need to be able to report on the ratings given by the manager for a pre-assigned performance document. I am using the Workforce Management - Performance Rating Real ti…Helen Tilling 62 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Are Deduction Code; Deduction Amount and Deduction Factor available in OTBI or Oracle HCM BI tables?Summary: Content (required): Hello experts, are Deduction Code; Deduction Amount and Deduction Factor available in OTBI or Oracle HCM BI tables? If so, could you share t…Valerio Curzi 41 views 4 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Document Record Deep Link in SQL Query - use parameter regarding uploaded document record IDSummary: There is a requirement for BI report to have direct / deep link to a document record for persons Content (required): I found the Deep Link URL and several of it…Shant Sarkissian_NES 413 views 3 comments 1 point Most recent by Balaji Vijayakumaran Reporting and Analytics for HCM
-
when i try to schedule the report through agent in condtion section when test its show false why?Summary: Hi Team, when i try to schedule theOTB report through agent in condtion section when test the condtion its show false why? Please help me on ? Thanks, Ajay Cont…AjayKumar Maddipati 11 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Does exist a way to know which database tables gets modified when user inserts data from UI?Summary: Does exist a way to know which database tables gets modified when user inserts data from UI? Content (required): Does exist a way to know which database tables …Stefano_Mazzocca 41 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Audit on Termination DataSummary: Audit on Termination Data Content (required): Hi All, Greetings! Is there any report available based on audit for termination data for the employees? We'd need …Parag Hiremath 105 views 4 comments 0 points Most recent by Daniel McMillian Reporting and Analytics for HCM -
Mail notification sending and limitHi, Can a special mail extension be used in notifications prepared as bursting and sent via email? For example, it should only go to people whose e-mail is @aaa.com.tr ?…Cansel Karasoy 31 views 2 comments 0 points Most recent by Sandeep19rm Reporting and Analytics for HCM -
Reporting on Holiday Entitlement and Remaining BalanceHi all, Is it possible to report on total holiday entitlement as one combined field (factoring in employees carry over, annual accrual and other adjustments) within OTBI…
-
I can't see absence approvers in transaction tableHello, I am preparing a report to see who approved or denied the absences for the absence records in the transaction console. However, I cannot access the approver infor…
-
Query to extract Candidate Attachments URLSummary: Content (required): Hello experts, please, could you provide the SQL Query to extract Candidate Attachments URL? Our customer should retrieve Candidate Curricul…Valerio Curzi 124 views 2 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Time zone in BIP .xpt templateSummary: How can we add the user preferred time zone along with Date and time in the BIP .XPT template? I am aware of the tags for RTF template but the requirement is to…Debkanya 41 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
Is it possible to report on time worked?Summary: Is it possible to create a report that list the hours worked for an employee? Content (required): We are trying to create a report to show if an employee is eli…Brandon Roberts 316 views 13 comments 0 points Most recent by Scott Pisani Reporting and Analytics for HCM -
SQL query for Length of service in years and monthsSummary: Hi, I am trying to add formula in OTBI report on Service Date field to calculate duration in years and months. However, I don't know SQL, but was able to find b… -
SQL Query to extract Skill and Qualification Attachment URL?Summary: Content (required): Hello experts, please, could you provide the SQL Query to extract the attachment URL loaded in Skill and Qualification page? Is it possible …Valerio Curzi 102 views 3 comments 1 point Most recent by MandeepGupta Reporting and Analytics for HCM
-
SQL query to extract Candidates ResumeSummary: Content (required): Hello experts, we need to recover candidates resume URL. Is it possible to retrieve this information? Which table store resume URLs. Is ther…Valerio Curzi 430 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Upgraded from Version 1 to 3. PER_SENIORITY_DATES_F - How is it Populated?Summary: New table PER_SENIORITY_DATES_F created as part of upgrade to version 3. Can any one share the details of the data migration to this table? Content (required): …ChicagoConsultant 11 views 1 comment 0 points Most recent by Ramanathan Sockalingam Reporting and Analytics for HCM
-
How to know BI reports andOTBI Reports of scheduled report jobs and Agents list through query or anySummary: Hi Team, we have sceduled reports and OTBI reports through Agents how to get the list of reports scheduled from system any query or OTBI for ? we have report jo…AjayKumar Maddipati 71 views 2 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
We have below EFF fields in per_person_eit_eff table but unable to find this table in Oracle DocsSummary: Hi Team, We have below EFF fields in per_person_eit_eff table but unable to find this table in Oracle Docs. Any one help me on ? Thanks, Ajay Content (required)…AjayKumar Maddipati 796 views 11 comments 1 point Most recent by Sudheer Patel Reporting and Analytics for HCM
-
Custom Performance Management Audit BI ReportSummary: Build a custom BI report that contains audit for performance document Content (required): Would like to know if there's an oracle hcm table to capture the previ…
-
BIP Report QuerySummary: Hi All, We created one BIP report where we can run by the Department name that shows all Position in the Department (both filled and vacant) and their Parent Po…Sakthi Priya S 42 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Table for security console audit?Summary: We have auditing enabled. Specifically, the "Oracle platform security services" option. We need the table names where audit tracking takes place with respect to…Shant Sarkissian_NES 51 views 5 comments 1 point Most recent by Shant_Sarkissian_WJG Reporting and Analytics for HCM
-
Replace special characters with standard onesSummary: Hello, we need to build an integration with a BI report where the recipient cannot accept special characters. In person names we have a lot of special character…Nicola Petri 53 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
I'm looking BI Report from skills and qualifcations page skills,cerifcations and languages cloumnsSummary: Hi Team, I have below code but unable to find the below cloumns in Bi report. Navigation of UI- ME>Performance>Skills and Qualifications In that we have section…AjayKumar Maddipati 41 views 1 comment 0 points Most recent by Preethi-Oracle Reporting and Analytics for HCM
-
Is there query to get Audited performance management rows?Summary: Is there already a default query on the system that retrieves audit values for performance management? We have already turned the performance management object … -
we ae getting multipule dublicate records in BI report with out any changeSummary: HI Team, we have absence reports but in recent we observed multiple dublicae records for each employee how can we sorted out this issue ? example: one employee …AjayKumar Maddipati 32 views 7 comments 0 points Most recent by Riyaz Ali-Oracle Reporting and Analytics for HCM
-
Need help with SQL query (OBIEE Dataset)Summary Building a report showing a persons information on 2 different dates - need help with some sql design (if possible)Content Hi All, I am trying to build a report …User_2025-02-04-08-51-08-912 40 views 6 comments 0 points Most recent by Roma Pandey Reporting and Analytics for HCM -
How to fetch log error from ESS Job ''Run Convert Pending Workers Automatically Process''Summary: Need to create an report(BI/OTBI) to fetch data of "Run Convert Pending Workers Automatically Process" job log error Content (required): Version (include the ve…
-
How do add export option to Dashboard UI reportContent Hi, I cannot find a way to make the option export in the UI dashboard available. of course through OBIEE this option is available, but after adding the report to…Gal Shani 96 views 7 comments 0 points Most recent by Satheesh Nesamani Reporting and Analytics for HCM -
Getting Absence Reason in BIPSummary: I need to get the absence reason for a large number of absence in a BIP report. However, when trying to link the Absence Entry Reason ID to the Reason ID using …
-
Report to extract LRU Calculation cards configuration detailsSummary: Report to extract LRU Calculation cards configuration details Content (required): Hi Team, Greetings! Does anyone have the report or the query to extract LRU Ca…Parag Hiremath 53 views 0 comments 0 points Started by Parag Hiremath Reporting and Analytics for HCM