BI Publisher Reports
Discussion List
-
Print Commercial Invoice is ending up with retrying status.Hi All, We have a custom role and with privilege assigned print shipping reports. When i'm trying to run the Print commercial invoice, it is ending up retrying status. I…KSowmya 41 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
Help Needed: Average Costing Logic – How to Carry Forward Updated Unit CostHi, I have a requirement to calculate the updated unit cost using the following formula and use the resulting value as the current unit cost for the next transaction row…RiyaKaushal123 11 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
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 677 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… -
Error downloading negotiation pdfWe have had the same custom layout for the negotiation pdf for years and suddenly we are unable to download a pdf. When trying to download the Buyer or Supplier pdf, we … -
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 52 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 929 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 56 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…