BI Cloud Connector
Discussion List
-
Are Sourcing Rules (Table MSC_SR_ASSIGNMENTS) available in BICC?Summary: Which is the right PVO / Dataset to use for this in BICC Offering setup? Content (please ensure you mask any confidential information): We need to extract Sourc…Frank.Steinjan 10 views 0 comments 0 points Started by Frank.Steinjan Reporting and Analytics for SCM -
Is requisition approval history available in BICCSummary: We are looking for a data store that contains approval history for Purchase Requisitions. Is this available in BICC? Content (please ensure you mask any confide…
-
Can i get the Database lineage document for 23DSummary: Can i get the FSCM Database lineage document for 23D Content (please ensure you mask any confidential information): Version (include the version you are using, …SKanWes 13 views 1 comment 0 points Most recent by Gayatri Chappalli-Oracle Reporting and Analytics for SCM
-
Need PVO for description column corresponding to avespdescid ID column - EFFBPricing__AttributesSummary: Need PVO details for description column corresponding to avespdescid ID column Content (please ensure you mask any confidential information): Hi Team, We need t…Jahnavi-Oracle 23 views 0 comments 0 points Started by Jahnavi-Oracle Reporting and Analytics for SCM -
how to use BICC for extracting large data from cloudSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):user12941432 21 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for SCM
-
What BICCs are available for Supply Chain Planning? ie. Demand Management, Supply Planning and S&OP?Summary: What BICCs are available for Supply Chain Planning? ie. Demand Management, Supply Planning and Sales and Operations Planning? Content (required): What BICCs are…
-
What is the PVO for Item Descriptive FlexfieldsContent: Once DFFs for Items (EGP_SYSTEM_ITEMS_DFF) are "BI enabled" and deployed, what is the associated PVO that can be used in BICC to extract those Flexfield values …User_BEGVH 33 views 3 comments 0 points Most recent by Marc Vermeulen Reporting and Analytics for SCM
-
BICC PVO for Sales Order and CustomerWe need to extract the data for customers , items and sales orders using BICC. It extract should be used by DW. If you have done these kind of extract, Could you please …Oracletechnofunctional 62 views 1 comment 0 points Most recent by Gayatri Chappalli-Oracle Reporting and Analytics for SCM
-
BICC DFF extract sales order header and linesNeed to extract Sales order header and line data from tables DOO_HEADERS_ALL and DOO_Lines_ALL. I am able to get this using BICC extract into UCM server. But DFF columns…Alok K Gupta 62 views 6 comments 0 points Most recent by Alok K Gupta Reporting and Analytics for SCM
-
UCM vs Object Storage for BICCSummary: UCM vs Object Storage for BICC Content (required): What is the recommended approach? Our end goal is to load the extracts into a database. Version (include the …sanjam1130 242 views 1 comment 0 points Most recent by Amrita Gupta-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 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 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 21 views 0 comments 0 points Started by Jahnavi-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 274 views 6 comments 4 points Most recent by Arghyo Banerjee -Oracle 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 51 views 2 comments 4 points Most recent by Rohit Soni-259808 Reporting and Analytics for SCM
-
How to deactivate BI Report Jobs during/right after P2TSummary Is it possible to deactivate report jobs during a P2T, avoiding the reports to be sent automatically right after the P2T is completed?Content Hello, Our customer…Murielle Manambelona-Oracle 36 views 1 comment 0 points Most recent by Sahil Makhiza Reporting and Analytics for SCM
-
How to Print the attachment in PO ReportSummary We have a requirement to get the attachment from a PO should get displayed on the View PDF document. Kindly SuggestVersion 11.13.20.04.0Yogesh Kumar-234569 82 views 3 comments 0 points Most recent by Lucky Sharma Reporting and Analytics for SCM
-
BICC ExtractSummary How to Extract Sales Order DFF's using BICCContent How to Extract Sales Order DFF's using BICC Version 20Ckancharla panibhushanam 64 views 2 comments 0 points Most recent by kancharla panibhushanam Reporting and Analytics for SCM
-
Report for all items name + item code + barcode numberSummary Report for all items + item code + barcode numberContent Hello All, I need a report to display the Item Name + Item Code + Barcode Number. I have the below table…Yogesh Nemchand 84 views 1 comment 0 points Most recent by Yogesh Nemchand Reporting and Analytics for SCM
-
OTBI performance recommendations paper (2679006.1) is available on MOS PortalSummary OTBI performance recommendations V2 doc is intended for OTBI system integrators, BI report developers and admins. It covers advanced performance tuning technique…Pavel Buynitsky-Oracle 58 views 0 comments 3 points Started by Pavel Buynitsky-Oracle Reporting and Analytics for SCM
-
Maximum Number of Records for a BICC ExtractSummary Maximum Number of Records for a BICC ExtractContent We're looking at using BICC to extract cost and inventory data for reporting because of the volume of records…
-
Enabling the User to Edit Reports Created by other USerSummary Enabling the User to Edit Reports Created by other USerContent Hello , I need to enable a user to edit reports for SCM created by other user i created a Custom R…Ali Essam El-Bandrawy 36 views 2 comments 0 points Most recent by Ali Essam El-Bandrawy Reporting and Analytics for SCM -
Oracle Business Analytics Reporting OverviewSummary Watch this video to learn about using Oracle Business Analytics for Supply Chain Management.Content Link to the video: https://www.youtube.com/watch?v=DSRvYKS2wG…Pankaj Mongia-Oracle 435 views 1 comment 11 points Most recent by Mohammed Ali Manzur Arshi Reporting and Analytics for SCM -
Need a query to fetch all the report names and its locationSummary Need a query to fetch all the report names and its locationContent Hello All, We have a requirement like what are the reports are avilable in the system and what…Koteswararao Yenikepalli 52 views 1 comment 0 points Most recent by Siva Kumar-Oracle Reporting and Analytics for SCM -
SCM Item PVOsSummary SCM Item PVOs Definition or explanationContent Hi, I am using BICC to extract data from ERP Cloud for downstream integration with a client's data lake. We are in…Bradley Q-Oracle 91 views 2 comments 0 points Most recent by Senthilrajan V Reporting and Analytics for SCM