Category 81
Discussion List
-
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 106 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 407 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… -
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 13 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 92 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 71 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 52 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 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 74 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 43 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 316 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 22 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 781 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 31 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 43 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. 41 views 3 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
Is it possible to include a link to a PDF file in an OTBI report?Summary: We are looking to have a report based on the Documents of Record subject area where the user can run the report and access the document reported as a PDF. Conte…David Bean-259734 83 views 4 comments 0 points Most recent by Greg Rank Reporting and Analytics for HCM
-
How to convert multiple rows into columnsSummary: Need help converting rows into columns for the attached report OTBI report. I tried to use Pivot and Case statement but, was still stuck. Here is the sample OTB…Ashok Kumar Sharma 62 views 9 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Hierarchy not availble in BIWe have created an Organzaiotn Hierachy as per 1th of january 2023. The tree version is active, but noy (yet) avaliable in BI. Same for a Department Hierarchy. Is there …Wouter.Schaap 23 views 4 comments 0 points Most recent by MandeepGupta 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…
-
Creating a My Reporting tab in HCMSummary: Anyone created a My Reporting tab in HCM with links to dashboards? Content (required): I was recently on a demo using the Vision environment and spotted that a …
-
Standard OTBI report displaySummary: Content (required): Hello everyone, We are experiencing problems with the visualization of a standard OTBI made available by Oracle that allows the 'department …Gerardo Peluso 32 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Oracle HCM: How to change existing Host Key Fingerprint in BI AdministrationHi Team, We have a requirement to change the Host Key Fingerprint because of change in SFTP hostkey due to recent changes within SFTP application. Are we able to change …Chaitra Lakshmi Krishna 364 views 5 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Is there a seeded skills and qualifications report?Summary: Content (required): Is there a standard qualifications report? Version (include the version you are using, if applicable): 23A Code Snippet (add any code snippe…Stella Kaszab 84 views 3 comments 1 point Most recent by Stella Kaszab Reporting and Analytics for HCM
-
Form output created in BI PublisherI prepared a absence form using BI Publisher, when I add the relevant fields, it does not change according to the person, the only date is fixed. What could be the cause…Cansel Karasoy 61 views 15 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
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 -
California Meal Break ReportCalifornia Meal Break Report Could you please help us getting a meal break report for the California Employees? Thanks Mansur -
Executing seeded data model to display report - TalentProfileDMSummary: How can I run the seeded data model, TalentProfileDM, to review the data that I have input into the talent profile? Content (required): This is a massive data m…User_2025-02-05-22-55-58-511 33 views 1 comment 0 points Most recent by Welsey 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 54 views 5 comments 1 point Most recent by Shant_Sarkissian_WJG Reporting and Analytics for HCM