BI Publisher
Discussion List
-
BI Publisher GUI Outer Join QueryContent Hi, We have created a query which is comprised of 3 data sets.They are joined by the elements within the data models. Background: We used to have this pending ap…User_KOLMZ 38 views 3 comments 0 points Most recent by User_2025-01-22-18-30-18-571 Reporting and Analytics for HCM -
Manager Assignment vs Worker Assignment in OTBISummary Manager Assignment StatusContent Hi Team, I know there are a few Manager's information fields available in OTBI but I could not find Manager Assignment Status, f…Alvaro Couto 68 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Prompt Search Edit functionality for BIP reportsSummary How to achieve the prompt search edit functionality for BIP reports similar to one available in Analysis ReportsContent How to achieve the prompt search edit fun… -
Which Subject Area holds the EmailAddressIdContent Could anyone tell me which subject area I can find the EmailAddressId? I need this to update email addresses through Data Exchange for the full version of HCM Da…Rebecca Smith-27468 57 views 6 comments 1 point Most recent by Ema Johnson-Oracle Reporting and Analytics for HCM
-
Bypass report securitySummary bypass report securityContent Is there a way we can bypass user security when setting up a report? We have created some workforce KPI dashboard reports for a sma…Shelly Feyerherm 64 views 7 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
BI PUBLISHER FORMATING DATEContent I am developing a report in BI publisher (using rtf template) and we need to show the current date as just 3 letters of the Month name and year. eg: If the date …User_WHB5J 56 views 2 comments 0 points Most recent by MandeepKGupta Reporting and Analytics for HCM
-
Security for BI Email NotificationsSummary securing a field on a notificationContent Is there a way to secure a field on the BI email notifications? For example, if we want only certain users to see the '…Shelly Feyerherm 47 views 4 comments 0 points Most recent by Shelly Feyerherm Reporting and Analytics for HCM
-
Users Preferred Timezone reportSummary Listing timezones set up in User's preferences by UserContent Hello Everyone, I found this script in one Oracle Support documents but I can't run it as it is sho…Alvaro Couto 68 views 4 comments 0 points Most recent by Alvaro Couto Reporting and Analytics for HCM
-
Changing Date Format at ReportSummary We can not change date format as we want to see.Content Hi All, You can see in below screenshot that we have date format at report column. We can only choose 3 o…User_2025-02-04-18-26-11-309 63 views 5 comments 3 points Most recent by User_2025-02-04-18-26-11-309 Reporting and Analytics for HCM -
BI Publisher, Bursting Template ConditionsSummary Only show second page of template if condition is metContent Hello I am bursting a letter to colleagues telling them the outcome of a pay review. The template ha…User_2025-01-31-17-49-32-187 54 views 5 comments 1 point Most recent by User_2025-01-30-21-52-52-008 Reporting and Analytics for HCM
-
Random Password for PDF burstingContent Hi, We have a requirement to create random password for the attachment which are sending to employee as pdf. We are able to achieve some extend by using a combin…Nivya Mathire 76 views 17 comments 2 points Most recent by User_2025-01-31-00-28-55-093 Reporting and Analytics for HCM -
BIP report and sql injectionContent Hello Experts, While creating BIP reports in the Oracle fusion environment , do we need to consider Sql injection? If we have a BIP report that takes input value…User_2025-01-30-00-14-06-021 88 views 2 comments 2 points Most recent by User_2025-01-22-18-30-18-571 Reporting and Analytics for HCM
-
How do we password-protect a document while bursting it using a Oracle HCM Cloud BI ReportSummary How do we password-protect a document while bursting it using a Oracle HCM Cloud BI ReportContent Hi, How do we password-protect a document while bursting it usi…User_MC37Q 45 views 4 comments 0 points Most recent by User_2025-02-01-08-03-07-149 Reporting and Analytics for HCM -
After Click on Report and Analytics link some times blank screen displaysSummary After Click on Report and Analytics link some times blank screen displaysContent Hi All , I am using the HR dash board to access the Reports and Analytics ,but s…nitin Sharma 50 views 4 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Custom Subject Area Content in Analysis / DashboardsSummary Receives errors when sharing an analysisContent So I built some analysis by using some custom subject content areas, i.e. Regions built from multiple locations. …Deb Luisi 55 views 3 comments 1 point Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM -
Custom report Details queryContent Experts, whether Custom BIP report details are stored in some internal tables? Is there a way to extract those details? There is a requirement to get all the cus…VijayaBaskar Ranganathan 40 views 3 comments 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM -
BIP Report to view the UCM file and its contentsSummary BIP Report to view the UCM file and its contentsContent Hello, In PROD we can't give UCM access to developers due to SOX compliance. Is there any way we can acce… -
REST API for Oracle BI PublisherSummary REST API for Oracle BI PublisherContent Hi. We are using webservices to use the REST API, we´re having an error with the URL for getting the PATch, postman gives…JAVIER COLLADO-125113 108 views 3 comments 2 points Most recent by User_IYN7Q Reporting and Analytics for HCM
-
How to hide Oracle HCM Seeded Report FoldersSummary Hide Oracle HCM Seeded Report FoldersContent Hello Everyone, Does anyone know how to hide Oracle HCM Seeded Report Folders? Attached is the screen-print for refe…
-
BI Publisher model to find stuck transactions in HCMSummary Has anyone a data model that will find stuck transactions within the HCM moduleContent Has anyone developed a data model that will find all of the stuck transact… -
Audit Report using BIPSummary Looking for a custom BIP report query for Audit purpose. #AuditContent Hi, We enabled the Audit for multiple products using the task 'Manage Audit Policies' and …MadhuVitta 245 views 2 comments 0 points Most recent by Janardhana Kondaveeti Reporting and Analytics for HCM
-
Mandatory Parameters in BI PublisherSummary Mandatory Parameters in BI PublisherContent Hi, How can we make the parameters as mandatory/required in a BI Publisher report ? Thanks, NitinNitin Gupta HCM 55 views 6 comments 0 points Most recent by User_1B10X Reporting and Analytics for HCM -
Drill back using SQL query from GL_JE_LINES to PAY_COSTS tableContent We are building a report to get the related Pay Cost data from the GL Journals that gets created after transferred to GL. We have few documents for EBS which men…Satish Kumar-21650 51 views 0 comments 0 points Most recent by Satish Kumar-21650 Reporting and Analytics for HCM -
REPORT EMAIL DID NOT RECEIVEDSummary REPORT OUTPUT DID NOT RECEIVED VIA EMAILContent Hello, We have existing BIP report job which runs and deliver report output via email. And today few customers re…
-
Bargaining Unit (Name) - Table and Column ?Content Hello Everyone, I'm trying to build a BI Publisher Report (complex requirement therefore cannot utilize OTBI) and I am requiring Bargaining Unit field, or to be …
-
How to add "Year" ,"Start Date" and "End Date" as prompt parameter in BI analysisSummary How to add "Year" ,"Start Date" and "End Date" as prompt parameterContent Hi. I am having one requirement in absence management where need to fetch the absence t…Rahul Mishra-19235 125 views 4 comments 0 points Most recent by User_2025-01-28-05-39-23-766 Reporting and Analytics for HCM -
Adding Subject Areas - errorSummary Using the 'Create Analysis' option and selecting 2 Subject AreasContent Hello, I am new to reporting and trying to use some of the out of the box features. The s…Denise Rae 33 views 5 comments 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Probation Confirmation letter Automation in Oracle fusion HCMSummary Probation Confirmation letter Automation in Oracle fusion HCMContent Hi Team, I have to create the bursting report, in which whenever probation status for an emp…nitin Sharma 71 views 5 comments 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Increasing Export Limit into Excel, CSV, XML, etc.Summary Is there a way to increase the row limit when exporting to Excel, CSV, XML, etc.?Content Is there a way to increase the number of rows that can be exported out o…User_2025-01-31-02-48-58-054 239 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Using Max function for bank account highest process orderSummary Issue with using MAX for selecting highest processing order (Priority) within PAY_PERSON_PAY_METHODS_FContent Hi, We are setting up an extract of bank accounts w…User_2025-01-30-03-54-32-528 49 views 7 comments 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM