BI Publisher Reports
Discussion List
-
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 234 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 541 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 232 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 11 views 3 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM -
CMR_PO_ACCRUAL_AMTS_RPT dependency issue while trying to customize Uninvoiced receipt accrual reportHi Experts, We need to add some invoice line level project based columns (project name, task name, project expenditure organization) in Uninvoiced receipt accruals repor…
-
Need to display header and footer for Contract Terms and Conditions in the PO PDF based on BUSummary: Need to display header and footer for Contract Terms and Conditions in the PO PDF based on Content (please ensure you mask any confidential information): Versio…
-
How to customize the BPA/CPA Notification Layout?Summary: We'd like to customize the BPA/CPA mail notification layout. We know purchasing document layout are mostly in the Catalog>Shared Folders>Procurement>Purchasing,…
-
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…
-
how to get quantity wise serial numbers in Delivery Note reportSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
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 … -
OTBIWe are working on OTBI in report and anlytics in Fusion, and in that there is a requirement to create below reports through OTBI analysis. PR cycle time Rate of emergenc…Priya Ranjan Jamuar 31 views 2 comments 0 points Most recent by Priya Ranjan Jamuar Reporting and Analytics for SCM
-
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…
-
PO Print: changing Contract Terms locationSummary: How to change Contract Terms location? Content (required): We are using a custom PO PDF and would like to change the Contract Terms location to be between a Cov…
-
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
-
PO PDF not displaying lines intermittentlySummary: PO PDF not displaying lines intermittently, it works 99.5% but stops displaying lines for the first go and is available when PO is re-queried. We have custom PO…
-
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 21 views 2 comments 0 points Most recent by KrishnaV Reporting and Analytics for SCM
-
Process Requisition tableSummary: what table stores all the values which we see in the process requisition page in Fusion? Content (please ensure you mask any confidential information): Version …
-
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…
-
Procurement DashboardSummary Out of Box Procurement Dashboard in Oracle Procurement CloudContent Hi Experts, I am looking for the Procurement Dashboard (out of the box (Update 20A)), have se…
-
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 62 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 21 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 2K views 1 comment 0 points Most recent by Satya Ganti-Oracle Reporting and Analytics for SCM
-
I want to pick Inspected by column on po receivingHello, I want to pick Inspected by column on po receiving as attached in screen short in inventory management oracle fusion Need to know the table which is storing this …
-
CREATE MISCELLANEOUS ISSUE AND RECEIPT BIP REPORTSummary: Hello experts, our client has a requirement to display Miscellaneous Issues through a BIP report, so we need the Oracle Fusion table names that store this infor…