Category 81
Discussion List
-
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 94 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 70 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 25 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 41 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 422 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 93 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 68 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 46 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 36 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 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 69 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 -
In OTBI Report,we are used Worker assignement Event Real time but "State" column not available ?Summary: Hi Team, In OTBI Report, we are used most of the employee address columns from ( Worker assignement Event Real time) subject area but "State" column not availab…AjayKumar Maddipati 40 views 3 comments 0 points Most recent by AjayKumar Maddipati 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 … -
Career Development ReportSummary: Trying to create an OTBI report using subject area "Workforce Career Development - Development Goal Overview Real Time". I have no issues adding fields from Dev… -
Can the Performance Review, Comments section font be made uniform when using custom font?Summary: When creating a custom version of the employee and manager printed performance review document in BI, we are unable to force the font in an open text comment se…Kelly Soos-Fell 28 views 3 comments 0 points Most recent by Kelly Soos-Fell Reporting and Analytics for HCM -
Data Security in BIP ReportTeam, Which is the best way to apply the data security in BIP Report. Example: User belongs to the business unit "BU-A" should be able to see the data of "BU-A" We have … -
Excel BIP report: Comment field split over several rows and columnsSummary: BIP report: How can we make sure that comment field is not split up over several rows and columns when exporting report to Excel? Content (required): Hi, we hav…Franziska Reichel 814 views 6 comments 1 point Most recent by Lucian_Plamada Reporting and Analytics for HCM -
OTBI Emergency Contact by EmployeeSummary: Dear Community, How can i produce an OTBI report to generate an emergency contact? Can anyone share sample Data Model? We need to use this for Incident Response… -
Scheduled OTBI Report to provide output as on previous dateSummary: Want to schedule OTBI report which triggers output as on previous date as effective date Content (required): When OTBI report is scheduled, we have a requiremen… -
Drill Down OTBI bar chart report is not working correctly using several columnsSummary: We have a master report which has the following columns: -Positioning Before, Grade Code, Gender, Number of eligible employees. I used a stacked vertical bar ch…bervin13 116 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
The most data that we can get about an OTBI Agent that was shotSummary: Content (required): Hi there, i see that there are a few posts about getting detailed data about if OTBI agent shot successfully and getting more details. I saw…Bobby Jourdan 17 views 2 comments 0 points Most recent by Bobby Jourdan Reporting and Analytics for HCM -
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 34 views 7 comments 0 points Most recent by Riyaz Ali-Oracle Reporting and Analytics for HCM -
How to calculate cost of sickness in UKSummary: Calculate the cost of sickness using salary from element entry Content (required): I have been asked to calculate the quarterly cost of sickness. I was wonderin…Isabela Radivoi 25 views 2 comments 0 points Most recent by Isabela Radivoi Reporting and Analytics for HCM -
Prompt for Assigned on Date and Completion Date are not filtered based on the security of user (OLC)Dears, I've created a prompt with two filters: YEAR(Learning Record Details.Assigned on Date) YEAR(Learning Record Details.Completion Date) I don't understand the reason… -
How to disable user login whenever the user is deactivatedSummary: Content (required): Hi All, The requirement that when users leave the company and when email get deactivate in the company, then fusion application login also s… -
Load the data into the custom content sectionSummary: Content (required): Hi Expert, We have created a custom content section ABC and there are some fields where we want to load the values in it. Please suggest if …Faizan Rashid 47 views 3 comments 0 points Most recent by Dinesh Parasakthi Reporting and Analytics for HCM