BI Publisher Reports
Discussion List
-
Why Standard fonts are not reflecting in the BI Reports?Summary: I have used "Times New Roman" font in my RTF Template, but it is not taking that font in BI output report instead of that some other font is present. This issue…Pravallika Mamidipaka 41 views 3 comments 0 points Most recent by Melissa Carrick - Oracle-Oracle Purchasing -
How to modify/change the email notification sent out to supplier for inviting an negotiation?Summary: Hi team, Is there any way to change the email notification (including subject, and content) sent out to the supplier for inviting a negotiation? Thank you in ad…
-
Deeplinks - How to use the return variable ?Summary: Deeplinks - How to use the return variable ? Content (required): Hello, I use this deeplink : ../fscmUI/faces/deeplink?objType=PURCHASE_ORDER_APUSER&objKey=poHe…
-
Update the code in Min Max Planning packageSummary: To update the code in the Min Max Planning package Content (required): Hello Gurus, In the Min Max ESS Planning ESS Job, it has an event trigger (before and aft…
-
How to add P Card field in PO PDF templateSummary: How to add P Card field in PO PDF template Content (required): How to add P Card field in PO PDF template Version (include the version you are using, if applica…
-
call and update subtemplateSummary: 1- i update on Award Approval Notification Report. 2- has template AwardApprovalNotificationBodyReport.rtf. 3- in this template i have multiple subtemplate like…
-
Need to relabel product for receiving import productsSummary: Sometimes when importing products they do not have the label information under our country's regulations, in this scenario, we need to relabel the product with … -
Need corresponding technical information on the R12 views MSC_ORDERS_V and MSC_EXCEPTION_DETAILS_VSummary: Looking for the replacement view or table information for the R12 supply chain planning views MSC_ORDERS_V and MSC_EXCEPTION_DETAILS_V. Content (required): Curr…Santhi 71 views 2 comments 0 points Most recent by Manojj Basetti-Oracle Reporting and Analytics for SCM
-
How to retrieve negotiation response pdf through BI Standard report in OIC?I understood that there is no data model for the Negotiation response PDF report, so customizing is not possible. from the link below PRC:PON: Need Sample XML for Negoti…
-
Query to get Error Message display on the report from Fulfillment Lines for Fulfillment ReportSummary: We have business requirement to get this Error Message into the existing fulfillment report (Order management can't schedule the item because supply isn't avail…kalyan gade 225 views 3 comments 0 points Most recent by Jagan Nori-Oracle Reporting and Analytics for SCM
-
Is there a table that holds - Reports usage metricsSummary: Is there a table that holds - Reports usage metrics Content (required): Is there a table that holds - Reports usage metrics, we want to understand which reports…Ramesh Devarakonda 31 views 4 comments 0 points Most recent by Ramesh Devarakonda Reporting and Analytics for SCM -
Why View PDF is showing all PO instead a single PO PDFSummary: Using Custom PO Template Content (required): When clicking 'View PDF' after searching for a PO#, instead of showing single PO output, it is downloading entire P…Mahmoud Elbestawy 51 views 6 comments 0 points Most recent by Michael Gibby - Huron Consulting Group Purchasing
-
How to view the PDF for previous versions of POs/AGTsSummary: How to view the PDF for previous versions of POs/AGTs Content (required): I create a PO/AGT initially and i can view PDF. Later when i create a change order and…
-
Reports to capture auto approved purchasing documentsSummary: We have the requirement to get the auto-approved purchasing documents using a custom report. Need assistance to get the right tables or query to get those PO, P… -
Need an SQL Query to find where (Approver) Negotiation Approval is Pending.Summary: Need an SQL Query to find where Negotiation Approval is Pending. For example, we have a negotiation that has 3 serial approvers. Approver 1 Approver 2 Approver … -
Is it possible to show the Cost center in PO PDF?Content (required): Client would like to see item, quantity per delivery location and cost centers reflected in PO-PDF, is it possible? If yes, how? If not, any work aro…
-
How to get negotiation response attachments and response pdf through API from Oracle fusion Saas?The requirement is that the on the basis of the DFF values entered by the user, the output should contain negotiation response attachments and response pdf for the parti…
-
User Defined Tables in SaaSSummary: Requirement for User-Defined Tables Content (required): A business requirement is to use a user-defined table in SaaS to be populated with data related to PR/PO…MohammedNasr 41 views 2 comments 0 points Most recent by Michael Gibby - Huron Consulting Group Purchasing
-
Need sql query to get invoice number in fulfillment line detailsSummary: Need query to get invoice number in Fulfillment lines. Screenshot attached. Content (required): As business request we have to add invoice number to order fulfi…kalyan gade 1.1K views 2 comments 0 points Most recent by kalyan gade Reporting and Analytics for SCM
-
Requisitioning BU have null value for header and header linesI made the following query to give me the open agreements and their lines, in the table, some lines had a Requisitioning BU value but the majority does not. In this quer…
-
Get requisitioning BU of item with sql querySummary: While selecting the contents of the po_lines_all table, I'm getting the requisitioning BU id, but I need to get the Requisitioning BU name or code, In which tab…Youssef_Antoury 1.1K views 1 comment 0 points Most recent by Michael Gibby - Huron Consulting Group Purchasing
-
How to change returned tag value on Negotiation PDF rtf using Publisher?Summary: I am trying to edit the value being returned from a tag on the seeded Supplier Negotiation PDF. I am using Oracle Analytics Publisher add-in in Word. Content (r…
-
History of Requisition/ Negotiation view or download of attachment?Summary: Is there a way to get a history of a Requisition or Negotiation of the users who viewed the transaction or who downloaded a attachment of the requisition or neg…
-
Query to get blanket purchase agreements and all their detailsSummary: I can't find a query to get the Blanket Purchase Agreements for oracle cloud fusion report. Content (required): I need to get the Blanket Purchase Agreements in…
-
Need Table or Subject area with "Assessable Value"Summary: We need to retrieve the information that is on column "Assessable Value" on the PO Lines. Content (required): Cannot find "Assessable Value" on any OTBI Subject…
-
convert date formatSummary: Need help with date formatting Content (required): substr(fleff.attribute_char5, 1, 10) to only display as MM-DD-YYYY Below is the query: SELECT substr(fleff.at…kalyan gade 111 views 2 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM
-
Are there downloadable dashboards for Supply Chain Management modules?Summary: I am looking for downloadable dashboards like the ones created by Caroline Gladwin (please refer to link: OTBI Sample Dashboards - 1. How to Install and Configu…
-
Remove Contract Terms in the Supplier Negotiation PDF ReportSummary: Remove the Contract Terms in the Supplier Negotiation PDF Report Is there a way to remove the Contract Terms template from the Supplier version of the Negotiati…