BI Cloud Connector
Discussion List
-
Seeded Process/Report/Data Model customizationSummary: Once we did customization of seeded Process/Report/Data Model, after applied any patch/upgrade then the customization changes will override. Content (please ens… -
Historical FTE values in BICCHi, The customer would like to extract assignment history data, including FTE, using BICC. I found that we can retrieve historical assignment data through HcmTopModelAna…
-
The datatype of this column is NULL and such columns are not supported in the BICC schedule extractWe are facing error "The datatype of this column is NULL and such columns are not supported in the BICC schedule extract" for few columns in HcmTopModelAnalyticsGlobalAM…
-
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 48 views 4 comments 0 points Most recent by Lohit Kad-Oracle Reporting and Analytics for HCM
-
cannot add descriptive flexfield to Skill and qualification OTBI reportSummary: Hi all, I am creating a Data model report on OTBI to extract all info related to a section in Skill and Qualifications: I was able to retrieve all sections name…Silvia Stangarone CAI 2 views 1 comment 0 points Most recent by Mark Stoker Reporting and Analytics for HCM
-
How to connect to Oracle HCM Cloud to Power BI using CDataSummary: We are trying to connect to Oracle HCM Cloud to Power BI using CData ( https://www.cdata.com/drivers/oraclehcm/powerbi/ ) So, our PowerBI developers can utilize…
-
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…
-
Department Costing Information related PVOSummary: We have a datawarehouse where we are pushing most of the HCM data using BIACM using the standard PVO. We couldnt find any PVO for department costing. I have gon…Sahil Kathuria 4 views 0 comments 0 points Started by Sahil Kathuria Reporting and Analytics for HCM -
BICC | Delta data records are not displayed correctlyHi, The BICC is to be used for the extraction of data. When testing the delta method, there are discrepancies between the status in the PER_ALL_ASSGINMENT_M table and th…Tobias I. 3 views 1 comment 0 points Most recent by Bala Mahalingam-Oracle Reporting and Analytics for HCM
-
AbsenceTimeEntryPVO - AncAbsenceType missing some valuesSummary: AbsenceTimeEntryPVO - AncAbsenceType missing some values that exists in base table HWM_TM_REP_M_ANC_ATRBS_V Content (please ensure you mask any confidential inf…Prakash Maram 12 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
R13.x HCM BI Cloud Adapter BI View Object to Database Lineage Mapping SpreadsheetSummary This posting includes R13 HCM BI Cloud Adapter BI view object to database lineage mapping. Content This spreadsheet is published by Oracle BI Cloud Adapter Devel…Rashmi M-Oracle 18.4K views 21 comments 11 points Most recent by Lauren B. Reporting and Analytics for HCM
-
Unable to find Job Requisition & Offer DFFs in PVOsSummary: We are looking for the PVO(s) that shows the Job Requisition and Job Offer DFFs (IRC_REQUISITIONS_DFF & IRC_OFFERS_DFF). We have been unsuccessful viewing this …
-
About OTBI, BI and EXTRACTSummary: Use cases for OTBI, BI and EXTRACT. When we use Extract, when we use BI and when we use OTBI Content (please ensure you mask any confidential information): Hi T…
-
REST API for Salary, Payroll elements and StocksSummary: Content (please ensure you mask any confidential information): Hello experts, do you know where retrieving REST API for Salary, Payroll Elements and Stocks? Kin…Valerio Curzi 26 views 7 comments 0 points Most recent by Shyam Rajbhar Reporting and Analytics for HCM -
Employee Active Payroll balance reportSummary: Employee Active Payroll Balance Report Content: We have a requirement to include New Mexico Workers' Compensation for both Employee and Employer in the Employee…
-
Request Documentation on Critical PVOs for Oracle Fusion HCM Integration with Data LakeDear Team, We have recently implemented Oracle Fusion HCM and are now working on integrating it with our Data Lake. To better understand the critical PVOs required for t…MDge 2 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Send automatic birthday wishes to employees via mail from organization.Summary: Send automatic birthday wishes to employees via mail from organization. Content (required): Hello All, I have a requirement, need to send automatic birthday wis…
-
Experience with Fivetran BICC integration with Oracle Cloud HCMWe are looking for an integration tool to support us with the data ingestion from HCM to support our analytics team to extract and analyze HR data. I want to hear your f… -
Setup connection/API from Fusion reports to Azure data warehouseSummary: Hi Team, Any suggestions on sending the data from Fusion reports (OTBI/BIP) to our internal Azure data warehouse without using a flat file method of SFTP. Any o…
-
WorkRelationshipPVO missing DFFsSummary: WorkRelationshipPVO is missing DFF's such as PDS_INFORMATION% and PDS_INFORMATION_DATE% columns from PER_PERIODS_OF_SERVICE. We are using DFF's to populate cust…
-
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 …
-
How to have a Batch ID parameter which is present in BIP Report in the Dashboard?Hi , We are creating a dashboard of a BIP Report for our use-case, BIP Report has a parameter called Batch ID with which we will pull the data regarding that batch load.…Sainatha B 21 views 1 comment 0 points Most recent by Ramchander Pothanolla Reporting and Analytics for HCM
-
Need to fetch the grade, grade step and grade rate at the employment level using BI reportSummary: Hi all I need to fetch the grade, grade step, and grade rate whichever assign to the person, but in my query, I am getting multiple grade steps assigned to the …Deepak Bhatt 2.6K views 11 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Matrix Manager Missing in BICC ExtractWe are using BIACM Extract (PVOs) to expose HCM data to PowerBI. Based on the document Rel13_21.x_BICC_HCM_Database_Mapping_with_ViewObjects, we understand that the PVO …Sahil Kathuria 1 view 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
What are the options to have read only capabilities to BICC (BI Cloud Connector) in OracleWhat are the options to have read only capabilities to BICC (BI Cloud Connector) in OracleVarun R 12 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Time Change Request reportSummary: Hi All, Has anyone Developed a BI/OTBI Report on Capturing Details of Time Change Requests? We have a requirement and working on this. Appreciate if anyone can …Abhishek Bhaskar 24 views 3 comments 1 point Most recent by Peeyush Chandel Reporting and Analytics for HCM -
abcdabcdShyam Rajbhar 12 views 2 comments 0 points Most recent by Shyam Rajbhar Reporting and Analytics for HCM -
How to use GET REST API call to get the candidate data based on candidate emailHi Team, We are trying to pull the candidate data using GET REST API call, is there any way to to get the candidate data based on candidate email. GET: /hcmRestApi/resou…
-
Extract the UCM content server attachments through BI ReportsSummary Extract the UCM content server attachments through BI ReportsContent Hi, PDC attachments(File formats like PDF,Excel,JPG etc) currently placed in UCM content ser…A.R Kumar 915 views 8 comments 0 points Most recent by Pranat Damani Reporting and Analytics for HCM
-
Looking for lineage data for a few VOs which are missing in Rel13_24C_BICC_HCM mapping sheetSummary: Looking for linkage details for following PVOs. These are not deprecated but missing in Rel13_24C_BICC_HCM_Database_Mapping_with_ViewObjects sheet. Any help wil…Vineeta Agarwal-Oracle 1 view 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM