BI Publisher Reports
Discussion List
-
How to Retrieve Main Categories from Manage Catalog Category Hierarchy in Oracle FusionSummary: Hi Team, In Oracle Fusion, I need a table to retrieve the Main Category values configured under: Setup and Maintenance → Manage Catalog Category Hierarchy. Belo… -
PO PDF Custom Template not getting selectedSummary: Hello, we are having an issue where our Custom Template is not getting selected when creating PO's. It is pulling the seeded template and I cannot figure out ho…
-
How/where to track PO's Communicated via Email to supplier in outlook sent item?Summary: Hi All, We are using the Oracle Supplier Communication functionality to send Purchase Orders to suppliers via email. Is there a way to track whether a Purchase …
-
OTM/GTM - what is the size limitation for oracle BI Publisher rtf template?Summary: OTM/GTM - what is the size limitation for oracle BI Publisher rtf template? Content (please ensure you mask any confidential information): OTM/GTM Product is cu…Nilesh Kumar Mal-Oracle 5 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for SCM -
Knowledge Article: 20B Updates to Sourcing NotificationsSummary This article is about recent updates to Sourcing Notifications and how a Category Manager can configure external notifications sent to suppliers as per the busin… -
How to convert an existing OTBI report with prompts and filter conditions to BIP reportSummary: We have requirement to convert the OTBI report to BIP report. The OTBI reports has prompts and filter condition. How can we convert the same in BIP report witho…
-
How-to: Display Text Attachments in PO PDFContent Customers who attach many large text attachments to their purchase orders may find that the text attachment content does not appear in the purchase order PDF. To…
-
Attachments Missing in PO Document NotificationsSummary: After 24A upgrade, we are unable to see the attachments in the PO Notification emails and getting the below mentioned error message. " An error occurred while c…
-
The File Was Not Downloaded or Was Not Downloaded Correctly - PO PDFSummary: I recently updated my PO PDF report template and uploaded it. When I try to view that in View PDF in front-end, it throws the error "The File Was Not Downloaded…Vigneshvaran KJ 2.2K views 2 comments 0 points Most recent by Ashu_10 Reporting and Analytics for SCM
-
BI SQL query to get the Review Item supply and Demand in oracle fusionSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
How to list all changes made against a BPM rule in given time period?Summary: How to list all changes made against a BPM rule in given time period? we are referring to table POR_AMX_RULES but it doesn't have changes made against any condi…
-
Min-Max Report - On Order Quantity CalculationSummary: Min-Max Report - On Order Quantity Calculation Content (please ensure you mask any confidential information): We are having a descrepancy in the data were seein…
-
sql query for Response from Supplier Portal and Surrogate Response in oracle fusion Sourcing moduleHi Team, We need a table or SQL query to get the details for negotiation created Supplier Portal and Surrogate Response details in oracle fusion Sourcing module Thanks.
-
Custom BI Publisher ESS Job from Oracle Fusion ERP with Oracle EPM Data Integration (ARCS)We are integrating a custom BI Publisher ESS Job from Oracle Fusion ERP with Oracle EPM Data Integration (ARCS). The BI Publisher report has two parameters, both of type…Subramanian Karunamoorthi 19 views 0 comments 0 points Started by Subramanian Karunamoorthi Account Reconciliation -
SCM White Paper: View Accounts Payable Invoice from Receiving Receipt NotificationPurpose This document provides a step-by-step guide on how to configure the BI Publisher Report Confirm Receipt PO Notification Report to view the accounts payable invoi…
-
Oracle Fusion Procurement – Standard Reports/Dashboards for Goods Expense Receipt PerformanceSummary: I am trying to identify any standard Oracle Fusion reports or dashboards that can be used to analyze goods receipt performance, specifically: Outstanding receip…
-
Unbale to see Context DFF in OTBI Procurement -Purchasing real time Subject areaSummary: Hi All, We have created below context DFF at PO Line level But we are Unbale to see Context DFF in OTBI Procurement -Purchasing real time Subject area,adter dep…
-
Fusion Procurement – Source of Supplier Item / Supplier Part ID on PO Expense/Inventory LinesSummary: Hi I am trying to identify the underlying table and column for the Supplier Item displayed on a Purchase Order line in Oracle Fusion Procurement. In the PO UI, …
-
Balance Value for Balance Dimension visible in Fusion UI but not in OTBISummary: We are trying to lookup Payroll Balance Results based on a specific Dimension Name and Balance Name, and the output retrieved from OTBI is not matching to that …
-
Negotiation email invitation contains classic url after enabling Redwood for supplier portalSummary: We have enabled Redwood for Supplier Portal / Sourcing. When we publish a negotitation and we receive the email, if one selects the url in the email report….it …
-
Is there any table where PO Validation errors are stored?Content If Touchless buying is enabled and due to any validation error, auto submission of PO is failed. Is there any table which store data for such validation errors? -
Tables and Views for SCM - Supplier Site B2B Associated Collaboration DocumentsSummary: Waiting Oracle´s Respond Hi Oracle Team, We need to create a report that retrieves details from the Supplier Site B2B Message Definition. We were able to identi… -
Physical Inventory Adjustment ReportSummary: Physical Inventory Adjustment Report Content (please ensure you mask any confidential information): Is there any Seeded report to view the adjustment made durin…
-
Custom BIP Report Issue Resolved by Custom Report Template Name ChangeSummary: During UAT in , the customized **Purchase Document E-Mail Report** was not working correctly. (PO PDF notification Email's body did not come out) Resolution: Ou…Sakshi-Oracle 11 views 2 comments 0 points Most recent by Juan Sanson, Jr Reporting and Analytics for SCM
-
Issue When Exporting Purchase Order Report to CSV FormatSummary: We have a Purchase Order report. When the output format of the report is set to Data and we run the report, there are no issues with the output. However, when w…
-
How to customize Confirm Receipt PO Notification in redwoodSummary: I need to add one standard invoice field in this email notification. This email is in redwood template, I am trying to get sample xml from Data model, but data …
-
Bulk upload Stock On-Hand, Next Restock Date, PO & Back Order Quantity from Oracle Fusion InventoryWe have a requirement to develop an OIC Integration for Bulk and Delta upload / sync item Stock with Kafka for eCommerce platform (Hybris & Intershop). The requirement i…
-
Changes to PO not reflecting in PO PDF DocumentSummary: Hi, I have a PO that was approved. We then submitted a change order to change the deliver to location. This has also been approved. However the PO PDF document …