BI Publisher
Discussion List
-
How to format date column in Excel Template without adding another columnSummary: I am able to format date column in excel by adding another column and using =DATEVALUE function as suggested in below link, but I want to format date in current…Meer Muzafar Ali 21 views 1 comment 0 points Most recent by Razvan Paduraru-Oracle Reporting and Analytics for ERP -
Why BU is a mandatory parameter in ESS job of Uninvoiced Receipts Accrual ReportWe have a business requirement to run Uninvoiced Receipts Accrual Report for all the BUs. But using the ESS job we can select only one BU at a time. Tried to execute or …DebasmitaDas123 11 views 3 comments 0 points Most recent by DebasmitaDas123 Reporting and Analytics for ERP
-
Bursting Email attachment with a constant attachment.Summary: Is there is any possible way to add an extra constant attachment (pdf) to send an email bursting along with report attachment? If it is Possible please help me …Goutam5555 11 views 1 comment 1 point Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
Can we schedule a BI Report run and place the generated file in an SFTP location?Summary: Can we schedule a BI Report run and place the generated file in an SFTP location? How can we do this?
-
How to call an Integration in OIC from ESS Job in Oracle Fusion SaaSSummary: How to call an Integration in OIC from ESS Job in Oracle Fusion SaaS Content (required): I have an Integration in OIC and I want it to be triggered by submittin… -
Report on inception to date activity on the Revenue aspect/Invoice aspect Development SOW projectsHello, We have a required to build a BIP report on inception to date activity on the Revenue aspect/Invoice aspect Development SOW projects. We need to fetch the financi…
-
General Guidance on BICC/BIP for PVO JoinsSummary: General guidance on Fusion BICC/BIP for PVO joins & if Fusion supports AI/ML analytics? Content (please ensure you mask any confidential information): My unders…
-
OTBI time out for regular user super user runs in 22 secondsSummary: We have an OTBI analysis that we built. Content (please ensure you mask any confidential information) For a super user it runs in 22 seconds, but for a regular … -
Is there any method to output a certain number of lines without destroying BIP Excel template layoutSummary Is there any setting/method to output a certain number of lines without destroying the BIP Excel template layout? Content Hi, We are conducting feasibility verif…
-
query to get a tax registration number for legal entitySummary: query to get the tax registration number for legal entity Content (please ensure you mask any confidential information): I want to create a SQL to retrieve a ta…
-
How to execute BIP report and get a PDF file by calling SOAP web service ?Summary: How to execute BIP report and get a PDF file by calling SOAP web service ? Content (please ensure you mask any confidential information): BIP reports were run u…
-
Combine OTBI and BIP report, role issue/quesitonSummary: I have created a report where I combine OTBI and BIP report in one BIP datamodel. This is due to missing information on OTBI side. Report works as a charm but l…alexey.shtrakhov 71 views 5 comments 0 points Most recent by alexey.shtrakhov Reporting and Analytics for ERP -
Unable to find create data model option after adding related BI rolesSummary: Hi Team, To one of the user account, we wanted to provide access to BI Currently after providing 'BI Administrator Role' and 'BI Publisher Data Model Developer …
-
How to disable the Open option on Reports & Analytics Catalog?Summary: How to disable the Open option on Reports & Analytics Catalog? Among the various reports offered out-of-the-box by the Oracle Fusion modules, some of them can b…User_2025-02-11-06-12-35-024 840 views 11 comments 0 points Most recent by Eswarvoona-Oracle Reporting and Analytics for ERP -
Conditionally display columns in an BIP etext rtf template.Summary: Example out of 50 columns, first 30 and last 10 columns will show up always and 10 columns in the middle will show up only on a certain condition. Note: The req…Sunil Pradhan 66 views 1 comment 0 points Most recent by Lucky Sharma Reporting and Analytics for ERP -
Chinese letters turning to special character when extracting via CSV BIPHello Oracle, Is there a way to adjust the output character set when extracting a BIP Report (Oracle BI EE Data Source) to CSV? We are having issues when extracting Chin…Ralph Aldrich Magno 11 views 1 comment 1 point Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
Fetching Flow Through Funds fields under Grants module in Base tablesWe are unable to fetch values in Base tables for Flow-Through Funds fields like Sponsor , Reference Award Name, Amount under Grants module. PFB the required fields viewe…PrerakKhandelwal 23 views 1 comment 0 points Most recent by Meredith Bickell Reporting and Analytics for ERP
-
Is it possible to BICC Export a file to FTPSThe client need a way to download/export the BICC file from UCM to client File Transfer Protocol Server. Is there any way to do this?Pedro Bacic 23 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
Table to find PO line level attachmentsSummary: We can see line level attachments on the PO page. However, we don't see the attachment details for all the lines in the fnd_attached_documents table. We also ch… -
Change Excel Sheet name in BI Publisher TemplateContent Hello, Is it possible to rename the Excel Sheet names of a BI Publisher Template Report [Type xpt] which has default output format as Excel (xlsx) ? I have creat…Nalinee Uppiah 1.2K views 6 comments 1 point Most recent by Shravan S Kumar-Oracle Reporting and Analytics for ERP
-
Why the printing from the fusion is different from a laptop to another ?!Summary: I've tried to print a report from the fusion (its layout is made by the word in a RTF format) and it's been printed correctly on my laptop but the other laptops…User_F2YWU 11 views 4 comments 0 points Most recent by Shravan S Kumar-Oracle Reporting and Analytics for ERP
-
What tables should I consult to relate the details of budget control associated with obligations ...Summary: We are developing a report in Oracle Publisher related to budget control, but we are unable to find the necessary documentation. We need information on Budget T…OsvaldoFI 1 view 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
Payables XML can't perform a substring to a concatenated string inside a for-eachSummary: When creating a payment request, we need to have all invoice numbers concatenated in the same field "Ref" from the XML template. However, the bank only allows l…Emma Fayos García 1 view 1 comment 0 points Most recent by Janaki Ankam-Oracle Payables, Payments & Cash Management
-
Adding manually uploaded attachment in Email BurstingSummary: Is there a feasibility to attach manually upload files in Email Bursting along with Bursting output Content (please ensure you mask any confidential information…Rukmini Kumbham 184 views 9 comments 1 point Most recent by MFM Tech Reporting and Analytics for ERP
-
Request for Custom SQL Query for SaaS Service Usage Metric Report (Oracle Fusion Expenses)Hello Team, We are in a need of a custom sql query which Oracle uses to populate a count for the below service in the SaaS Service Usage Metric Report, as we got to know…
-
Oracle Fusion Cloud Sustainability posibility to report via OTBI/Subject AreasThere is a module available for all ERP customers where you can store sustainability data. Created via AP invoices or imported via external systems. This is something th…AnnelizeHenskens 1 view 2 comments 0 points Most recent by AnnelizeHenskens Reporting and Analytics for ERP -
How to output of a BIP Report in multiple excel sheets in XLSX format?Hi we would like to know if there is the way to output of a BIP Report in multiple excel sheets in .XLSX format. Currentry we can see only .XLS format is avaiable when E…Karen Ito-Oracle 73 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
How to create Bursting without linking / upload attachment to a Transaction?Summary: Hello, we are using a customized Datamodel for the Print Receivable Transactions process. We also use our own bursting which creates multiple PDFs for a transac…Frank.Steinjan 11 views 1 comment 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections
-
Is it possible to set separate Permissions for My Folder and Custom folder (under Shared Folders)?Summary: The requirement is to provide access to create Data Model, Report and Analysis under My Folder in Oracle BI Catalog and for the same user provide read-only acce…
-
How can we get the Project information in subject areas 'Fixed Assets - Asset Transactions Real TimeSummary: Hello Team, I am using this subject area to get the asset transactional details. But unfortunately, I am unable to get all the details such as Project informati…Suhitha K-Oracle 21 views 1 comment 0 points Most recent by Nidhi Chhajed Reporting and Analytics for ERP