Report Delivery
Discussion List
-
Printing details on a single row using a XSL Fixed Position TemplateSummary Need help in printing both parent and child XML details in the same rowContent Hi All, Need your suggestions on how to solve the below requirement: 1. Applicatio…Brendon Charles-24581 30 views 8 comments 2 points Most recent by Mark Johnson Reporting and Analytics for HCM -
Hierarchical prompt for org tree strucutre in BI Data Model ReportContent Is it possible to create a prompt in BI data model report that will give us the whole org tree structure in a cascading way according to different levels as we h…Amrit 79 views 2 comments 2 points Most recent by Farooq Syed, CPA, PMP, CISA Reporting and Analytics for HCM -
link dashboard to a page entrySummary how the get the dashboard URL in order to make a new page entryContent hi all, ive created a Dashboard which include an absence analysis and a general prompts in…User_2025-01-30-04-14-21-127 95 views 19 comments 0 points Most recent by Caroline Gladwin-Oracle Reporting and Analytics for HCM -
Maximum job proficiency in job profile competency in BI PublisherSummary where can I find the target level of competency job profile in BI publisherContent Hello, Do you have an idea where can I find the maximum proficiency in job com…User_I6AXL 32 views 1 comment 0 points Most recent by Rebecca Emerson Reporting and Analytics for HCM -
Total Compensation StatementsSummary We don't use the comp module - but we do utilize the Payroll and Benefits modules. Has anyone created a OBTI report that would pull all gross payroll numbers, LT…User_2025-01-29-19-59-40-005 97 views 9 comments 0 points Most recent by User_2025-01-29-19-59-40-005 Reporting and Analytics for HCM
-
Bursting in BIP report using the rolesContent Is bursting possible based on the roles the user is assigned. For Example, if I have a report containing the data for US and UK, then all the person who has the …
-
Persons without data in organization level are missing in OTBI reportSummary if one person don't have data in the 5 level of organization will not appear in the reportsContent Hello, I hava some GID that are missing in my reports. When I …User_I6AXL 38 views 2 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
Worker Information not visibleSummary OTBI reports not fetching any worker informationContent hi All, Any OTBI report i create does not return worker information or Department information. But when i…User_2025-01-30-21-35-26-929 48 views 3 comments 0 points Most recent by User_2025-01-30-21-35-26-929 Reporting and Analytics for HCM
-
BI Folder: limit visibility only to specific application roleContent Hi all, I'm trying to understand how to limit the access to the 'Custom' folder under Shared folders -> Custom to only 1 specific Application role. We have enabl…Daniela Spaseska-Oracle 95 views 4 comments 0 points Most recent by User_2025-01-30-01-56-27-828 Reporting and Analytics for HCM -
Error advanced sql request using two subject areasSummary avanced sql query errorContent Hello , Attached the request I did to display competeny proficiency and target for the job profile. I have an error message . Any …User_I6AXL 45 views 4 comments 0 points Most recent by Anil Pillaresetty Reporting and Analytics for HCM
-
Competencies : target level and mine level in OTBISummary Competencies by target level and mine levelContent Hello, I cannot find in OTBI the mine level and target level . For example for the competency ITM_Architecture…
-
Self-Service & DashboardsSummary How do you share your reports with your users?Content Hello experts - I am hoping to find out best practices as to how you do reporting for your company (or how …Prudence K 113 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
calcul division , result wrong OTBISummary result of Division of sum (measure ) /sum(measure ) is not goodContent Hello , I want to calculate the percentage of headcount by competency So I have the number…User_I6AXL 63 views 8 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
What does DATA_DS G_1 mean in BIP?Summary What does DATA_DS G_1 mean in BIP?Content Hello All, I am running a SQL in BIP and it is returning DATA_DS G_1 (see attached SQL and screenshot of DATA_DS G_1). …User_2025-03-07-21-07-25-805 428 views 6 comments 1 point Most recent by User_2025-07-18-02-05-33-261 Reporting and Analytics for HCM -
HCM Extract Bursting PrioritySummary How to set bursting priority in BI Bursting or HCM extract delivery optionContent One of our integration partner requires trigger file (empty file with same file…User_2025-01-25-03-22-14-136 69 views 3 comments 0 points Most recent by DIVIAMARENDRA1201 Reporting and Analytics for HCM
-
EEO-1 Report - R13Summary DUNS Number does not fit in field on reportContent Hello Community, The DUNS number on the delivered EEO-1 audit report in R13 does not fit and is cut off. In R1…Susan Anderson 86 views 5 comments 0 points Most recent by Susan Anderson Reporting and Analytics for HCM -
Publishing a custom dashboard to one user from OTBI in HCM FusionSummary Need assistance in publishing a custom dashboard in OTBI out to a single userContent I have a custom dashboard that I only want one user to have access to. I kno…User_2025-01-25-04-17-41-399 144 views 8 comments 0 points Most recent by Caroline Gladwin-Oracle Reporting and Analytics for HCM
-
Search a date un value of columns that containts multiple date (DD/MM/YYYY ~DD/MM/YYYY ~DD/MM/YYYY )Summary How to search for date of birth in the actual year from value which contains many datesContent Hello, I want to find persons which their date of birth is in the …User_I6AXL 30 views 3 comments 0 points Most recent by Aaron Leggett Reporting and Analytics for HCM
-
Fusion Field - OTBI Subject / Folder MatrixContent Afternoon all, Is there a master matrix anywhere that lists fields in Fusion and cross-references them to their location subject area / folder / sub folder in OT…User_2025-01-28-05-39-23-766 119 views 2 comments 1 point Most recent by User_2025-01-28-05-39-23-766 Reporting and Analytics for HCM
-
Changes only data in BI ReportsContent Please consider the following scenario: The Department of an employee is updated from 'Department A' to 'Department B' on 15th December 2017. The report is run o…Amrit 316 views 9 comments 0 points Most recent by User_2025-01-25-06-20-12-259 Reporting and Analytics for HCM
-
BI publisher report for persons who ticked yes for an interview with their HR contact .Summary Tables where I can find question and responses for interview between salaries and their managerContent Hello, I want to create a report to display alls persons w…
-
HCM Cloud Report Building - rules for naming new reportsSummary Best Practice for HR Report NamingContent Can anyone advise on best practices when naming new Human Resource reports built in HCM Cloud? We will be creating all … -
Dynamic Image according to different legal employerSummary Dynamic Image according to different legal employerContent Hi, is it possible to create a report (rtf template trough Word BI Publisher add-on) with a dynamic im…User_2025-01-28-21-18-09-074 85 views 6 comments 0 points Most recent by Vikram Agarwal-43618 Reporting and Analytics for HCM
-
Issue in SQL script to get Overall Summary section commentsContent Hi All, I have written a script to get comments entered by both Manager and Worker in the Overall Summary Section (OS) in the Performance Document. (See my scree…Achala Munasinghe 123 views 4 comments 1 point Most recent by Achala Munasinghe Reporting and Analytics for HCM -
Performance Reports - Leaders not seeing resultsSummary Report is blank when opened by a LeaderContent I have created 3 performance related reports (Document Status, Rating Detail and Rating Distribution). When I open…User_2025-01-28-20-43-56-568 53 views 5 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Problem when filtring on OTBI to take MAX(date) for many userSummary I want to filter for max(date) for many users , It works only for one user .Content Hello, I create a report to display person id with a item_text,but for each i…User_I6AXL 99 views 7 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Email BurstingSummary How to send BI report pdf output as attachmentContent There is a requirement to send the pdf output of a custom BI report to employees. I have added the bursting…Vivek Pathak-71652 97 views 9 comments 0 points Most recent by Mansur Khalil Reporting and Analytics for HCM -
Data PrivacySummary How do you share your reports with your users?Content Hi all - I submitted a post recently about how you share reports with users (through self-service and/or da…Prudence K 89 views 6 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Date format 'DD-Mon-YYYY' in OTBI Analysis PromptContent Can anyone please guide how to get the date format 'DD-Mon-YYYY' in the OTBI Analysis prompt. Please see the screen-shot attached, where I want to achieve it.Amrit 235 views 1 comment 3 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
SQL Script for Worker's departmentContent Hi All, I am trying to get the worker's department along with his name, person number, manager etc. I use the following script to get the department; SELECT DIST…Achala Munasinghe 85 views 4 comments 0 points Most recent by Achala Munasinghe Reporting and Analytics for HCM