Business Intelligence
Discussion List
-
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 21 views 2 comments 0 points Most recent by Jahnavi-Oracle Reporting and Analytics for SCM -
How to pass parameter value from one job to another in ESS job setHi All, We have a ESS job set, input for the second ESS job would be the one of the parameter from the first ESS job. Can you please let us know how we can achieve this …Arunkumar Ponnusamy 107 views 2 comments 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for SCM -
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 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 -
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…
-
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 42 views 3 comments 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Sales
-
how to add dff to subject areaSummary: We are using some DFF's in Transaction History under Inventory and DFF and enable the same for reporting. There is no DFF's are available under this subject are… -
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 -
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
-
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
-
Unable to find database tables for Manage Terms and Conditions SetupHi Team We have the requirement to use the terms and conditions created under manage terms and conditions setup but not able to find out the related table or lookup. ple…PradeepkumarsharmaGX 11 views 2 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for SCM
-
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…Ankit.Mahajan 23 views 1 comment 0 points Most recent by Carlos Benassi 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 498 views 7 comments 1 point Most recent by Vrinda Mittal Reporting and Analytics for SCM
-
planned service provider in transportation intelligenceHello can you please advise if there is a Planned Carrier (Planned Servprov) column in Transportation Intelligence or I am overlooking it? we are calculating a PTA % but…TatianaS 2 views 1 comment 0 points Most recent by Islam Bahgat-Oracle Reporting and Analytics for SCM
-
OTBI Procurement - Requisitions Real Time Subject areaSummary: Procurement - Requisitions Real Time Subject area doesn't show Requisition with Source Inventory, Only showing Data for Supplier Source so which Subject area ca…
-
OTBI analysis using costing - receipt accounting real time concatenated segments not showing dataOTBI analysis using "costing - receipt accounting real time" concatenated segments not showing data when any other fields is added to the report.Assem Khaled 1 view 1 comment 0 points Most recent by Gayatri Chappalli-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…
-
Subject area which can be used to display the approval chain of RequisitionsSummary Subject area which can be used to display the approval chain of RequisitionsContent Hi, We have a requirement where we need to display the requisitions which are…Kalyan Reddy 45 views 3 comments 0 points Most recent by Fabiana De Arruda Reporting and Analytics for SCM
-
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…Sheneli98 41 views 1 comment 0 points Most recent by Bharath Raghupathi-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 21 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…User_2025-02-05-12-20-44-163 36 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 11 views 0 comments 0 points Started by Jahnavi-Oracle Reporting and Analytics for ERP
-
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 21 views 1 comment 0 points Most recent by Kelly Cooper-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 8 views 1 comment 0 points Most recent by Arghyo Banerjee -Oracle 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…Inder-Oracle 36 views 2 comments 0 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 304 views 5 comments 5 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 166 views 8 comments 0 points Most recent by Sudha KOVURU Reporting and Analytics for SCM