BI Publisher Reports
Discussion List
-
Assistance Required for Converting OTBI Query to Oracle Standard TablesSummary: I am reaching out to seek your expertise regarding the conversion of an OTBI query subject area into Oracle standard tables. Specifically, I am looking to under…Guthi Mallikarjun 21 views 8 comments 0 points Most recent by Guthi Mallikarjun Inventory Management -
Replicating Oracle Function FND_CURRENCY.GET_FORMAT_MASK() using oracle standard tablesSummary: Need to replicate the functionality of the Oracle standard function FND_CURRENCY.GET_FORMAT_MASK()using oracle standard tables Requirements: Explain what FND_CU…
-
Explain the Hyperlink Behavior in Transfer Order ReportWe have developed a report named Transfer Order Report, which includes a hyperlink for the Transfer Order Number. We’ve observed the following behavior: If a Transfer Or…
-
PO PDF cannot be viewed online and attached from Email for requesterHi Everyone, We have created custom data model for PO PDF. We checked that the error caused for the PO PDF cannot sent to our requester after PO created. Is there any ad…
-
Can we replace PO PDF document with Other PDF DocumentsWe have a requirement to replace PO PDF document with other PDF Documents once POs are created. Is there any way we can replace PO PDF document. I know we can customize …
-
Unable to find PartySiteID received in EDI850 payload in backend CML Log tables for CMK Errors.We have a requirement to display the 'PartySiteId' and 'AccountSiteUseId' fields—present in the Purchase Order Inbound EDI payload—in the Custom EDI850 Error Report when…Manish Maheshwari 21 views 2 comments 0 points Most recent by Manish Maheshwari Reporting and Analytics for SCM
-
Budget Carryforward and Budget Transfer Movement DetailsDear Oracle Cloud Community, We are currently working on a requirement to fetch Budget Carryforward and Budget Transfer Movement details after executing the PO Carry For…
-
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 651 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 53 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 72 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…