BI Cloud Connector
Discussion List
-
BICC: Extract is failing with Error while fetching rows from serverWhen we run the following PVO in full extract it's failing due to huge data as row counts are 208,699,447. FscmTopModelAM.FinExtractAM.XlaBiccExtractAM.SubledgerJournalD…V Bikki 5 views 1 comment 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting and Analytics for ERP
-
Is there a way to reset a PVO in a particular job from DB or any REST API or any other way in BICC ?We are looking to reset a PVO in a specific job by any other options like REST or other API or DB. We don't want to perform from the BICC page. If there are any inputs o…
-
BICC: Last Extract Date for PVOs aren't set if Extract Schedule is failedI've JOB which contains 57 PVOs... Noticed the following behaviour when one of the PVOs is failed. The Last Extract Date for PVOs aren't set. It's set only if the Extrac…
-
Duplicate lines in PVO FscmTopModelAM.FinExtractAM.GlBiccExtractAM.JournalLineExtractPVOIn the Oracle Business Intelligence Cloud Connector (BICC) Console, the Support Incremental option is enabled under Manage Job for FscmTopModelAM.FinExtractAM.GlBiccExtr…Jaydeep_Chaudhari_1802 28 views 4 comments 0 points Most recent by Hbsampa General Ledger & Intercompany
-
BICC PVO having attribute columns for PJC_EXP_ITEMS_ALLFrom the R113 PVO mapping document the BICC equivalent of PJC_EXP_ITEMS_ALL = FscmTopModelAM.PjcCapitalAM.ProjectAssetLineDetailPVO. Looking at the metadata and a sample…
-
How to get the gl account segment 'description' from BICC PVO extracts?Summary How do we get the gl account segment 'description' from BICC PVO extracts?Content How do we get the gl account segment 'description' from BICC PVO extracts? We a…User_2025-03-07-18-57-57-349 789 views 3 comments 2 points Most recent by KashifRaza Reporting and Analytics for ERP
-
Guidance on Business Intelligence Cloud Connector job orchestrationSummary: Guidance on Business Intelligence Cloud Connector job orchestration Content (please ensure you mask any confidential information): We need to execute JOURNAL_IN…
-
What are the standard Smart View reports available in Oracle ERP Cloud?Hi, What are the standard Smart View reports available in Oracle ERP Cloud? Such as for Cash Management we have the Cash Forecast and Cash Position Report which could be…Janitha Perera 21 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
SQL query or link between CE_CP_OPTIONS and CE_CP_OPTION_TIME_DIMSSummary: Hi TTeam, Could you please help us on this below SQL query or link between CE_CP_OPTIONS and CE_CP_OPTION_TIME_DIMS in Specify Cash Positioning and Forecasting …Opkey PA 11 views 1 comment 0 points Most recent by Stephen Westerfield-Oracle Reporting and Analytics for ERP
-
I'm new to BICC - any PVO advice?I hope this is the right community. I couldn't find one specific to BICC. My background is in integration platforms such as OIC and BizTalk, so working with the Fusion &…Todd Hensley 34 views 2 comments 0 points Most recent by Todd Hensley Reporting and Analytics for ERP
-
How to get PVO path for custom (Non-Seeded) object?Summary: Unable to find out the the non seeded path for the custom object PVO. Content (please ensure you mask any confidential information): We created a new custom obj…
-
PVO SubledgerJournalTransactionEntityExtractPVO and SubledgerApplicationExtractPVO generating blankSummary: PVO SubledgerJournalTransactionEntityExtractPVO and SubledgerApplicationExtractPVO generating blank files even after reseting to full extract Content (please en…
-
BIP SFTP Bursting vs BIP SOAP API calloutSummary: Advantages of BIP API download option (for data reports) Vs BIP report sent to SFTP channel Content (please ensure you mask any confidential information): We us…Abdullah Munaz 43 views 2 comments 0 points Most recent by Akash Katiyar-Oracle Reporting and Analytics for ERP
-
Can we data mask certain fields within BICCSummary: As Oracle provides BICC as a tool to extract data from Oracle Fusion Cloud through UCM for customers to further analyze or report this data. We have a legal req…
-
R13.x FSCM BI Cloud Adapter BI View Object to Database Lineage Mapping SpreadsheetSummary This posting includes R13 FSCM BI Cloud Adapter BI view object to database lineage mapping. Content This spreadsheet is published by Oracle BI Cloud Adapter Deve…Rashmi M-Oracle 50.6K views 133 comments 30 points Most recent by User_PNCTI Reporting and Analytics for ERP
-
Need BICC PVO to get per_location_details_f tables Additional attributesSummary: Need BICC PVO to get per_location_details_f tables Additional attributes Content (please ensure you mask any confidential information): Version (include the ver…Nishanth B Jain 20 views 2 comments 0 points Most recent by Nishanth B Jain Reporting and Analytics for ERP
-
how to extract data from a PVO using BICCCI need to extract data from FscmTopModelAM.FinGlJrnlEntriesAM.JournalHeaderExtractPVO to a file or at least to query this table. ( I need to do a count over a column to …
-
Tables of ESS/BIP jobs and their parameters in Oracle fusionSummary Please share the tables in which the parameters of the ESS and BIP Jobs submitted are saved.Content Please share the tables in which the ESS and BIP Jobs, and th…
-
How to disable logon using username and password in Oracle ERP, EPM and OCICan someone please provide the insights on the below query We need help to understand options around security, namely:- Can we disable the ability to log on using a user…Sheshan Ukkalkar 15 views 2 comments 0 points Most recent by Sheshan Ukkalkar Reporting and Analytics for ERP
-
PO Change Order Amount Changed column detailsSummary PO Change Order Amount Changed column detailsContent Hi Friends, Can you please help me to get Amount Changed column details when PO Change Order action performe…
-
How to upload sftp private key in oracle b2b console, what we need give in the private key fieldSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…sindarapu 13 views 1 comment 0 points Most recent by Bogdan Nita-Oracle Payables, Payments & Cash Management
-
How to Format a Date Column to include Time Stamp in BICC Extract OutputSummary: Hi, I am trying to extract fusion table data using BICC, and I am seeing when the data is exported the date fields doesn't have the time values in it even thoug…Ragul Halan 17 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Request for Information on Managing Budget Versions Approver details in fusion TablesSummary: I am currently working on a requirement to display the approver's name and the submitted person’s name for budget versions in our Grant Management system. Howev…Chetan Yeola 6 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Use the ESS web service to schedule a job for running the BI cloud extractsSummary: We have been attempting to run a BICC based job from a SOAP\API call using something similar to the ErpIntegrationService submitESSJobRequest SOAP function but …AaronBaltimore 93 views 5 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
General Guidance on BICC/BIP for PVO JoinsSummary: General guidance on Fusion BICC/BIP for PVO joins & if Fusion supports AI/ML analytics? Content (please ensure you mask any confidential information): My unders…
-
Is it possible to BICC Export a file to FTPSThe client need a way to download/export the BICC file from UCM to client File Transfer Protocol Server. Is there any way to do this?Pedro Bacic 25 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
Guidance for selecting PVOs for BICC extractSummary: We are using Oracle Business Intelligence Cloud Connector (BICC) to extract transactional data & load it into external tables using Informatica Cloud Services. …
-
Is there a PVO (or combination of PVOs) that returns the accounting status of a Payables invoice?I need to return the accounting status (Accounted, Partially Accounted, Selected, Unaccounted) for a specific AP invoice but using PVOs. The column "ApInvoicesPostingSta…MarkGauthier 12 views 2 comments 0 points Most recent by MarkGauthier Reporting and Analytics for ERP
-
BICC PVO missing information in FscmTopModelAM.PrcExtractAM.PozBiccExtractAM.SupplierExtractPVOSummary: BICC PVO FscmTopModelAM.PrcExtractAM.PozBiccExtractAM.SupplierExtractPVO doesn't have information related to IncomeTaxId even if in source table POZ_SUPPLIERS_P…
-
BICC 24 Version BICC Mapping DocumentSummary: Please share the Rel13_24.x_BICC_FSCM_Database_Mapping_with_ViewObjects.xlsx.zip Mapping Document Content (please ensure you mask any confidential information):…SYARABOLU 246 views 5 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP