BI Publisher
Discussion List
-
Is "EDI Location Code" available for Reporting in Customer Real Time Subject Area?Summary Is "EDI Location Code" available for Reporting in Customer Real Time Subject Area?Content Is "EDI Location Code" available for Reporting in Customer Real Time Su…Andrew_Schmitz 22 views 3 comments 2 points Most recent by Bhanu Gundala Reporting and Analytics for ERP -
Sending Reports to a Google DriveSummary: One of our customers is looking to have certain reports from ERP delivered to a Google drive location. Has anyone tried this and if yes how was it done? Any inp…Govind Srinivasan-Oracle 12 views 0 comments 0 points Started by Govind Srinivasan-Oracle Reporting and Analytics for ERP
-
Digitally Sign BIP report sent to SFTP server using BurstingSummary: Hi Team, Once we set up the SFTP server in fusion as a delivery option, there is a checkbox to sign output. So does it digitally sign the file and it will use w…
-
API to manage BIP Catalog ObjectsSummary: Content (required): We have a CatalogService WSDL to download and upload catalog objects, however, that API asks for passing the username and password in the Bo…Vinay Gharge 11 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
REST API to schedule and run report in Oracle Fusion BIP reportsSummary: REST API to schedule and run report in Oracle Fusion BIP reports Content (required): Version (include the version you are using, if applicable): 22D Code Snippe…
-
Need help in understanding the BIP SQL query (new to SQL and BIP)Summary: Hi Experts I'm new to SQL and BIP reporting. I'm working on one BIP report and I have added parameter to an existing BIP query to filter based on item number, a…Sharmava 37 views 2 comments 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP
-
Invoice History Report for a given supplierHi All Is there any standard report which allows to drill down open closed invoices per supplier and also drilldown to the individual invoices via deeplinks ? Thanks Mur…Murthy Kodavati 4 views 2 comments 0 points Most recent by Murthy Kodavati Reporting and Analytics for ERP -
Using rest api in fusion BI publisher data modelSummary: Is there any way to use rest api fusion BI publisher data model, I need to consume external data source and create a report in oracle fusion Content (required):…Shivaji Muttarapu HL 41 views 4 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP
-
Customizing Print Receivable Transactions: Invoices ReportSummary: We have this seeded report "Print Invoice Template" (Defaultinvoice.xdo) which has a corresponding ESS job "Print Receivable Transactions: Invoices" which is a …Ashu Raj-Oracle 51 views 8 comments 0 points Most recent by Sahil Makhiza Reporting and Analytics for ERP -
Schedule BI Report > Schedule tab > UTC Time ZoneSummary: Schedule BI Report > Schedule tab > UTC Time Zone Content (required): Hello All, When we schedule a BI Report from the Schedule tab: it seems the Time Zone of t…Bernard T 3 views 1 comment 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
Need a query to get negotiation approver list in oracle fusionSummary: Content (required): Hello everyone, I need a query to get negotiation approver list in oracle fusion.Please advise! BR, Sushan Peiris Version (include the versi…Sushan Peiris 12 views 1 comment 0 points Most recent by Sushan Peiris Reporting and Analytics for ERP -
Getting warning while creating Content Data setSummary: Getting warning while creating Content Data set Content (required): Hi All, Got a requirement to show attachments in the PO PDF report. So we try to customize t…
-
Where is WF_ROUTING_RULES located? Vacation Rules table?Content Hi, I'm trying to do reports for vacation rules and I have read I can use WF_ROUTING_RULES but or the life of me I can't find where these reside Any clues? Do I …King Jack 50 views 9 comments 2 points Most recent by Divya Mangtani Reporting and Analytics for ERP
-
Period name taken as a parameter tag display in a wrong format in excel outputSummary: Content (required): Hello Everyone, I recently created a BIP report using excel with the "xls" format and using the xml exported, I ,created the report in an ex…Sushan Peiris 21 views 3 comments 0 points Most recent by Sushan Peiris Reporting and Analytics for ERP
-
Extracting Other language description in OTBI ReportSummary: Extracting Other language description for Account Hierarchy in OTBI Report Content (required): Hi All, We are trying to build a OTBI report which displays Accou…Vaigu 21 views 1 comment 0 points Most recent by Bharath Raghupathi-Oracle Reporting and Analytics for ERP
-
SQL script for Roles , Privileges, Inherit roles & Data Security PoliciesSummary SQL script for Roles , Privileges, Inherit roles & Data Security PoliciesContent Trying to built a query to fetch Application Roles, Privileges, Data Security & …
-
How to customize Goal workflow notificationSummary: Content (required): Hi All, We have a requirement to customize the Goal workflow notification. we need to replace the word Goal with Objective. Is it possible ?…Venkatesan 1 view 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP
-
Can we define custom report view in custom reportDear , We have one custom report (SQL query), now our requirement we have to show data as per user login For example if User ABC login report shows only custom Data whic…
-
Fusion UI Customization TablesSummary: Fusion UI Customization Tables Content (required): Hi All, From which table we can get fusion page customization details like, who did the customization and the…
-
Need to move Profit and loss FRS report from one instance to anotherSummary: Content (required): I have created a FRS report of profit and loss statement and I need to move it to another instance. Any suggestions on how to do this Versio…AeeTee 11 views 1 comment 0 points Most recent by Mihaela Cozma GL_Oracle-Oracle Reporting and Analytics for ERP
-
How to create an OTBI Report to display POs by running for GL Parent/Child Department valuesSummary: How to create an OTBI Report to display POs by running for GL Parent/Child Department values Content (required): How to create an OTBI Report to display POs by …Abhilash K - Deloitte USI 13 views 4 comments 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
What System Role gives access to PER_LDAP_ROLES?Summary: What System Role gives access to PER_LDAP_ROLES? Content (required): Hi All, I keep forgetting and cannot find a document outlining this but what role gives acc…Nicolas_Trojack 2 views 1 comment 0 points Most recent by Mihaela Cozma GL_Oracle-Oracle Reporting and Analytics for ERP
-
COUNT Function to get specific valuesSummary: Hi Experts, I have created a report to get the sum of certain rows by specific values. For example, the column returns values as either "REC" or "UNR". So the r…
-
BIP Cloud - Deployment role missingSummary: BIP Cloud - Deployment role missing Content (required): Please note this idea is related to deployment of BIP reports on "BIP Cloud" Problem Description -------…
-
Rest API to GET reports from BIP in Fusion Financials SAASSummary Is there a Rest API to get BI Publisher reportsContent Hi All Is there a Rest API to call BI Publisher reports from Fusion Cloud Financials within SAAS financial…
-
A report for print options for AR customers - Missing FieldSummary: A report is required to detail the print options for AR customers The issue I am having is location the tables that hold Statement Preferred Delivery Methods fr…
-
How to link the sla to an invoice lineSummary: Need to link invoice lines to the subledger xla and xle files Content (required): Version (include the version you are using, if applicable): Code Snippet (add …
-
How to send and unsend a report based on its content in oracle BISummary: How to send and unsend a report based on its content in oracle BI Content (required): Hi everyone, There's a requirement to have a certain report output mailed …Sushan Peiris 21 views 3 comments 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP
-
OTBI Analysis: Is it possible to add a column that summarizes Invoice Amount by Supplier?Summary I'm building an analysis in OTBI and wanted to know if it's possible to have a calculated column that summarizes one of the other columnsContent I'm building an … -
Combine BiP and OTBI audit data in custom reportSummary: Is it possible to combine BiP and OTBI audit data? Content (required): We have enabled the BiP audit feature and have compiled an OTBI audit report. Business is…Stefan pettersson 11 views 3 comments 1 point Most recent by Dhruvjoshi23 Reporting and Analytics for ERP