BI Publisher
Discussion List
-
Remove DuplicatesSummary Remove DuplicatesContent How to remove duplicates from Excel template? Regards, ReddykrishnaReddykrishna Chidella-Oracle 53 views 3 comments 0 points Most recent by Karen Long Reporting and Analytics for HCM -
Unable to add Negotiation Icon to the Springboard and Navigator.Summary Unable to add Negotiation, SQM, Catalog Icons to the Springboard and Navigator.Content Hi Fellow Practitioners, Season's greetings. I have done all the necessary…Prateek Moroney 159 views 1 comment 0 points Most recent by Yogesh_P-Oracle Reporting and Analytics for SCM -
Send a system notification for all employeesSummary Send a system notification(Not an email) to all employees of their previous day attendance reportContent My requirement is , need to send a system notification t…Murugesu.V 39 views 3 comments 0 points Most recent by HarishVummidi Reporting and Analytics for HCM -
Merge Values Created By Duplicate Sales Stage NameSummary Merge Values Created By Duplicate Sales Stage NameContent Hi, I created an analysis in OTBI and the Sales Stage Name is creating two sets of # of Opportunity Val…User_2025-07-18-06-07-44-367 34 views 1 comment 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Sales -
What date format do I need to use in order to calculate the days between one date and another?Summary What date format do I need to use in order to calculate the days between one date and another?Content Hello I am busy creating a data model for a BI report. In t… -
Need a SQL query to fetch Previous salary and previous assignment working hours of an employee.Summary Need a SQL query to fetch Previous salary and previous assignment working hours of an employee.Content Hello, I have a requirement to fetch Previous salary and p…User_2025-02-10-16-28-01-402 1.1K views 2 comments 0 points Most recent by User_2025-02-06-20-13-56-572 Reporting and Analytics for HCM -
SQL Code to Extract Setup Grade Rates with Grade NameSummary SQL Code to Extract Setup Grade Rates with Grade NameContent Team, I have a similar requirement. I am trying to fetch the setup data of Grade Rates with Grade na…User_2025-02-01-03-43-13-079 155 views 3 comments 0 points Most recent by Rajeev Nayan Reporting and Analytics for HCM
-
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 287 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 109 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 81 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 107 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 14 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