Category 81
Discussion List
-
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 129 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 -
How to get a data secured Job Requisition report in ORC?Summary: We need an Oracle Recruiting Job Requisition report with Job Offer status/progressing information if the Requisition started the offer process, which will publi… -
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…
-
Audit ability for OTBI fields and BIPSummary: Is there any ability to audit on who has created and run a BIP report or OTBI analysis that include specific folders/fields such as from Workforce Management - … -
'Seniority Day' field is having incorrect data in new V3 subject area.Summary: Steps to replicate the issue - We created the OTBI report to fetch 'Seniority dates' and 'Seniority days' from V3 subject area ‘Workforce Management - Person Se…User_2025-07-18-06-45-42-477 57 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
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…
-
Data Secuirty in BI using different data secuitry on role configurationsHello, Am having this case here, Am using Secure View in my query (PER_ASSIGNMENT_SECURED_LIST_V) and am having 2 different data security on roles 1st Person Security Pr…Yomna Waheed 29 views 3 comments 1 point Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM -
seeded CheckReport USCheckwriterTemplate.rtfSummary: Somehow, the seeded template (US) for CheckReport.xdo appears to be overwritten in the Oracle Fusion HCM BI cloud, trying to find a seeded version for USCheckWr…Ruchika Gujarathi 38 views 3 comments 0 points Most recent by Ruchika Gujarathi Reporting and Analytics for HCM
-
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 170 views 2 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Can somebody assist. on how to get the "Seniority Date" calculation date in OTBI subject report?Summary: How to include Seniority Date calculation date in OTBI subject area report (Please refer the screenshot 1 for reference)? How to include Seniority Date transact…
-
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 132 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 477 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Terminated users are still active in security consoleSummary: Dear all, We recently discovered that some of the terminated user accounts are still active in our system, even though we have auto provision role enabled. We a…User_2025-10-31-01-02-51-214 71 views 12 comments 0 points Most recent by Vikash K-Oracle Human Capital Management
-
Not Able pull the Latest Location from "Workforce Management - Worker Assignment Real Time" subjectSummary: Hi, We created the new location and running the OTBI to get the data from subject area "Workforce Management - Worker Assignment Real Time" and has employee det…Kiran Kollamsetti 14 views 2 comments 0 points Most recent by Kiran Kollamsetti Reporting and Analytics for HCM
-
OTBI Customer SurveyTo better understand Fusion customers' current use of and satisfaction with the current reporting capabilities available with OTBI, we would like your help in completing…Noelle Bartlam-Oracle 95 views 2 comments 0 points Most recent by Tom Strudley Reporting and Analytics for HCM
-
Open-source fonts to replace licensed Monotype fonts in BIP and OTBI in 24AIn 24A, open-source fonts will replace the Monotype fonts currently available in Oracle Transactional Business Intelligence. You can use the open-source fonts available …Noelle Bartlam-Oracle 75 views 2 comments 4 points Most recent by Tom Strudley Reporting and Analytics for HCM
-
Position details with transaction summarySummary: Hello Everyone, I have a requirement to create a position report with a real-time transactional summary. Columns are: I could fetch all the above eleven columns…Saher 65 views 11 comments 0 points Most recent by Gail Langendorf-Oracle 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 20 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 -
Payslip Reprinting Report flow does not Produce Output and cannot be opened because it has no pagesSummary: Payslip Reprinting Report flow is completed successfully and does not Produce Output and cannot be opened because it has no PDF (Blank) pages ####[2023-07-11T16…Janardhan ACS-Oracle 49 views 3 comments 0 points Most recent by Janardhan ACS-Oracle Reporting and Analytics for HCM
-
Timeout while using ESS to manage BI submissionSummary: Our ESS job keeps failing with an odd error but if we manually submit the BI it succeeds Content (required): We have a long-running BI query which has been gran…Scott Paulin 353 views 2 comments 0 points Most recent by Scott Paulin Reporting and Analytics for HCM
-
OTBI promptThe OTBI prompts to exclude the Legal Employer having "DO NOT USE" word. On OTBI reports, we have applied Legal Employer Prompts, it shows all legal employers in the pic…Ashok Kumar Sharma 25 views 2 comments 0 points Most recent by Noelle Bartlam-Oracle 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 826 views 11 comments 1 point Most recent by Sudheer Patel Reporting and Analytics for HCM
-
Issue in dashboard PromptSummary: Issue in dashboard Prompt Content (required): Hi All, We have created a dashboard prompt using the Workforce Management - Worker Assignment Real Time subject ar…Venkatesan 36 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Annualized Salary Doubling when adding in Level 1 Organization Name in OTBI ReportSummary: We have a report built which is combining Compensation - Salary Details Real time and Compensation Individual Compensation Real Time subject areas. We have sala…JMora1234 48 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Mouseover on Performance TileDears, is it possible to change somehow the mouseover on performance title? I've been trying to add an html "title" within the cell header but that did not work. Thanks …Domenico P. 46 views 3 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM