BI Publisher Reports
Discussion List
-
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.2K 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…
-
Inventory Onhand As of DateDo we have standard Report to check as of Balances lets say if customer wants to see onhand balances for 31-Jan-2022 on 11-Feb-2022 how to check through Standard Report
-
Manage Item Quantities - Page Composer - bindings.Segment1.attributeValue value not being passedSummary: Hi , I have a hyperlink added on 'Manage Item Quantities' screen in Inventory management. This hyperlink launches a BIP report which has Item number and organiz…Sravanthi Kollapudu-Oracle 32 views 2 comments 0 points Most recent by Sravanthi Kollapudu-Oracle Inventory Management
-
Different filename based on a parameter value of report using ESS jobHi All, How to achieve custom filename using report parameter value as part of filename Example: ABC_XYZ_Timestamp.xml or ABC_XYZ_Timestamp.csv ABC is part of the file, …Swapnil Kashid 1 view 1 comment 0 points Most recent by Swapnil Kashid Reporting and Analytics for SCM -
Bursting report in errorSummary: The log shows the following error: BIPJobExecutable Execution failed with Client received SOAP Fault from server : PublicReportService::generateReportDefinition…Giuseppe Galluzzo 320 views 12 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for SCM
-
Can I set the parameter to require in Print Movement Request Pick Slip Report ESS job?Same as question. I am going to set From Movement Request and To Movement Request these two parameters to require. Any idea? I can't edit the row :( -
Deep Links for PO and PR in BIP ReportSummary: Hi Team, We have created BIP report with deep links for PO and PR. I have created one custom role to for PO / PR View only access. The user can see PR in UI how…
-
OTBI Reports for BPA or CPA ?Summary: Role requiered to create either a BPA or CPA ? Content (required): Hello I would like to setup either a BPA or CPA , I think the process is 1.-Create a BPA or C…
-
Custom Hold resolution notificationSummary: How can I export the data model to upload it as a sample xml to modify rtf template? What parameters do I need to enter in BI to view a report? When I enter the…Alexandra Bykhan 91 views 8 comments 0 points Most recent by Neeraj Pandey-Oracle Payables, Payments & Cash Management -
Looking for Entity Relationship Diagrams (ERD) for Procurement modulesSummary: Looking for Entity Relationship Diagrams (ERD) for Procurement models Content (required): Hi, At times we need to use Database tables to find the information we…
-
Interconnect Oracle fusion and Azure databasesSummary: We seek information to interconnect Oracle Application Fusion and Microsoft Azure databases. We need step by step process to connect these databases. Content (r…Sravana Pydimarry 31 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for SCM
-
Report to show what has been changed on a Change Order and on a RevisionContent Hello, is there any way to get what has been changed on a Purchase Order when there is a Change Order or there is a Revision? Many thanks, Mario -
Items of Master Org assigned to all inventory OrgSummary: We have a business case and wanted some input if anyone has any idea if there is any better way to handle Total Items in Item Master 20K (approx) Toal org 100+ …
-
Make Requisition Number as a Hyperlink in PO approval notification?Summary: Make Requisition Number as a Hyperlink in PO approval notification? Our client requires to make the Requisition Number as a Hyperlink in the PO Approval Notific…
-
Need the concept/logic behind why Retroactive pricing is viable only with Non-Cumulative Price BreakSummary We have a request from our client to have Retroactive pricing under Cumulative Price break in Blanket Purchase Agreement.Content Hi all, Based on my research, Fo…Harshith Eshwar Shaila-145631 289 views 6 comments 0 points Most recent by Alexander Joseph Purchasing -
Automaticly attach 'To Supplier' attachments to RFQ invite emailSummary: Is there a way to automaticly add 'To Supplier' attachments to the RFQ invite email? Content (required): Currently, only the Supplier PDF is automaticly attache…
-
Does anyone have a report for the po-headers_draft_table that includes the process code status?Summary: Following error message when importing orders 'The Order Number must be unique for this sold-to legal entity, supplier and supplier site'. Content (required): W…