BI Publisher Reports
Discussion List
-
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.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 31 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 343 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 33 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…