BI Publisher
Discussion List
-
BIP Scheduler is not working for Monthly jobI have scheduled my BIP report for 1st weekday of every month but it is not triggered. I have attached Screenshot of my schedule. Please Advise. Thank You, Khushi -
How to capture Tax Classification Code at Supplier Address level in OTBI report.Hello Experts, we want to capture the Tax Classification Code at Supplier Address level using an OTBI report. We are checking on Supplier Real Time subject area. Is ther…
-
Oracle Fusion BIP Report ESS Job Parameter Error & How to Enable XML and Diagnostic LogsHi Team, I’m facing an issue when scheduling the ESS job — as soon as I select the parameters, it immediately throws an error. The current log doesn't provide enough inf…Ashish1Soni 11 views 1 comment 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
Convert SYSDATE from UTC to the local timezoneSummary: Hi, I s there any way to convert the returned sysdate value from UTC Timezone to local TimeZone in Oracle Fusion BIP reports? We tried many recipes for that, bu…Taha.Elsisi 7 views 2 comments 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
How can we see the Reports which are there in My folder of Other UsersSummary: We want to see the reports which are there in My Folder of all other Users. Is there any other way we can do this without logging into each individual user and …Shrikrushna 64 views 15 comments 0 points Most recent by Shankar-Oracle Reporting and Analytics for ERP
-
MSC_HVGOP_WEEKLY_ALLOC_REPORTSummary: How can i join this table with Item related Tables Content (please ensure you mask any confidential information): Version (include the version you are using, if…
-
Issue with RTF Template – Pivot Table MergingSummary: we are using a Pivot Table to display invoice data for suppliers across different legal entities over a six-month period (from the given reference period). Issu…
-
Budget Override Request NotificationSummary: How to customize Budget Override Request Notification Data Model to enhance the Notification? Content (please ensure you mask any confidential information): Cur…Kalyani-Oracle 84 views 2 comments 0 points Most recent by Mohamed Bahgat AbdelFattah Budgetary Control
-
Are there any roles to provide read-only access to a data model in oracle fusion?Summary: Hi, I want to provide read-only access to one data model to one of our users. Is there any roles or configurations that will help in providing read-only access …NagarajuKunchala 16 views 1 comment 0 points Most recent by Dhilip Kumar P. Reporting and Analytics for ERP
-
How to get FCCS data to BIP?We have a requirement to get data from FCCS, to create a BIP report. Is there a way to add FCCS as a data source in BI?Abhilash Baggam 12 views 2 comments 0 points Most recent by Rich Merkel Reporting and Analytics for ERP
-
How to get the last period of previous fiscal year in FRSThere is a requirement in balance sheet report where we need to get the details for Previous Year Ending(PYE) balances in one of the column in FRS report. For Ex: Curren…SRIKANTH DEVARASHETTY 26 views 2 comments 0 points Most recent by SRIKANTH DEVARASHETTY Reporting and Analytics for ERP
-
How can we identify the list of BIP/scheduled reports that are currently being transmitted to FTPSummary: We need a list of reports from Fusion that are currently being transmitted to the FTP server as part of the requirement to transition to a more secure SFTP serv…Naga Peddiraju Chennu 44 views 3 comments 0 points Most recent by Viraj Padwal-Oracle Reporting and Analytics for ERP
-
Do we have any option to download CSV File - rather than getting displayed in browser output ?Hi team, Do we have any option to download CSV File - rather than getting displayed in browser output ? Our data output file size is more than 100 MB , we want to downlo…Sridhar Gupta Yerram-Oracle 22 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
How do i know which field in the fusion frontend is related to which table column in backend?Hi Experts I am new to BIP report development. Customer sometimes just give screenshot from fusion and ask to create report with those field . Is there any way where i c…Mainur-Oracle 13 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
How to link GL journals to external cash transactionHi Team, I would like to create a custom BIP report to link GL journals to external cash transaction. How can I trace back from GL journal to external cash transaction? …
-
Excel template - with CSV Output -- Do we have an option to hide parameters ?Hi team, Excel template - with CSV Output -- Do we have an option to hide parameters ? -SridharSridhar Gupta Yerram-Oracle 22 views 3 comments 0 points Most recent by Shankar-Oracle Reporting and Analytics for ERP
-
Excel template- Why the column header is not copied into other sheet- for rec# > 65KHi team, When the output has more than 65K records - Excel output is getting generated with multiple sheets, but only the first sheet has column name, remaining sheets d…Sridhar Gupta Yerram-Oracle 2 views 2 comments 0 points Most recent by Shankar-Oracle Reporting and Analytics for ERP
-
Fusion BI Report Time zone issues in report output related queriesOur users are in PST Timezone and has raised concerns about report outputs being in UTC Timezone. We are trying to update report code and wanted to clarify few queries b…Abhilash K - Deloitte USI 415 views 8 comments 1 point Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
How to create data control name while registering ESS jobHi, We have requirement to modify default parameters of the seeded ESS Job. Parameters controls by the "Data Control Name" . Is there any feasibility to create a new "da…
-
BIP Report - Security - Role/Privilege required to access data in XLA tablesSummary BIP Report - Security - Role/Privilege required to access data in XLA tablesContent Hello, We developed a custom BI publisher report having XLA tables in the Dat… -
I am not able to see few terminated PPRs in iby_pay_service_requests tableSummary: Some of the terminated PPRs in the iby_pay_service_requests table are not visible to me. Does this table lack any security or data access? Despite the fact that…Lakshmi Bandlamudi 2 views 2 comments 2 points Most recent by Mohanasindhu Dhiraviyam Reporting and Analytics for ERP
-
Customize Printable Expense ReportSummary & Content: Need details for the other VOs and the attribute list similar to what was provided for PrintableReportVO and PrintableExpenseVO in the Oracle Ddocumen…Upendra Nayak 93 views 3 comments 0 points Most recent by User_QPZXD Reporting and Analytics for ERP -
Question about Infolet on ERPHi Team, Our client is currently undergoing a process to revalidate user privileges. During this process, we observed that simply accessing the pages and viewing the Inf…Oscar Chahestian-Oracle 25 views 4 comments 0 points Most recent by Oscar Chahestian-Oracle Reporting and Analytics for ERP
-
Call back event for ESS-Jobset at OICSummary: Hi , We have a requirement where we are trying are to send multiple bulk export of data(AP,AR,GL) using a custom ESS job set. In that there is call back event i…
-
Permission Error When Trying to Migration BIP Reports between DEV and SAT environmentsSummary: We've setup a pipeline in VBS and are using a job to migrate data models and bip reports from one region to another and running into a permissions error on our …User_2025-03-07-05-28-28-079 62 views 10 comments 0 points Most recent by Choudhary Punit Reporting and Analytics for ERP
-
with clause subquery and function together and usage of bind variableSummary: Hi Team, I am facing an error as "ORA-17003: Invalid column index". I am using functions(with clause) and I have to get the value from the BIP report parameter.… -
When Scheduling a Bursting Report, the Parameters in trigger are Not Loading on the Schedule TabI have a BI Publisher data model that accepts a :from_date parameter and includes bursting logic. To handle the "no data found" scenario during bursting, I created a tri…Voladri Saikiran 32 views 1 comment 0 points Most recent by Shradhanjali_Oracle-Oracle Reporting and Analytics for ERP
-
Plsql procedure from a Saas Report or Saas page?Summary: Invoking pl-sql procedure from SaaS Report or through a SaaS link on a page Content (please ensure you mask any confidential information): We haven't OIC. We'd …Luca Nobili PWC 21 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
How to control the scheduled BIP report Output based on Row CountRequirement : BIP report schedule daily - which is configured to send an email - base don the configured emails. Is it possible to control sending an email based on the …Sridhar Gupta Yerram-Oracle 3 views 1 comment 1 point Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
BI table for AR transaction approvalHi Team, Please help to get table that stores AR transaction approval History. I am not able to find any dedicated table like AP Invoices (AP_INV_APRVL_HIST_ALL). Also t…