Business Intelligence
Discussion List
-
Product Development Change Order Audit history reportSummary: Need sql or database tables to generate Change Order Audit history report Content (required): As of today, there is no decent Audit history report of change ord… -
Filter Planned Completion Date Based on Current DateSummary: Content (required): Hi, We have created an OTBI report with the column "Planned Completion Date" using Maintenance Management - Work Order Performance Real Time…Sheneli Fernando 11 views 1 comment 0 points Most recent by Bharath Raghupathi-Oracle 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 44 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for SCM -
Is there any possibility to update the Sales Order Report Data Model - SalesOrderReportDMSummary: Is there any possibility to update the Sales Order Report Data Model - SalesOrderReportDM Content (required): Is there any possibility to update the Sales Order…Pandiyan 19 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for SCM
-
How to Send Multiple files in one mail using Bursting(BI Report-EText template).Summary: Trying to Send Multiple files in one mail using Bursting(BI Report-EText template). How can we achieve this? Version (include the version you are using, if appl…Suman123 6 views 1 comment 0 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for SCM
-
Need to get a report for PO's where we can filter by BU'sSummary Need to get a report for PO's where we can filter by BU'sContent Hello, Grateful if you can help on how to get a list of all GRN's for Received Shipments for a S…Yogesh Nemchand 27 views 5 comments 2 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for SCM
-
OrderChargeComponentExtractPVO extract contains duplicates for primary key while extraction.Summary: OrderChargeComponentExtractPVO extract(via DataSync) contains duplicates for primary key. Content (required): We are extracting data using the OOTB PVO 'FscmTop…Jahnavi-Oracle 2 views 0 comments 0 points Started by Jahnavi-Oracle Reporting and Analytics for SCM -
LAST_UPDATE_DATE incorrect for PO_DISTRIBUTIONS_ALL - Creates issue for BICCC incremental loadsSummary: Has anyone faced th issue where the LAST_UPDATE_DATE is not being updated for PO_DISTRIBUTIONS_ALL/PurchasingDocumentDistributionExtractPVO even when the data i…Jahnavi-Oracle 6 views 0 comments 0 points Started by Jahnavi-Oracle Reporting and Analytics for SCM
-
Do analyses run with Agents log to "OTBI Usage Real Time" subject area?Summary: Do analyses run with Agents log to "OTBI Usage Real Time" subject area? Content (required): Version (include the version you are using, if applicable): Code Sni…Andrew_Schmitz 3 views 0 comments 0 points Started by Andrew_Schmitz Reporting and Analytics for SCM
-
BIP performance recommendations guide v1.0 for FA SaaS (2800118.1) is available on MOS PortalSummary BIP Performance Recommendations Guide is intended for FA SaaS BI system integrators, BI report developers and admins. It covers advanced performance tuning techn…Pavel Buynitsky-Oracle 4 views 1 comment 0 points Most recent by Kelly Cooper-Oracle Reporting and Analytics for SCM
-
What is a "Perfect Invoice" in Oracle terms?Summary: In the subject area "Procurement - Spend Real Time" there is a measure called "“# of Perfect Invoices". Content (required): In the subject area "Procurement - S…Anders W. Langholm 5 views 1 comment 0 points Most recent by Anders W. Langholm Reporting and Analytics for SCM -
Our customer wants an OTBI Inventory report that shows the Supplier, Purchase Order, and LotSummary: Need inventory report: Supplier, Purchase Order, Qty on Hand, Lot Number, Expiration date Content (required I was able to use Inventory Transactions Real time t…Wayne Aus-Oracle 3 views 0 comments 0 points Started by Wayne Aus-Oracle Reporting and Analytics for SCM
-
BI Publisher Report Parameters Performance IssuesContent Hi, We have created a report with 15 LOV parameters such as Business Unit, Supplier, Location based parameters, GL Tree based parameters, Buyer, Currency and GL …user10645928 6 views 1 comment 0 points Most recent by Arghyo Banerjee -Oracle Reporting and Analytics for SCM -
Need a query to get details from Review Cost Accounting Distributions UIContent Hello all, I need to get the highlighted fields as per the screenshot I have attached for the Account Alias Issue transaction. In the UI,78001 Account Alias Issu…Sushan Peiris 53 views 8 comments 4 points Most recent by Sushan Peiris Reporting and Analytics for SCM -
Logged in UsersSummary List of Users logged into the ApplicationContent Team, Trying to find a way to pull a list of current users that are logged into the system. Any thoughts? Thanks…Ir-Oracle 16 views 2 comments 0 points Most recent by Arghyo Banerjee -Oracle Reporting and Analytics for SCM
-
Error: SQL query time exceeds the limit(500 sec). Stopped processingSummary Error: SQL query time exceeds the limit(500 sec). Stopped processingContent Hi All, Error: SQL query time exceeds the limit(500 sec). Stopped processing. I am un…Devendra Thota-220620 48 views 6 comments 4 points Most recent by Arghyo Banerjee -Oracle Reporting and Analytics for SCM
-
Tables regarded to Manage Item Quantities page on Oracle Inventory ModuleContent Hello all, I need to know the tables which contain the data related to the Manage Item Quantities page on Oracle ERP. I need to capture some fields from the page…Sushan Peiris 19 views 5 comments 4 points Most recent by Sushan Peiris Reporting and Analytics for SCM
-
Query to get payment method field in Order Management in Oracle FusionContent Hi all, Can someone tell me from where I could pick the payment method field mentioned at the front end of the Order management page? I have checked for the tabl…Sushan Peiris 179 views 1 comment 3 points Most recent by Sushan Peiris Reporting and Analytics for SCM
-
Need a table name for the schedule process ess job namesSummary Need a table name for the schedule process ess job namesContent We are not able to get the exact name from the ess job name we are able to get the alternative na…Koteswararao Yenikepalli 54 views 8 comments 0 points Most recent by Sudha KOVURU Reporting and Analytics for SCM -
Does anyone who a query to fetch the PO number created relevant to a Transfer Order Inter organizatiContent Hello all, I need a query that picks the PO number generated for the transaction type Transfer Order Inter organization Receipt in review completed transactions.…Sushan Peiris 26 views 6 comments 1 point Most recent by Sushan Peiris Reporting and Analytics for SCM
-
Need a query for a date parameter dependent to another date parameter.Content Hello all, There's a query I need to get the month names separately with one parameter and another parameter to select a date range. The month name parameter sho…Sushan Peiris 61 views 1 comment 3 points Most recent by Sushan Peiris Reporting and Analytics for SCM
-
How to create a label called "ALL" when selecting all from a parameter in BI reports.Content Hello all, I want to know if there is any way that I could display a word called "ALL" when I select all from a LOV of a parameter in the BI report in ORACLE FUS…Sushan Peiris 22 views 4 comments 3 points Most recent by Sushan Peiris Reporting and Analytics for SCM
-
Query to get Change Orders details like changed/updated data like PO amount, Invoice Number and InvContent Hello all, Can someone tell from where I could pick the details for Change Orders details for a Purchase Order which is in "Open" status and if changes are made …Sushan Peiris 358 views 1 comment 2 points Most recent by Sushan Peiris Reporting and Analytics for SCM
-
Is it possible to send two attachments in single bursting?Summary Is it possible to send two attachments in single bursting?Content We had a requirement to send same output with two different formats (Ex: Excel and PDF). we nee…Koteswararao Yenikepalli 29 views 4 comments 0 points Most recent by User_KM4LK Reporting and Analytics for SCM
-
Need a query to get Remit to supplier name for a given supplier.Content Hello all, I want to know where I could get the Remit-to-supplier name mentioned in the supplier management page in Oracle Fusion. I have got to tables joined, p…Sushan Peiris 32 views 1 comment 3 points Most recent by Sushan Peiris Reporting and Analytics for SCM
-
Need a query to fetch the status of Manage Negotiations pageContent Hello, Can someone please tell me a table to fetch the status of the negotiation on the Manage Negotiations page. Please find the attached image with the require…Sushan Peiris 48 views 3 comments 4 points Most recent by Sushan Peiris Reporting and Analytics for SCM
-
Not able to find Source Locator- Inventory Transaction Real Time Subject AreaContent Hi Team, I am new to Analytics reporting & need help to create a report with Below Scenario: 1) We need a report where Transaction Type = 'Subinventory Transfer'…Mayank Pande 14 views 2 comments 2 points Most recent by Sahil Makhiza Reporting and Analytics for SCM -
How to capture existing Report name and Data model details in BIP ReportSummary How to capture existing Report name and Data model details in BIP ReportContent Hi All, We are having a requirement to develop the BIP publisher report which wil…Rohit Soni-259808 21 views 2 comments 4 points Most recent by Rohit Soni-259808 Reporting and Analytics for SCM
-
How to get full access (create data model and report) only on My Folders in PRODSummary How to get full access (create data model and report) only on My Folders in PRODContent Friends, We have a requirement to allow IT support people to create data …Umamaheswara Reddy Karri 28 views 3 comments 2 points Most recent by Sahil Makhiza Reporting and Analytics for SCM -
Fetch only new or updated data from Last runContent Hi All, I am very new to Reporting hence need help to devlop report to fetch only incremental data. Report Logic: 1) Report will be called by Webservice by passi…Mayank Pande 25 views 1 comment 2 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for SCM