BI Publisher
Discussion List
-
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 51 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 11 views 2 comments 0 points Most recent by Murthy Kodavati 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 559 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 24 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 288 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 272 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 141 views 3 comments 0 points Most recent by Sushan Peiris Reporting and Analytics for ERP
-
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 21 views 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 72 views 1 comment 0 points Most recent by Mihaela Cozma GL-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 22 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 21 views 1 comment 0 points Most recent by Mihaela Cozma GL-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…Vipusha Chandrakumaran 89 views 3 comments 0 points Most recent by Vipusha Chandrakumaran Reporting and Analytics for ERP
-
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…User_2025-02-11-10-53-01-866 43 views 2 comments 0 points Most recent by User_2025-02-11-10-53-01-866 Reporting and Analytics for ERP -
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 42 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 43 views 3 comments 1 point Most recent by Dhruvjoshi23 Reporting and Analytics for ERP
-
how to define a xml in rtf if there are multiple datasets with the same column nameSummary: Hi everyone, Recently I faced an issue with a seeded report that was customized. The report had two datasets with the same column on both, where when I try to l…
-
Error : Exceeded configured maximum number of allowed output sectionsSummary: Error : Exceeded configured maximum number of allowed output sections Content (required): Hi Experts, We are trying to run thr report " Payables Credit Memo Mat…Vipusha Chandrakumaran 466 views 1 comment 1 point Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP
-
Prepayment invoice detailsSummary: Prepayment invoice details Content (required): Hi experts, I got new report requirement to display prepayment invoice details based on as on date. 1. prepayment…
-
BI Bursting - ZIP text files during deliveryHi All Is it possible to zip the text files from BI FTP bursting ? ThanksMurthy Kodavati 247 views 2 comments 0 points Most recent by Murthy Kodavati Reporting and Analytics for ERP
-
customizing Receivables Aging by General Ledger Account ReportSummary: I'm trying to customize the Receivables Aging by General Ledger Account Report, but I'm not able to get any sample data. Content (required): I have created a co…Anders W. Langholm 203 views 3 comments 0 points Most recent by AeeTee Reporting and Analytics for ERP -
What role is needed to run ESS job Vertex Payables Transaction Tax Action Report ?Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Anthony Cambria 58 views 4 comments 0 points Most recent by Murali Gangidi Reporting and Analytics for ERP
-
performance between xmlpserver/services/ExternalReportWSSService versus more api rest in integrationSummary: performance between xmlpserver/services/ExternalReportWSSService versus more api rest in integration on oic Content (required): hello I could to know that diffe…Alessandro_Moccia 22 views 0 comments 0 points Started by Alessandro_Moccia Reporting and Analytics for ERP -
BICC - ability to product a single CSV output merging data from many data stores/VO'sSummary: Does BICC support selecting columns from different data stores/PVO's and apply query filter? Content (required): We have a business requirement to extract large…Arun N-OC 363 views 8 comments 2 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for ERP
-
Customize Receivables aging seeded ReportSummary Customize Receivables aging seeded Report - to include Project information and grouping totalsContent Hi, We want to customize Receivables aging by General Ledge…User_V0Y9V 621 views 7 comments 6 points Most recent by Anders W. Langholm Reporting and Analytics for ERP