BI Cloud Connector
Discussion List
-
not able to locate any PVOs that expose the DFFs for Transfer Order Header and LineSummary: In the 25B release, I’m trying to create a BICC data extract job for Transfer Order Headers and Transfer Order Lines, including their Descriptive Flexfields (DF… -
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 19 views 2 comments 0 points Most recent by Todd Hensley Reporting and Analytics for SCM
-
Import Error BICC JobsSummary: Hello Team, we are getting an error when importing the BICC Jobs from UAT to PROD and it is erroring with attached error. Tried manual creation and it is workin…
-
PVO - BICC For Customer Address - Party, Account, SiteSummary: Hello, We are trying to find the PVO for Customer Address for Party, Account and Site in below and looks like one is not available. Can some one please confirm …
-
How to identify and track any changes made to few specific Item Standard/UDA attributes Only ?Summary Of the problem scenario: As part of a data outbound from oracle cloud to boundary systems, we have to send item info whenever there is some update made to any sp…Dileep_Parise 21 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-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 1.5K views 8 comments 4 points Most recent by Shyam Patel Reporting and Analytics for SCM
-
BICC Extracts: how can i find out what attributes are used for each of the fields in the data storesI am looking to find out what attributes are used for each of the fields extracted within our BICC Extract data. Our data reporting teams need to understand if a field i…Tracy Collins 1 view 0 comments 1 point Started by Tracy Collins Reporting & Analytics for Fusion Service
-
issue query filter BICCSummary: We're trying to filter specifc data from VO at BICC , but log returns query error at where clause. Content (please ensure you mask any confidential information)…Hbsampa 43 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for SCM
-
How to call pages from different moduleSummary: Hi All, I am working on a Idea to call pages from different modules. Here is how it should work Navigation>Order Management>Manage fulfilment lines. On this pag…Manohar Cheelangi Swamy 31 views 2 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for SCM
-
Extract DFF/EFF for Transfer Orders/Sales OrderSummary: Hi, We have a reqiurement to extract the DFF and EFF information for Transfer Orders and Sales order using BICC. We could able to find the below PVOs for extrac…Yash Jain 336 views 16 comments 0 points Most recent by Neha Aishwarya Reporting and Analytics for SCM
-
Which BICC lineage sheet has details for AccountContactResponsibility?Which BICC lineage sheet has details for below PVO- FscmTopModelAM.FinArCustomersPublicModelAM.AccountContactResponsibility
-
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 201 views 10 comments 0 points Most recent by Aniket Jadhav Reporting and Analytics for SCM
-
Date and Timestamp Datatypes from metadata for PVOSummary: We are retrieving the columns details such as datatype, precision and scale using the following endpoint(REST API metadata). However, some columns are labeled a…Alex25 1 view 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Need Unmasked Bank Account Number in Supplier PVO in BICCSummary: There are two columns in Bank Account tables, one for masked bank account number and another for unmasked bank account number. But in BICC, Supplier/Supplier Si…Sreeram Tadepalli 21 views 4 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
Is it possible to schedule a BICC job to run twice in a day? If yes, how can this be achieved?My goal is to schedule a BICC job to run twice in a day but turns out its not possible to have 2 active schedules for a job. Is this possible to achieve?Neha Aishwarya 31 views 4 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
Extract Transfer Order Line DFF using BICCHi, We have a reqiurement to extract the DFF information for Transfer Order lines using BICC. We could able to find the below PVO for extracting the transfer order line …Yash Jain 126 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
IssueSQL query to fetch rows from a BICC PVO created/updated after a certain dateWhat would be the syntax of an IssueSQL query to fetch data from a BICC PVO (eg. FscmTopModelAM.ScmExtractAM.CstBiccExtractAM.CstPeriodicAvgCostsExtractPVO) with where c…Neha Aishwarya 32 views 2 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM
-
Availability of sales order tax information (DOO_ORDER_TAX_DETAILS) in PVOs?For SCM analytics, I am looking for information on tax details at the sales order level (which table-wise seems to be in DOO_ORDER_TAX_DETAILS), for calculations pertain…
-
Need BICC PVO which lists Items details with Item ClassAre there any BICC PVOs that lists Item Class as part of Item details. We are able to get most of the Item data from "FscmTopModelAM.ScmExtractAM.EgpBiccExtractAM.ItemEx…Suman D 205 views 1 comment 0 points Most recent by Hari Kurra-Oracle Reporting and Analytics for SCM
-
BICloudConnectorJobDefinition Errors with ORA-01476: divisor is equal to zeroSummary: Experts, We are running "Prepare Supply Chain Planning Data for Export" to export data to BICC. However BICloudConnectorJobDefinition fails with this error Caus…Sudeep VS 11 views 1 comment 0 points Most recent by AkashV-Oracle Supply Chain Planning and Collaboration
-
PVOs with one to one relationships to base tablesSummary: Hi, We are building a Lakehouse on databricks using PVOs as source. Since PVOs are a combination of base tables together it is some time harder to get the data …Rajat N 21 views 1 comment 0 points Most recent by Deshin Pillay-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 2 comments 0 points Most recent by Jahnavi-Oracle Reporting and Analytics for SCM -
How to get FND_FLEX_VALUES and FND_FLEX_VALUES_VL via BICCSummary: FND_FLEX_VALUES and FND_FLEX_VALUES_VL not available in BICC Content (please ensure you mask any confidential information): Hello…we are in BICC version Oracle …Jay Chandran 157 views 6 comments 0 points Most recent by Sreeram Tadepalli 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 41 views 1 comment 0 points Most recent by Cornel Melinte-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 11 views 2 comments 0 points Most recent by KrishnaV 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
-
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 11 views 2 comments 0 points Most recent by Praveen Kumar Akkala-Oracle 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…Holly Wells 1 view 1 comment 0 points Most recent by Praveen Kumar Akkala-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…