BI Publisher Reports
Discussion List
-
Need a SQL query to get all the transactions involving a specific serial number in Oracle FusionI need a SQL query to trace all the transactions for a specific item serial number involved in Oracle Fusion.Krishan_Palihakkara 813 views 8 comments 0 points Most recent by Krishan_Palihakkara Reporting and Analytics for SCM -
How to fetch the below utility package source code from oracle fusion instance.Summary: We are working on the PO PDF report, to fetch requester phone number details. As per our analysis the requester phone number is begin fetched by utility package… -
Table for Pick Slip Header StatusSummary: We are looking for the table that contains the Pick Slip Header Pick Status Content (please ensure you mask any confidential information): We are looking for th…
-
PO PDF CustomizationSummary: We have a requirement to highlight all the changed fields on the PO PDF for Changed Orders. Please let us know if there is any audit or other tables from where …
-
How to update PO communication to the supplier so that the supplier item number is included.?Summary: I need to update our PO template to include the supplier part number. I can see the value is passed in the XML but it is not populated in the PO rtf. What field…
-
Change the watermark text on Incomplete PO printSummary: Is it possible to change the watermark text on Incomplet PO print? Content (required): Currently, the default watermark is 'DRAFT' on Incomplete PO. We want to …
-
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 58 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 78 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 1.2K 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 61 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…
-
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