BI Publisher
Discussion List
-
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 82 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 66 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 235 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 21 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 …NitinSharma28 3 views 1 comment 1 point Most recent by Akshitha Vyas Reporting and Analytics for HCM -
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 138 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
-
Transaction console approvals reportThe user is asking for a BI report that shows all the approvals for a transaction in HCM, right now I'm able to find the current and historical approvals but I can't fin…RODOLFO GARCIA SOTELO 53 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM