BI Publisher Reports
Discussion List
-
How to identify the Fusion Cloud user, how he/she has login through (REST API/OIC/URL)Summary: We used FND_Session table to identify the user, who has been logged in to cloud. but this does not tell about, how the user has been logged in. Manually( URL lo…Kalpa 211 views 2 comments 4 points Most recent by Marcos Allonso-53979 Reporting and Analytics for SCM -
Pick Slip Report ESS Job not sending Attachment for adhoc email address with Bursting enabledSummary: We have enabled bursting for Pick Slip Report ESS job but when trying to pass adhoc email address while submitting the ESS job, only Bursting proces is working … -
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… -
what is the PVO name for EGO_ITEM_EFF_B table to extract via BICCSummary: We need to extract EGO_ITEM_EFF_B table from oracle fusion application. we are using BICC connector to extract all these tables but we are unable to find PVO fo… -
Which table stores the name of the upcoming approver?Summary: Content (please ensure you mask any confidential information): Hi, we have requirement to show the next approver's name of these below transaction types: AP Inv… -
Printing the XML for Purchase Agreement Report PdfSummary: I need to print the XML for the Purchase Agreement Report PDF. I have created a custom folder, ensures that this report is in the correct directory, changed the… -
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.4K views 3 comments 1 point Most recent by Gayatri Chappalli-Oracle Reporting and Analytics for SCM -
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 …Chandu Mounika 42 views 8 comments 0 points Most recent by Michael Gibby - Huron Consulting Group Purchasing -
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… -
Which Table is having Purchase order ordered, total tax and line amountSummary: Which Table is having Purchase order ordered amount, total tax and line amount Content (please ensure you mask any confidential information): Which Table is hav… -
Which table having PO's Ordered, Total Tax, Total detailsSummary: Which table having PO's Ordered, Total Tax, Total details Content (please ensure you mask any confidential information): Hi Experts, Would like to seek for your… -
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… -
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 59 views 1 comment 1 point 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… -
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… -
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. -
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 26 views 2 comments 1 point 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… -
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…