BI Publisher Reports
Discussion List
-
need a query to fetch negotiation response details with price break informationSummary: Need a sql query to pull negotiation response details with price break information Content (please ensure you mask any confidential information): Version (inclu…SoumyaMukherjee03 303 views 1 comment 0 points Most recent by SoumyaMukherjee03 Reporting and Analytics for SCM -
Need help locating "Trading Partner ID" fieldSummary: Need help locating "Trading Partner ID" field, to include in either BIP or OTBI reports. Content (required): Need help locating "Trading Partner ID" field, to i…Andrew_Schmitz 222 views 6 comments 0 points Most recent by Andrew_Schmitz Reporting and Analytics for SCM -
Sales Order Report CustomizationContent Good People, Whats the best way to customize the Sales Order Report Data Model. One cant download or open the data model SalesOrderReportDM . Any one customized …Soumya Prakash Parhi 503 views 11 comments 1 point Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM -
Sales Order EFFs not showing up in OTBISummary Sales Order EFFs not showing up in OTBIContent Hi Experts, We have created few EFF in the Sales Order Header (with BI enabled), those EFF are not showing up in t…Sunil Dabekar 214 views 3 comments 0 points Most recent by Viswanath-Oracle Reporting and Analytics for SCM -
Unable to join Product management OTBI subject areasSummary: Hello Community, I have a requirement where I need to pull the Royalty data from the "Where Used" part of PIM. As part of that we are trying to join below subje…Sai Revanth 2 views 3 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
Can I create a dashboard using multiple Oracle BI Publisher reports ?Can I create a dashboard in Oracle BI Publisher that combines data and visualizations from multiple BI Publisher reports? Specifically, I'd like to include graphs and ba…
-
select statement to get projects intercompany transactionsSummary: requirement is that have to create report for projects intercompany receivables transactions Content (please ensure you mask any confidential information): Vers…
-
Unable to join the field Display Name in Requisition Preparer in Procurement-Requistions Real TimeSummary: Hi All, Requirement : To add the 'Entered By' field from the Manage Requisition Header UI to an existing OTBI report (Full PO Report - Purchasing) Subject Area … -
Display Item number with and without Part numbers and Manufacturer in Custom Onhand Inventory ReportSummary: The query below displays all inventory item numbers with part numbers and manufacturer information. However, the report does not show items without part numbers…
-
which oracle table contain po line item warning flagSummary: Hello, I am trying to build BI Publisher report for frozen POs. I need to pull PO lines that have invoices on hold. Currently we can see for such lines . yellow…Katharine McNamara 21 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
movement request auto approval table in oracle fusionSummary: movement request auto approval table in oracle fusion Content (please ensure you mask any confidential information): Version (include the version you are using,…KOTTHURI ASHOKBABU 17 views 2 comments 0 points Most recent by KrishnaV Reporting and Analytics for SCM
-
SQL query for Manage negotiation Template for Sourcing moduleSummary: Hi Team, We need a table where Manage negotiation Template information stores Content (please ensure you mask any confidential information): Version (include th…
-
display logo in excel format in Oracle Fusion BI reportI want to diplay the logo in Orcale Fusion RTF template in excel output When fetching output in pdf its showing the logo but not in excel fromat What is the sloution to …Abdur Rehman 41 views 4 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM -
Not able to view the BI publisher report under supply planning work areaSummary: We created BI report for Supply planning and loaded and created a new folder Supply Chain Planning under /Shared Folders/Custom/ and saved the report there. But…Adhavan 21 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
How to extract BOM explosion report for multiple items at one go?Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Madhupa 11 views 1 comment 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM -
How to filter out duplicate rows with same values in BI report.Summary: I need to create one BI report where I need columns like Item_Number, Item_Description, Prc_BU_Name, Order_Num (PO_num), PO_Quantity, Invoice_quantity, Invoice_…Rishabh702 15 views 2 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM
-
Query to extract Change order details of PO'sSummary: Need to extract all Change orders associated to a PO in Oracle Fusion Procurement Content (please ensure you mask any confidential information): Version (includ…KalyanC 1.4K views 1 comment 0 points Most recent by Satya Ganti-Oracle Reporting and Analytics for SCM
-
PROCUREMENT CONTRACT REPORT CREATIONSummary: Hi, We need to create a custom report in the Oracle procurement contract where can we fetch the front-end data - Monthly wise Please suggest the contract tables…Ranganathan Siva 1 view 1 comment 1 point Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
R13 Financials 24A OTBI subject areas to database lineage mapping Spread SheetSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…vnalluri 24 views 3 comments 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for SCM
-
What web service for BIPublisher to use to download output of scheduled report (ScheduleService)Summary: We use the SOAP web service interface "/xmlpserver/services/v2/ScheduleService". Using Operation "scheduleReport" it is possible to launch an execution of a BI …Renato Baietta 23 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for SCM
-
Fusion warehouse calendar querySummary: Need warehouse calendar query. I built a query that needs to have year, month, month start information using msc_calendar_months but msc_calendars table does no…kalyan gade 53 views 1 comment 0 points Most recent by Geno Hawkins- Support -Oracle Warehouse Management
-
Invoice ReportSummary: Is there any report which can drill down PO details (Department, cost Centre, receipt number and shipment number) which have been matched with invoice lines. Co…Najumah Bibi Abdool Rahman 3 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
SQL query for View Item Landed Cost pageHi Team, How does View Item Landed Cost Page work? We want to create a BI report for all GRNs and view item landed cost. We have written a custom logic but this query is…Hariom_Rathore 129 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Can attribute columns from WSH_NEW_DELIVERIES table be extracted using BICC?Can attribute columns from WSH_NEW_DELIVERIES table be extracted using BICC?Neha Aishwarya 11 views 5 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
How To restore Deleted Folder Under Shared Folders Within BI PublisherSummary: One of the users deleted a folder under Shared Folders→ Custom. Please let us know how can we retrieve the deleted folder Content (please ensure you mask any co…Susmitha Arepally-Oracle 198 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Not able to successfully send rest api post request to generate BI publisher report in Fusion CloudSummary: I'm trying to make a post-call to generate a BI publisher report. The fusion cloud rest api is returning RequestId -1 despite the request was fulfilled with 201…mayank_tripathi 11 views 2 comments 0 points Most recent by mayank_tripathi Reporting and Analytics for SCM
-
what are the extraction limits of the finder field in online reports?Summary: I need to know the character limit that can be sent to Bi Publisher Content (please ensure you mask any confidential information): I'm trying to extract the inf…Mari 32 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
BIP Excel output removing zeros from decimalSummary: BIP Excel output removing zeros from decimal Content (please ensure you mask any confidential information): I have a BIP Data Model and Report with Excel (.xls)…KDR 3 views 4 comments 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for SCM
-
Need Tables for Cost Transactions Depletion Layer DetailsSummary: I'm looking for tables for Cost Transactions Depletion Layer Details as in the screenshot below. Content (please ensure you mask any confidential information): …Kunal Verma 201 views 1 comment 0 points Most recent by SRGogula-Oracle Reporting and Analytics for SCM
-
Where can I find the list of all seeded reports (OTBI and BIP) provided by OracleSummary: Where can I find the list of all seeded reports (OTBI and BIP) provided by Oracle for Procurement and Contracts? Content (required): Where can I find the list o…Asutosh Mishra 3.3K views 5 comments 0 points Most recent by SharathBiz Reporting and Analytics for SCM