BI Cloud Connector
Discussion List
-
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 127 views 6 comments 0 points Most recent by Hemanth Kumar Muthyala 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 63 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 423 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 109 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…
-
SUM in Table ValuesetTeam, We need to use SUM in table valuset. If you have any idea then, please share. It would be helpful. SELECT SUM(peevf.screen_entry_value) FROM pay_element_entries_f …
-
PVO BankAccountExtractPVO returns bank account data in OTBI - Issue SQL but no data via BICCNeed to identify missing privilege or profile. PVO FscmTopModelAM.FinExtractAM.CeBiccExtractAM.BankAccountExtractPVO not returning data via BICC. In Fusion > Tools > Rep…Stéphane Lamy-Bouchard 41 views 2 comments 0 points Most recent by fusionenthu Reporting and Analytics for ERP
-
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…
-
BICC mapping documentation for a specific PVO missingSummary: Hi, we are doing BICC extracts on every day basis. One of the PVOs we are extracting and which is working fine is: FscmTopModelAM.PrcPoPublicViewAM.GlobalPurcha…Frank.Steinjan 78 views 2 comments 0 points Most recent by Frank.Steinjan 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 …
-
Is there any row level security delivered with BICC?Hello, We need to extract data for our local BI. We are on a Single International Instance, and we want to extract only our data. Is there a way (through security, or pe…
-
Send reminders to the employee based bip report burstingSummary: Send reminders to the employee based bip report bursting Content (please ensure you mask any confidential information): Hi Team, I have a requirement. I need to…
-
BIP attachment Query not accepting the parameterSummary: Hi, When I try to use attachment query with dynamic parameter(:P_DID) , i am not getting the UCM outputs. If I hardcode any UCM(DID) from revisions table then I…
-
Schedule a BI report with incremental dataSummary: Schedule a BI report with incremental data Content (please ensure you mask any confidential information): Hi Experts, I have a requirment, I need to scheduled a…Malak 21 views 4 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
What is the recommended tool to feed Data Warehouse from HCM CloudSummary: I would like to understand what the recommended tool is to feed Data warehouse from HCM Cloud. The BI Cloud Connector seems to me the best tool for this purpose…Jeroen.Broecheler 12 views 2 comments 0 points Most recent by Jeroen.Broecheler Reporting and Analytics for HCM -
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 918 views 4 comments 2 points Most recent by Robert A Reporting and Analytics for ERP
-
Can we have a multiple bursting in one reportSummary Can we have a multiple bursting in one reportContent Hello, Can we have multiple bursting in one report, I can create multiple burstings within the data model an…Koteswararao Yenikepalli 710 views 3 comments 2 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP -
BI Cloud Connector (BICC) New featuresHi Does anyone know of any changes coming to BI Cloud connector with Fusion Application 22A upgrade. And can anyone help provide the link to the the New Features documen… -
BICC - Oracle AR Invoice Line extended amountSummary: Hi, We are extracting data from oracle fusion ERP using BICC. When extracting Receivables(AR) invoice lines, there is no column like 'extended_amount', basicall…
-
Bi Cloud Extract is returning different amount of lines with same parametersSummary: BICC Extract Difference in amount of lines using same parameters Content (please ensure you mask any confidential information): I'm using BI Cloud Connector, da…Andres Celis-Oracle 11 views 0 comments 0 points Started by Andres Celis-Oracle 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…Elisa Rossi 2 views 1 comment 0 points Most recent by Antima Rai-Oracle General Ledger & Intercompany
-
HcmTopModelAnalyticsGlobalAM.PersonAM.PersonDetailsPVO missing dataSummary: 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 Privileges or data access sets required to query PVO ReceivingReceiptTransactionExtractPVOSummary: Need to query PVO FscmTopModelAM.ScmExtractAM.RcvBiccExtractAM.ReceivingReceiptTransactionExtractPVO via BI Cloud Connector. PVO is filtering data. Is there doc…Stéphane Lamy-Bouchard 14 views 0 comments 0 points Started by Stéphane Lamy-Bouchard Receivables & Collections
-
Which Data Store should be used to get Lookup information from BICC?Summary: Hi, We're using BICC to export data from Sales, however the lookup columns doesn't show the meaning, only the the codes. For example, "BR" instead of "Brazil" o…Max Prestes 11 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
BICC REST API to get last_extract_date of a PVOSummary: BICC REST API to get last_extract_date of a PVO Content (required): I am looking for BICC REST API to get last_extract_date of a PVO Version (include the versio…Naved Khan 462 views 6 comments 0 points Most recent by Antariksh Kar-Oracle Reporting and Analytics for ERP