BI Publisher
Discussion List
-
Any one has idea on Pivot table in rtf, need some help on itAny one has idea on Pivot table in rtf, need some help on it. It is allowing only 5 columns, can we extend it more than 5 columns and also grouping data , need it to be …LakshmiVanarasi 1 view 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
display hyperlink in messagesHello I am creating a new message from Manage messages and I am retrieving this message from BI query. I would like to have a hyperlink in the message when I am creating…Swapna Rachamalla 11 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
How to give Unarchive option in Custom folder which is read only for a user in BI Catalog?Summary: We have a custom role which gives read only access to the Shared Folders > Custom folder. We also want to provide Unarchive access under the Custom folder. The …Bishal Dutta 41 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
performance issue in transaction listing reportSummary: I am trying to optimize the performance of GL transaction listing report. It is taking longer time to load the report & after 30 mins it is getting failed while…Abhijeet Tamoli 111 views 6 comments 0 points Most recent by emmamccrory Reporting and Analytics for ERP -
How to split the selected areas of the BIP Excel sheet into different sheets according to numberSummary: Is there a way to split the selected areas of the BIP Excel template sheet into edifferent sheets according to number? Content: Hi, we are trying to build BIPub…M Watanabe 81 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
Request for Information on Managing Budget Versions Approver details in fusion TablesSummary: I am currently working on a requirement to display the approver's name and the submitted person’s name for budget versions in our Grant Management system. Howev…Chetan Yeola 1 view 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
How to Display Date and Time as per User Preference in Excel TemplateSummary: Not getting data as per the user general Date Format/Timezone preference in EXCEL template for BIP report Template build in RTF, is working fine as per User Pre…sudipta.mandal 23 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
FTP Files of BI Publisher Report Via Bursting > Defining The Bursting QuerySummary: FTP Files of BI Publisher Report Via Bursting > Defining The Bursting Query Content (required): Hello All, We would like to send a report generated in CSV forma… -
Need inputs to display Town_or_city, Region_1, Region_2 and Region_3 values in BIP reportSummary: Need inputs to display Town_or_city, Region_1, Region_2 and Region_3 values in BIP report Content (please ensure you mask any confidential information): We have… -
How to create View Image in AP invoice pageSummary: How to create View Image in AP invoice page Content (please ensure you mask any confidential information): Hi All, We got a requirement to create one button and…Venkatesan 12 views 1 comment 1 point Most recent by Venkatesan Payables, Payments & Cash Management -
Unable to Cancel AP Invoice(I Supplier Portal) using Rest API.Summary: Hi All, Our business receives a lot of invoices thru Supplier Portal, and some of them are rejected in the approval process. However, if the rejected invoices a…K venkatesh 62 views 2 comments 0 points Most recent by K venkatesh Payables, Payments & Cash Management -
How to check the which stage of TLSS workflow transaction got flagged incomplete?Hi Team, Could you please confirm Is it feasible to add a column to identify in which stage of TLSS workflow transaction got flagged as incomplete, for example while doi… -
sql query to get resignation approval statusSummary: Hello , I need to add column "pending with " in BIP if Resignation is pending for approval with Line Manager then "pending with "column should display "pending … -
can we hide a WF Notification hyperlink with BIP and RTF template based on a security roleSummary: HI Reporting and Analytics forum esp BI Publisher gurus: Is there is an easy way to hide a URL hyperlink on a Notification page (RTF BI Report -side) also based… -
BIP reportsSummary Apply data restrictions on BIP reportsContent Hi , Is it possible to place restrictions on a BIP report output based on Role ? eg: I have a BIP report to display…User_2025-01-30-00-14-06-021 91 views 12 comments 0 points Most recent by llnl_jtw Reporting and Analytics for HCM -
Does fusion have any MEXICO DIOT report readily available ?Summary: Looking for standard Mexico DIOT report Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable… -
I am trying to add intermediary bank accounts to our Wire Payment formatSummary Trying to add intermediary banks to our Wire Payment format for boa using a BAFF file formatContent I am trying to add intermediary banks to the payment formats …ChrisKellogg 234 views 17 comments 1 point Most recent by Glen Ryen Payables, Payments & Cash Management -
How to print page number only in last page in rtf templateHow to print page number only in last page in rtf templateLakshmiVanarasi 24 views 1 comment 0 points Most recent by Razvan Paduraru-Oracle Reporting and Analytics for ERP -
List of Approvers in Workflow NotifcationSummary: List of Approvers in Workflow Notification Content (required): Hi , I need a list of Approvers who are going to approve the transaction in below format. I have … -
Cannot find GL_JE_LINE table when trying to create Data Model for BIP. "SELECT * FROM GL_JE_LINE"When I try to run this sql in a data model it says the record does not exist, but I'm positive it does. Any ideas why we can't select from it? SELECT * FROM GL_JE_LINEWilliam Jordan 11 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
how to group multiple datasets into single table in RTF template for HCM Global report extract?Hi I am trying to create RTF template from global report data model for HCM. there are 15 data sets into this data model. I need only 4 attributes from 2 data sets Basic… -
Journeys - Application task type - Talent Profiles no longer worksSummary: Task type is Application and Application Task is Talent Profile. However, when clicked on Go to Application Task, page doesn't moves to Talent Profile Page Cont… -
URL from HCM Cloud page with one of the parameters = NUL not opening BIP reportHello We had a requirement to open a report from HR Help desk page. Initially we had OTBI report with 2 parameters, Primary Person ID and Affected Person ID. Even if the…Naveen Jayaraman 1 view 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
can we restrict/hide viewing few columns based on rolesIn custom reports, i want to hide few columns based on the roles. I want to restrict the access of columns to few employees only. Is it possible to achieve? -
How to Hide Row in BI Publisher Using Conditional RegionSummary: Hi Expert, I'm trying to hide a row based on a simple condition. We have three rows in the offer letter, and the condition is that if the attribute value is nul… -
SQL Query based on date input value errorSummary: SQL Query based on date input value error Content (please ensure you mask any confidential information): We are trying to run the below query to be used in a va… -
Getting error while bursting BIP report output to sFTP serverSummary: Getting below error while bursting BIP report output to sFTP server- Below is my SFTP bursting query- *with hash_q as query* select distinct HASH "KEY", 'MicroS…Neha Aishwarya 121 views 1 comment 1 point Most recent by Lucy Garding Reporting and Analytics for ERP -
losing headcounts while using some columns in parameter FDIHello I'm facing an issue while using a parameter in FDI for the subject area HCM - Workforce Core. below an example when I use this paramater, I get the right headcount…Ayoub AFRASS 11 views 2 comments 0 points Most recent by Ayoub AFRASS Reporting and Analytics for HCM