BI Publisher
Discussion List
-
Changes Report - What are your practices?Content Currently we are modifying the changes report that we had using BIP and we stumble this difficulty How's your company show changes in the changes report? We have…Rick Jason 38 views 7 comments 2 points Most recent by Shanna Oppenheim Reporting and Analytics for HCM -
Save file directly to oracle import and export folderSummary Save file directly to oracle import and export folderContent There is the possibility to save the file generated by Otbi in the Oracle import and export file pat…Leandro Vasconcelos 24 views 1 comment 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM -
BIP Bursting to email: how to embed a link to the application in the emailContent Hi, we created a bi publisher report with an RTF template. in the report we created a form field and in the bi publisher property we set: View the column NEW_L…Alberto Boccato 284 views 9 comments 0 points Most recent by Alberto Boccato Reporting and Analytics for HCM -
How to exctract the AddressId in OTBI (PersonAddress)?Content Hello experts, is there a way to extract the Person Address Id in OTBI? In case, do you have the SQL Query to extract the AddressId? Thanks in advance for your t…Valerio Curzi 34 views 2 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Email NotificationsSummary Disable email notifications for all those who are on long leaveContent Team, we have few employees who are on long leave due to reasons like Maternity leave or P… -
Restrict access to Reports and Subject areaContent Good day, everyone! Could you please tell me if there is an option to restrict access to reports based on roles? I also wondering if is possible to restrict acce…Kristina Serikova 40 views 2 comments 2 points Most recent by Kristina Serikova Reporting and Analytics for HCM -
Learning -> How to achieve Fusion Security into Custom BIP Reports through SQL?Summary Apply fusion security into custom-sql reportsContent Hi, Can anyone please help? I am in the process of developing a few custom reports using sql/bip option and …SantoshKumarBhairi 112 views 3 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
How to setup private key authentication with sFTPContent Hi all, I'm trying to setup a sFTP connection to a vendor using private key authentication. I'm being told that Oracle needs to have a password setup, but the ve…User_2025-02-05-20-24-10-848 37 views 1 comment 0 points Most recent by Mike Borghoff Reporting and Analytics for HCM -
Is it possible to add the Business Unit to the email subject for holds invoicesSummary Is it possible to add the Business Unit to the email subject for holds invoicesContent Hi, The End user wants when receiving the email notifications for holds in…Mohamed jouini 44 views 1 comment 2 points Most recent by Edgar Nieto-Oracle Payables, Payments & Cash Management -
Printing the Entire Dashboard PageSummary Print the entire dashboard page on the My Team DashboardContent We have pushed out some dashboard reports for our end users. We have placed these reports on the …Shelly Feyerherm 64 views 4 comments 1 point Most recent by Shelly Feyerherm Reporting and Analytics for HCM -
Digital Signature issueSummary Digital signature on multiple pages in PDF outputContent We are using third party digital signature system. We are able to print the digital signature on the PDF…Shrikant Navelkar 83 views 6 comments 1 point Most recent by Shrikant Navelkar Payables, Payments & Cash Management -
Separate remittance advice format change to PDFSummary Changing the format of the SRA from HTML to PDFContent Hi All, Does any one of you know's how to change the format of the SRA to be in PDF when sent to supplier …Francis Thériault 52 views 5 comments 1 point Most recent by Lee Eslick-Huff Payables, Payments & Cash Management -
BI Publisher for WORD creates last row of a table as merged cellsSummary BI Publisher for WORD creates last row of a table as merged cellsContent With BI publisher for WORD I created a template with a table to be able to run the repor…Dena Swanson 37 views 4 comments 0 points Most recent by RaviThejaDarbha Reporting and Analytics for HCM -
Dashboard runs a report that opens a new window when it shouldn'tSummary As the title says, we have a Dashboard that runs a BIP Report and the run process pops the information into a new window. We aren't looking for this functionalit… -
Report AuditSummary Report showing when a report was last ran and by whoContent Hi All, I thought I saw this on a webinar, but I don't really recall. Is there a report in OTBI that …
-
Multiple IF ELSE Conditions in BIP Excel TemplateSummary Multiple IF ELSE Conditions in BIP Excel TemplateContent Hi Experts, How to use multiple IF else condition BIP Excel Template. Example: IF Legislation_Code IN ('…Bala Kasineedi 104 views 1 comment 1 point Most recent by Raghavendra M Reporting and Analytics for HCM
-
View only to details and attachments of an Expense ReportSummary View only to details and attachments of an Expense ReportContent Hi, Can you tell me if the Advanced Financial Controls allow you to setup access to grant someon… -
Hyperlinks in the email body doesn't workSummary Hyperlinks in the Automated BI Report email body is not workingContent Hi, We have created a BI report and scheduled to run and email the contents to specific us…Sathya Kannan 15 views 2 comments 2 points Most recent by Sathya Kannan Payables, Payments & Cash Management
-
Backend table name for error transactionsSummary Backend table name for error transactions generated from transaction ConsoleContent Hello Everyone, I'm trying to create a report to show data from the Transacti…
-
How to convert a datetime columns from a timezone to another oneContent Hi, we are trying to extract the start and end date of a learning activity in the correct timezone. as you can see in the screenshot we have created an activity …Alberto Boccato 21 views 2 comments 0 points Most recent by Alberto Boccato Reporting and Analytics for HCM
-
Repeated QC Taxes are getting added whenever we click on EDIT, to view the invoice detailsSummary Repeated QC Taxes are getting added whenever we click on EDIT, to view the invoice detailsContent Hi All, Created a invoice for QC tax in AP, the invoice is vali…
-
Digital Signature on the end of the pageSummary Digital Signature on the end of the page when the invoice is of 2 pagesContent We have Enabled digital signature but it prints the signature only on first page. …Manish Asawa 24 views 1 comment 2 points Most recent by Rahul Asthana-Oracle Payables, Payments & Cash Management
-
How to extract Report from BI publisher Using BICC as a single CSV/zipSummary Not able to extract as a single CSV from a reports of multiple view objectsContent Hi Team, I have a report based on Lead, in which we have customer details, pro…
-
Transaction Administration Real Time Subject Area - ReportContent Hi all, I am using this subject area to create report to pull the data about the pending transactions, however, we don't see that it has a dimension to show who …SunnyJaiswal 57 views 1 comment 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Is there a diagnostic report or other tool that will show Reports & Analyses that haven't been run iSummary Is there a diagnostic report or other tool that will show Reports & Analyses that haven't been run in 6 monthsContent Good afternoon. We are auditing our HCM BIP… -
Custom Account Hierarchy ReportContent How to built the custom Hierarchy report through OBIEE, Please let me know any sample sql query is available. Structure : ___________Corporate Account__________ …Deepak Prakash 80 views 2 comments 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Sales