BI Publisher Reports
Discussion List
-
Need table joins between Inventory On hand table and Review completed TransactionsSummary: Hi Team, We have a business requirement to build a report with below columns : Item Item Description Item Category On hand Original Review completed date Wareho… -
Need to know the exact submission date for a Qualification area response from SupplierSummary: We are facing an issue - wherein if the Supplier responds to the same question in multiple different Qualifications, the latest answer is getting populated in a…
-
Procurement Dashboard not showing amounts in ledger currency USDHi, We are using the standard procurement dashboards "Procure to Pay." Our ledger functional currency is USD; however, we have observed that the values displayed in the … -
Some Character in "Madani Arabic" Font visible not correct in the view PDF report.Summary: Some Character in "Madani Arabic" Font visible not correct in the view PDF report. the font installed correctly and RTF file also correct. but while view PDF fr…
-
Which table can I use to extract the Award Approved Date for each RFQ?Which table can I use to extract the Award Approved Date for each RFQ?
-
To print a PO Report after clicking on SaveClient Requirement: after creating a PO and clicking on save, the client wants to auto-print a custom report we have developed for him. is this functionality standard in… -
How to customize confirm receipt notification in fusionSummary: How to customize confirm receipt notification in fusion Content (please ensure you mask any confidential information): Is it possible to customize receipt notif…
-
How to apply modifications to the Redwood Oracle Analytics Publisher template?Summary: We have been using a customized template for Requisition Approval Notifications. As per Oracle documentation, starting from 25A, businesses are required to reap…Vikrant Bhardwaj-Oracle 51 views 1 comment 0 points Most recent by Vikrant Bhardwaj-Oracle Reporting and Analytics for SCM
-
How to translate data to a local language using BIP Template in FusionSummary: Hi oracle experts, We are trying to customize our PO Print Template by translating it to a local language (like Japanese), but we are only able to translate the…
-
Print Min-Max Planning Report is taking more than 1 HourSummary: The problem is with the Print Min Max Planning report scheduled for one of the organizations is terminating due to time out error. This is happening since 18th …Shabbir M Tahasildar 71 views 13 comments 0 points Most recent by Shabbir M Tahasildar Inventory Management -
Can we bring Available to Transact (ATT) value from REST API to BIP report ?Summary: Can we bring Available to Transact (ATT) value from REST API to BIP report ? Content (please ensure you mask any confidential information): Hi, We have a requir…
-
Dear Team, Is there any subject area to create OTBI report for Inventory Aging?Summary: Dear Team, Is there any subject area to create OTBI report for Inventory Aging? Content (please ensure you mask any confidential information): Version (include …
-
ORA-01652: unable to extend temp segment by 128 in tablespace FUSION_TEMPSummary: we have one custom report keeps failing with error ORA-01652: unable to extend temp segment by 128 in tablespace FUSION_TEMP in saas application. could you plea…Veeragopathi 879 views 8 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
Can we customize the purchase order implemented notification reportSummary: We try to customize the Data Model trying to add the field ex-factory date into the Data Model. When we try to use the field ex-factory date in our rtf template…
-
Essential field extraction from fusion using API for po creation with ValidationSummary: We have a requirement to create POs in bulk, user only provide us fields such as Procurement BU,Requisitioning BU,Doument Style Name,Supplier Number Supplier Si…
-
Query to get Item Class Change HistoryHi, Recently, some items in OC PLM had their class names changed, and I need to write a query to retrieve both the old item class name and the new item class name. I att…Ramsha Zameer 54 views 4 comments 0 points Most recent by Shamsul_Wzd Reporting and Analytics for SCM -
REST API to get PO Details from Oracle FusionWe have a requirement to automatically close purchase orders and blanket purchase agreements using REST API and FBDI approach. Currently we are using Fusion tables to ge…
-
Is there a report that will help business with get list of PO number, and corresponding detailsSummary: Do we have any Oracle fusion report that will help business user to get list of PO number, and corresponding requisition number, requisition line number, requis…
-
What would be SQL query to get PO to Receipts with invoices detailsHi …!!! I'm trying to create a BIP report with the details of Purchase Order details and matched Receipts details including receipt amount with Invoice Details. I'm unab…
-
Export Approval DetailSummary: Hi We are currently setup po approval in setup and maintenance. We are not using BPM. But in another product segment, we use BPM, such as project budget approva…
-
How to get more details of this package PO_BIP_HELPER.get_requester_name?How to get more details of this package PO_BIP_HELPER.get_requester_name?
-
Need a SQL query to fetch Miscellaneous transactions in Oracle Fusion CloudSummary: Need a SQL query to fetch Miscellaneous transactions in Oracle Fusion Cloud. I'm building a report to capture the Account Alias Issue type of transactions. Cont… -
What is template name of email body and subject of awarded negotiation that send to supplier?Actually our client want to customized the email body and subject name for Negotiation Invitation and Negotiation Awarded email that send to Supllier. We are to able fin…Chandan Kr 1 view 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Once PO has been generated via Oracle ERP Cloud email is triggeredSummary: Once PO has been generated via Oracle ERP Cloud Email is triggering with attachment, there is no bursting in data model. Not sure how email is getting triggered…
-
Is There a Quicker Way to Retrieve Payables Close ReportsSummary: We have a large handful of closing reports for accounts payable that we run every financial month end, and it is causing a significant amount of time to go into…Nikki K 11 views 3 comments 0 points Most recent by Daniela Petria-Oracle Payables, Payments & Cash Management
-
Open-source fonts to replace licensed Monotype fonts in BIP and OTBI in 24AIn 24A, open-source fonts will replace the Monotype fonts currently available in Oracle Transactional Business Intelligence. You can use the open-source fonts available …Noelle Bartlam-Oracle 21 views 2 comments 1 point Most recent by ravikiran goda-Oracle Reporting and Analytics for SCM
-
Is there any seeded report available to list the supplier login history?Client would like to know the adoption rate of the supplier portal. Is there any seeded report that can extract the supplier login history for a specific period of time?
-
Bursting Query errors outSummary: Report generated output in XML, but the bursting query errors out Content (please ensure you mask any confidential information): Waiting Time: 0.5 seconds Data …SukumarKondaveti 74 views 7 comments 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for SCM
-
Error: SQL query time exceeds the limit(500 sec). Stopped processingSummary Error: SQL query time exceeds the limit(500 sec). Stopped processingContent Hi All, Error: SQL query time exceeds the limit(500 sec). Stopped processing. I am un…Devendra Thota-220620 2.3K views 8 comments 4 points Most recent by Shyam Patel Reporting and Analytics for SCM