BI Publisher
Discussion List
-
Table name for retrieving representative information assigned to an employee based on AORSummary: I need to write a BI publisher report where I need to fetch the representatives assigned to an employee based on AOR as shown in the screenshot below .Here we c…Nirmal 37 views 2 comments 0 points Most recent by Vinayak | Camptra Tech Reporting and Analytics for HCM -
BI Publisher Desktop for BIP 11.1.1.9.0 not working with MS Office-365 & WIN-10Summary: Hello Experts, Can you please guide me if you have faced the similar issue while installing BI Publisher Desktop for BIP 11.1.1.9.0 which not working with MS Of… -
Grouping and sum the RUN values of balances using XSLTSummary: Grouping and sum the RUN values of balances using XSLT Content (required): I have a below requirement to group by and sum the RUN values for each balance under …Deekshith Kalluri 31 views 0 comments 0 points Started by Deekshith Kalluri Reporting and Analytics for HCM
-
ORC: Tracking all the End Dates for a RequisitionSummary: Hi, Can we track & report all the end dates for a requisition if Hiring Manger changes the End Date of the Requisition? Any help with details like Tables, Repor…Bhaskar Konar 41 views 7 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
BIP Report - Department HierarchySummary: Hello, can I create a SQL for department hierarchy out of this sample pattern? Does it work in Oracle BI Publisher? with Org ( id,idparent, name, level , Path) …Hazel De Castro 33 views 2 comments 0 points Most recent by Hazel De Castro Reporting and Analytics for HCM
-
How to create Pivot table in RTF with Text values?Summary: Hello Experts, Is it possible to create a Pivot table in RTF with Text values? If yes, kindly share the details. Regards, Abhishek Premchandra Content (required…Abhishek Premchandra-Oracle 35 views 4 comments 0 points Most recent by Abhishek Premchandra-Oracle Reporting and Analytics for HCM
-
OTBI-Report-Workforce Management - Person Real Time-Roles RequieredSummary: OTBI-Report-Workforce Management - Person Real Time-Roles Requiered to get employee information Content (required): Hello I need to get some employee and manage…Cesar Saveedra 2 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Blank line at the end of etext template output fileSummary: I'm trying to fetch the data from cloud in .txt file format by using ETEXT template. A blank line is noticed towards the end of the file always which is not exp…Meenakshi K 194 views 6 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM
-
Unarchive ErrorSummary: I am unable to unarchive the BIP report to BIP and getting the below error. Tried in different browsers by clearing the cache, but still the same issue. Content…Satyanarayana M-Oracle 31 views 2 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM
-
One report containing all assignment, elements and work schedule assignment changesSummary: The organisation requires a combined report containing history of all assignment record, element entries and work schedule assignment changes. Content (required…User_2025-01-29-23-50-34-285 43 views 0 comments 0 points Started by User_2025-01-29-23-50-34-285 Reporting and Analytics for HCM -
Is there a way in OTBI and/or BIP to automatically push a scheduled report to SharePoint?Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Nigel Wiltshire-Oracle 53 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
which field stores value for Primary for national_identifiersSummary: which field stores value for Primary for national_identifiers Content (required): For National Identifiers in Front end,we can enter more than 1 National Identi… -
Is there a transaction table that stores currently ongoing transactions on the page in HCM?Summary: Previously we have hr_api_transactions table in Oracle EBS but now i am not able to find a table like this, Would you please help? Content (required): It is nee…Fraol Wondimu 13 views 2 comments 0 points Most recent by Fraol Wondimu Reporting and Analytics for HCM
-
Report to generate Performance Document Status ReportSummary Report to generate Performance Document Status ReportContent Unarchive this catalog to use this report. -
DATEVALUE Function is not working properly in excel templateAfter using DATEVALUE Function column values are not matching with the actual column values. Please refer the screenshot Not sure what is the issue. Template : Thanks, M…minati_behera-Oracle 24 views 2 comments 0 points Most recent by Aaron Hager Associated Bank Reporting and Analytics for HCM
-
% of Employees on Talent Review meeting w.r.t Succession PlanSummary: I am looking to calculate the % of employees on a Talent Review box those who are on Succession Plan. SO for example on the 9-Box matrix box- Future Star we hav…
-
What is the usage & how to use a View Object validation type in Value set?Summary: Content (required): Version (include the version you are using, if applicable): 21D Code Snippet (add any code snippets that support your topic, if applicable):Fraol Wondimu 14 views 1 comment 0 points Most recent by Madhavi-Oracle Reporting and Analytics for HCM
-
How to implement a custom version of a standard BI ReportSummary: How to implement a custom version of a standard BI Report Content (required): Hi, I would like to edit a Standard Performance Notification (the report is the fo…Alberto Barile 4 views 4 comments 0 points Most recent by Paul Campanello Reporting and Analytics for HCM -
on-going resignations report - reporting on approvalsHello, could somebody please tell me how to extract this information from Fusion HCM, either as an OTBI or a BIP report? The business requirements: - we are using the jo…Geraud Andreux 61 views 4 comments 0 points Most recent by Geraud Andreux Reporting and Analytics for HCM
-
How to apply Line Manager data security in BIP report running from OTBI dashboardSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Vijay Gorania 101 views 12 comments 0 points Most recent by MilanMohanty Reporting and Analytics for HCM
-
Security Slowing Down ReportsContent Hi all - We have a security role, Global Reporting, that allows me to create, edit, run reports and see all data. We give this role out to our report developers …Prudence K 48 views 6 comments 0 points Most recent by Shant Sarkissian_NES Reporting and Analytics for HCM -
ORC: Candidate EIT info Reporting via OTBI Subject AreasSummary: Can we extract ORC Candidate EIT info via OTBI Subject Areas? Content (required): Can we extract ORC Candidate EIT info via OTBI Subject Areas? What will be the…Bhaskar Konar 68 views 4 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Can you change the date format in all the columns that have dates so that it filters by year/MonthSummary: we are using excel template to generate the excel output.Can you change the date format in all the columns that have dates so that it filters by year/Month? Thi…minati_behera-Oracle 32 views 2 comments 0 points Most recent by Abhishek Premchandra-Oracle Reporting and Analytics for HCM
-
Bursting to get xml as an attachment from xsl templateSummary: Hello Experts, I have a report where I am using xsl template as layout. Our requirement is to send the report output in xml format to the destination email, but…Jaswant Prajapati 85 views 0 comments 0 points Started by Jaswant Prajapati Reporting and Analytics for HCM
-
Restrict Report Folder movements in the BI catalog areaSummary: Hi Experts, How do we restrict Folder Movement (Drag and Drop option) of BI Catalog Custom Shared Folders? Is anyone can advise on this? Recently we had a bad e…Mithun Abhisheka 99 views 2 comments 0 points Most recent by User_2025-03-07-21-51-04-421 Reporting and Analytics for HCM -
Custom flow is not producing the dataSummary i have attached custom BI Report to custom flow pattern when we are running the flow output is coming as blankContent Hi Team, we have a requirement to attach BI…User_2025-02-04-07-00-18-658 39 views 4 comments 0 points Most recent by Jon Taylor Reporting and Analytics for HCM
-
I'm trying to use the concat function in ether OTBI or BI to combine 4 fields.Summary: I have tried using the pipe method (||), the nested method and the case/when. and still can not get this to work. I am trying to to combine cost center informat…RJ Blankenship 316 views 9 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Need to add different images of signatories in the rtf template for a BIP reportSummary: Content (required): I want to add signature's image to the letter which is in rtf template where path of the image is an XML element. As far as i researched im …
-
BI Publisher Integration with Google CalendarSummary: Can we integrate BI Publisher with Google Calendar (i.e.) To make a web service call from BI to Google Calendar API and create and update events. Please share i…Srikanth_M 13 views 1 comment 1 point Most recent by Adam Gates-Oracle Reporting and Analytics for HCM
-
Missing columnsSummary: Not appearing columns heading when records are exported. Content (required): We have created query to export data which has been generated in xml. However, when…