SQL
Discussion List
-
Dashboard screen customizationI have a dashboard report that I have prepared with parameters and I want the parameters to look like the screenshot. I couldn't find how to make the background visually…Cansel Karasoy 25 views 7 comments 0 points Most recent by Jahnavi-Oracle Reporting and Analytics for HCM -
Email-Bursting Without Split-ByWe have a requirement to send an email with details. The email body should have the details with table format. The query has more than one record and it should be printe… -
Need table name to fetch 'Plan Period Start Date' in the 'Accrual Plan Balance' Screen.Summary: Dear Experts, Which table stores the 'Plan Period Start Date' in the 'Accrual Plan Balance' Screen. Please find the attached Screenshot for your reference. Than…
-
What can we do so that OIC applications do not use license limits?Hi, What should be done to prevent the versions created for the live and test environment from using license limits in the applications we develop in the OIC environment…Cansel Karasoy 25 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Position hierarchy report prepared from Oracle AnalysisHi, I am preparing a position hierarchy report using an analysis report. How can I find the person in the next position of a position? RegardsCansel Karasoy 56 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Control Infolet visibility on HCM Home page based on person GenderSummary: Control Infolet visibility on HCM Home page based on person Gender Content (required): how to control Infolet visibility on HCM Home page based on logged in per…Nirmal Ignatius 18 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
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 69 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 48 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 432 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 17 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 44 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 128 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 37 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 168 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 47 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 318 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 126 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 474 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 19 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 87 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 822 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 45 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 56 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 68 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 48 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 …