BI Cloud Connector
Discussion List
-
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 59K views 143 comments 33 points Most recent by User_ST5IS Reporting and Analytics for ERP -
Getting 401 Unauthorized error code while calling an OIC integration from BIP reportSummary: I have created an app-driven integration that has - trigger REST connection with security policy: OAuth 2.0 - the REST trigger configures multiple resources - m…Nermin Khaled-Oracle 229 views 7 comments 0 points Most recent by Youssef_Antoury Reporting and Analytics for ERP -
Unable to find PVOs in BICCContent Hello, We need PVOs of following tables in BICC but we couldn't find these in Lineage Sheet. If anyone has any idea on how to get those or any workaround would r…Vinay Gharge 159 views 8 comments 2 points Most recent by User_0GZ7K Reporting and Analytics for ERP -
BICC PVOs with Offer DFFsSummary: We're looking to extract the Offer DFFs from HCM into Incorta, but are not able to find them within any of the PVOs. Has anyone successfully done this? If so, p…Maryellen_Gancena 2 views 0 comments 0 points Started by Maryellen_Gancena Reporting and Analytics for HCM
-
Connection Timeout (Error 404/504) when connecting BI Publisher to OIC File Server via Port 10134.Summary: Connection Timeout (Error 404/504) when connecting BI Publisher to OIC File Server via Port 10134. Content (please ensure you mask any confidential information)…Edward Villanueva 2 views 0 comments 0 points Started by Edward Villanueva Reporting and Analytics for ERP
-
BICC PVO HcmApprovalsTaskP1 Missing Pending Approval Tasks (Learning Requests / HCM Approvals)Hello Team, We have a query from Oracle to retrieve approval details for a Learning Request. We are working in OBICC (Oracle Business Intelligence Cloud Connector Consol…Andriampeno Odilon 10 views 0 comments 0 points Started by Andriampeno Odilon Reporting and Analytics for HCM -
What Caused the seeded Payroll Activity report to be updated on 11/27/2025?Summary: Want to understand why the seeded Payroll Activity Report has a Last Modified Date of 11/27/2025? and Owwner is System Account Content (please ensure you mask a…
-
BICC multiple file generation naming convention.We’ve observed that when multiple files are generated in BICC, they are currently being saved with identical names, without any versioning suffixes like _1, _2, etc. Thi…
-
Data replication from Oracle Fusion, OTM and WMS to external data warehouseWe have a requirement to replicate Oracle Fusion, OTM and WMS data (full load and incremental) to an external datawarehouse/ data lake at Microsoft Fabric on nightly bas…
-
FscmTopModelAM.FinVrmRRSharedPublicModelAM.PerfObligationLinDistsPVO- Duplicates for primary keyACTUAL BEHAVIOR Running BICC extract to extract information from PVO FscmTopModelAM.FinVrmRRSharedPublicModelAM.PerfObligationLinDistsPVO in BICC. PERFOBLIGATIONLINEDIST…Prabhjeet Kaur 51 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
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…
-
Which BICC PVO Stocked Purchase Order Receipts Information?Summary: Maybe someone knows or can give a hint where to find Stocked Purchase Order Receipts Information like Receipt Date in BICC extracts. So which PVO to use for thi…
-
Unable to deliver the file to SFTP serverHi Team, We have created SFTP server and while clicking on "Test Connection" the connection is showing as successful. But while we are scheduling the extract to the resp…
-
How can I join the hz_parties table to a project number or contract number table using sql.Hi everyone, I'm creating a work-in-progress report that tracks project costs and needs your help joining several Oracle tables efficiently. I'm working with: PJF_PROJEC…
-
BI Cloud Connector (BICC): ElementEntryPVO vs ElementEntrySummary: Both ElementEntryPVO and ElementEntry are sourced from the same view PAY_ELEMENT_ENTRIES_VL. However, when performing a full extract with the Effective Date Fil…Dennis Paredes 11 views 0 comments 0 points Started by Dennis Paredes Reporting and Analytics for ERP -
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…Or Shoham 11 views 3 comments 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Why certain BICC Public VOs do not support Incremental Load?Hello Team, We noticed that certain BICC Public View Objects do not support Incremental Load. Below are names of some of the VOs and screenshot showing 'Supports Increme…Alok5Kumar 12 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Oracle Fusion (HCM) Allow a Link to Microsoft Power BI to get dashboards?We are currently implementing Oracle Fusion HCM and the client has several dashboards already developed in Microsoft Power BI. These dashboards are published in Power BI…daniel.valdovinos 37 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
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…User_CK3H0 31 views 2 comments 0 points Most recent by Janakrm-Oracle Reporting and Analytics for SCM
-
How to connect Cloud Database to VS Code via Oracle Developer Tools for VS CodeSummary: We want to know if we can use Oracle Developer Tools for Visual Studio Code (SQL and PLSQL) extension to connect to Oracle HCM Cloud database. We are exploring …MaeHCM 74 views 2 comments 0 points Most recent by kollipara Bindu Bhargav Reporting and Analytics for HCM -
Extract all data from PAY_RUN_RESULT_VALUES and PAY_RUN_BALANCES tablesSummary: We have a requirement to extract all data from PAY_RUN_RESULT_VALUES and PAY_RUN_BALANCES tables since go live. We tried to build a BIP Report and running them …Phaneendra Vallapu 120 views 6 comments 0 points Most recent by RithwikSivanand111111 Reporting and Analytics for HCM
-
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…PrasadN 1 view 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
MSC_SYSTEM_ITEMS vs. EGP_SYSTEM_ITEMS_BI have a need to cross reference MSC_SYSTEM_ITEMS and EGP_SYSTEM_ITEMS_B to abstract away query complexity for certain users. This is a Data Warehousing scenario. How ca…Cameron Campbell 61 views 4 comments 0 points Most recent by Cameron Campbell Reporting and Analytics for SCM
-
In the BI Report Need to remove the schedule, jobs and jobs history from the setting option.In the BI Report Need to remove the schedule, jobs and jobs history from the setting option.
-
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 41 views 5 comments 0 points Most recent by Nishanth B Jain Reporting and Analytics for ERP -
How to identify Specific Column used Reports in BIPSummary: Hello Everyone, Is there any query we to fetch all BIP reports which are using specific column? Eg: Person_Number (Per_all_people_f) Can we pull all BIP Reports… -
Which BICC PVO should be used to extract Supplier/Vendor 'Name' to match to BICC Invoice Headers extContent Which BICC PVO should be used to extract Supplier/Vendor 'Name' to match to BICC Invoice Headers extract PVO? Version 21_BUser_2025-03-07-18-57-57-349 420 views 3 comments 1 point Most recent by Nathan CCC Reporting and Analytics for ERP
-
How to extract data from Flexfields in Fusion HCM via Data Stores in BICC?Summary How to extract data from Flexfields in Fusion HCM via Data Stores in BICC?Content Dear all, we extract data from Fusion HCM via Data Stores configured in BICC (B…User_2025-01-28-05-44-16-446 107 views 3 comments 0 points Most recent by M Nguyen Reporting and Analytics for HCM -
Is there anyway to extract Essbase cube data to connect with Powerbi beside smartview File?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
BICC - Get Full Extract on every scheduled runSummary: BICC - Get Full Extract on every scheduled run Content (required): We have a requirement where we need to schedule a PVO on a daily basis. And the output of the…