BI Publisher
Discussion List
-
LUHN check digitHI All We use LUHN check digit part of the check numbers and transaction numbers extract from ERP to the client payment systems. This is a common requirements in the pay…Murthy Kodavati 1 view 1 comment 0 points Most recent by Murthy Kodavati Reporting and Analytics for ERP -
How to pass multiple values in a single parameter in OTBI agent?I have a requirement to prompt user while running an OTBI agent. But I don't see that option. Is there a way we can pass multiple values in a single parameter by using O… -
BIP Vs OTBI What is the practicality of moving BIP reports to OTBI?Summary: I am recommending that my client investigates the possibility of using OTBI in preference to BIP for their reports (including whether this is just for new repor… -
Front-Loaded Accrual BalanceContent I've been trying to create an Absence Balance OTBI Report that reports both the Incremental and Front-Loaded Balances (for the Incremental Accrual Balance, I use… -
Fetch the BIP report Scheduled output bursting detailsSummary: I need to fetch the details like , Output name, Template, Format. is there a table to fetch this details of the scheduled output ? Thanks for the help in advanc…Vishal Purohit 51 views 6 comments 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP -
I'm unable to upload rtf template in report or it is showing uploading since long timeSummary: I'm unable to upload rtf template in report or it is showing uploading since long time. Content (please ensure you mask any confidential information): Version (…Anup Karmankar 113 views 5 comments 0 points Most recent by Vijayhcm Reporting and Analytics for HCM -
Min-Max Planning Details Across All Orgs ReportSummary: Needs a query to fetch the Min/Max details for all the items across all the inventory organization in the application. Content (please ensure you mask any confi…Mamdouh Ahmed 61 views 2 comments 0 points Most recent by Mamdouh Ahmed Reporting and Analytics for SCM -
Change Text format in dashboard BI publisherHi, is it possible change text format (size, format, color,…) in caption inside "Link or Image" in BI publisher dashboard ? Thanks, Han Xi ZhaoHan Xi Zhao 41 views 1 comment 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
how to do sql query Report Job ID(Report Job History)Summary: How to do sql query Report Job ID(Report Job History) Content (please ensure you mask any confidential information): Look like this Report Job ID is not Correct… -
BIP Pivot Table Row Label Header PropertySummary: Hello, I'm trying to have a header label for my rows in a pivot table in BI Publisher. I'm using the Row Label Header property but does not show anything. Can y… -
Deep Link for payment view in oracle fusionSummary: Please provide the deep Link for payment view in oracle fusion. Content (please ensure you mask any confidential information): Version (include the version you …User_B1ZBU 21 views 3 comments 0 points Most recent by AvinashRN Payables, Payments & Cash Management -
Retro ReportsSummary Retro ReportsContent EDIT: The newer version, after few bug fixes, can be found hereAllen D'Souza-Oracle 259 views 9 comments 3 points Most recent by Jim Kirkpatrick-Oracle Reporting and Analytics for HCM -
Query to Fetch Tax Calsification Code Value From the Transaction LineSummary: We have a requriement to create a report to fetch Tax Classification Code value from the transaction line Content (please ensure you mask any confidential infor…Mamdouh Ahmed 21 views 4 comments 0 points Most recent by Mamdouh Ahmed Reporting and Analytics for ERP -
Send Dunning Letter Job getting errored out while trying to load new templateSummary: Hi Team, Send Dunning Letter Job getting errored out while trying to load new template. Attached the error details. Thanks. Vidhya Content (please ensure you ma… -
Fusion BI Publisher – FTP Delivery Fails on First Burst, Any Delay/Event Option?Summary: Issue Description We are using BI Publisher bursting to generate CSV output and deliver files to an FTP server. Observed behavior: During the initial scheduled … -
SQL to get the ESS job run details with Parameter ValuesSummary: We have a requirement to analyse the performance issues for some of Project application ESS jobs for our client. TO this end, I would like to see get an extract…Rakesh Viswam-Oracle 522 views 7 comments 0 points Most recent by User_EFY2A Reporting and Analytics for ERP -
How to attached Invoices to Payments Remittance Advice Notification via EmailSummary: The accounting team is requesting to attach the invoices to the Payments Remittance Advice Notifications sent via Email Content (required): We have a custom pay…Patricia Gonzalez 81 views 4 comments 0 points Most recent by Rohan Kamat Payables, Payments & Cash Management -
Read excel file with querySummary: Content (please ensure you mask any confidential information): In a datamodel I have a query dataset linked with an excel dataset: The excel is used to translat…Stefano_Mazzocca 101 views 19 comments 0 points Most recent by Stefano_Mazzocca Reporting and Analytics for HCM -
Issue in Salary Certificate DORSummary: Issue in Salary Certificate DOR Content (required): Hi All, We are facing the issue in salary certificate DOR. Salary certificate is working fine in draft versi…Venkatesan 51 views 3 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
How does Print Receivables Transactions divides the transactions into batches for processingSummary: Hi, We have queries on the functionality of following Standard process: Parent Job-Print Receivable Transaction Child Job- Print Receivables Transactions: Invoi…Pooja K 61 views 3 comments 0 points Most recent by Rasheed - Fusion Support Engineer-Oracle Receivables & Collections -
Is there a Receivables equivalent for the "Payables Unaccounted Transactions and Sweep Report"?Summary: Looking for a report that shows what has been swept and what had been accounted. The only workaround I can think of is reviewing the Sweep output report after i… -
Exception Report for Inventory Pending TransactionsSummary: We need a query to get the details of the Inventory Pending Transactions. Content (please ensure you mask any confidential information): We are seeking a PL/SQL…Mamdouh Ahmed 41 views 2 comments 0 points Most recent by Mamdouh Ahmed Reporting and Analytics for SCM -
person security profile required to custom query to restrict location and email?Summary: Summary: threre is location page- hr1, hr2 and hr3 are DFF stored employee emails. suppose one of the employee login as HR , all location assoicated to hr emial… -
How to output a list of all reports and their folders in Production environmentSummary: We are trying to map all reports in our production environment, with their folder locations. Does anyone know of an administrative tool that might be able to ou…Rich R 1.7K views 31 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM -
How can we query the error message in BI Server's Report Job History?Summary: Error Log Report that will display the error message like in the Report Job History Content (required): Hi, We wanted to create a custom report that will output…Kristelle 442 views 17 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP -
How to find the difference between two date attributes in eText templateSummary: We need to find out the difference between two dates and add 1 to the result in eText template. Content (required): We need to find out the difference between t…Meenakshi K 1.3K views 9 comments 0 points Most recent by Ruma Bhatnagar-Oracle Reporting and Analytics for HCM -
Receivable Module : Print Attachment without Invoice Print BI reportOrganization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Description (Required): Hi team, We h… -
Could not establish connection. java.net.ConnectException: Connection timed outSummary: Could not establish connection. java.net.ConnectException: Connection timed out Content (please ensure you mask any confidential information): We are trying to …Sai Krisna 86 views 5 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM