BI Publisher Reports
Discussion List
-
Need Link between Requisition Item Type and Requisition TablesSummary: Hi Everyone I have a requirement to get Item Type from Requisition Lines screen. I managed to find the Lookup Type where it stored LOOKUP TYPE: POR_NCR_REQUEST_… -
TIP: Configure Negotiation Invitation (BIP based) Email NotificationSummary Instructions on how to configure Negotiation Invitation (BIP based) Email NotificationContent Release 13 (Update 18A) allows you to opt into and enable Business … -
Seeded PO Print Template rtf – where does the HdrShiptoCustomerName value come from?Summary: The seeded PO Print Template contains a reference to ‘HdrShiptoCustomerName’, in the header Ship To region. Does anyone know where the ‘HdrShiptoCustomerName’ v…
-
Table name and column for Source AgreementSummary Table name and column for Source Agreement details of POContent what could be the Table name and column for Source Agreement details of PO(under procurment->mana…
-
Unable to find source Agreement table name in po tablesSummary Unable to find source Agreement table name in po tablesContent I have PO Report and need to bring Blanket purchase agreement column in Bi Publisher PO Report. I …
-
Fusion OTBI - Structure and Components Real TimeSummary Fusion OTBI - Structure and Components Real Time subject areaContent HI I am trying to do an OTBI Analysis with Structure and Components Real Time subject area t…Angel Espadafor 119 views 3 comments 3 points Most recent by tapan.nayyar Reporting and Analytics for SCM
-
How to Read File Contents of an Attachment on a Purchase Order using BIP report?Summary: We have created Attachments on a Purchase Order Header. Our Requirement is to read the file contents of the attachment using a BIP query. Is it possible to do t…
-
Is there any api available for fetch contract terms template data?Summary: Requirement to fetch contract terms template data from purchase agreement contract terms module. Content (required): We have a requirement to fetch the contract…Ancy Johnson 45 views 1 comment 0 points Most recent by Ed Gomez-Support-Oracle Enterprise Contracts -
PO and Organization table linkSummary: Hi I want to show PO number along with organization name. What is the table link Content (required): This required for BI report Version (include the version yo…
-
How to use distinct in the DFF value set querySummary: We have a requirement to add Line Manager DFF in the requisition line DFF for approval purpose. To get the unique values i am trying to use the Distinct functio… -
UCM access permission error while running Procurement BIP reportSummary: HI Team, We are running 1 PO report in which we have added a new data set in the data model that uses the Oracle Content Server data source (FA_UCM_PROVISIONED)…
-
Translation not working on Receipt Traveler Report when ran on receiving processSummary: Standard Receipt Traveler Report has translation to Canadian french on its template “Receipt Traveler Report”. Yet as per our tests, the translation is not work…
-
Does anyone have a sql to pull historic PO approvals/workflows?We have an audit request to provide the approval workflow for a change order last year. Since workflows are purged 30 days after completion, I cannot view this in ERP di… -
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 223 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 32 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…