BI Publisher Reports
Discussion List
-
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 827 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 51 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 22 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 73 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
-
Transitioning Oracle BIP Reports from Packages to Standard TablesSummary: Can we convert Oracle BIP reports to use only Oracle standard tables instead of Oracle standard packages? We should not call standard packages in the report. We…
-
Custom Delivery Note Reports to be printed automaticallyWe have developed a customer delivery note report. we want that to be printed to the specific users printer as soon as the shipment is confirmed in oracle fusion. The pr…
-
sql query to show approval and reject history for purchase requisitionsSummary: I'm looking for sample sql queries to display history of PR approval, reject and the next persons who need to approve, just like View Document History. Content …
-
how is INV_CONS_ADVICE_REVISIONS table populated?Hi Team, For a consumption advice, I am seeing 2 revisions- 1 & 2 present in front-end while database table INV_CONS_ADVICE_REVISIONS is just fetching revision 1. Would …
-
Copy of 'Print Movement Request Pick Slip Report' does not show parameters screenSummary: I have created a copy of 'Print Movement Request Pick Slip Report' process in order to make required the parameters 'From Movement Request' and 'To Movement Req… -
Key colimn for joining INV_RESERVATIONS and DOO_HEADERS_ALLI would like to get data of Manage Reservations and Picks. More specifically, I need order number, quantity, customer, and shipping status from demand tab. According to …
-
Edit Purchase order page to implement one custom PO template on "VIEW PDF" buttonSummary: When user opens the Purchase order page , after clicking on "View PDF" , custom report should be called and report should be generated for corresponding PO .We …
-
How to fetch Ship-From Site in receiving Transaction UI pageSummary: In receiving UI pages of Fusion Procurement Cloud, we have observed some Ship-from Site in Transactions uses the Vendor_site_code in the UI pages, while others …
-
Table for Source Reference field on Completed Transaction page - SCM CloudSummary: Hello, We are building a custom BI report on review completed transaction page and looking for a table and column name for SOURCE REFERENCE field. Content (plea…