BI Cloud Connector
Discussion List
-
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 9 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.1K views 11 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
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 …Manoharan 41 views 3 comments 0 points Most recent by Lohit Kad-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 8 views 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 18 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 22 views 3 comments 1 point Most recent by Peeyush Chandel Reporting and Analytics for HCM -
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…
-
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 689 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 2 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle 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 14.3K views 16 comments 12 points Most recent by Josh Vincent Reporting and Analytics for HCM
-
Unable to test Connection while using SFTP serverSummary: Hi Team, While is try to add a new connection with SFTP server, by giving all host, port , username and pwd and try to establish connection , it is getting fail…Dhilipkumaar 20 views 2 comments 0 points Most recent by Dhilipkumaar Reporting and Analytics for HCM -
View object cannot be found for HCM table PER_POSITION_EXTRA_INFO_FWe were using the oracle mapping document "Rel13_23D_BICC_HCM_Database_Mapping_with_ViewObjects.xlsx". Looking for the corresponding VO for table PER_POSITION_EXTRA_INFO…Ian Cosinas 82 views 3 comments 1 point Most recent by Chandra Chappidi Reporting and Analytics for HCM
-
What is PVO for 'FUN_USER_ROLE_DATA_ASGNMNTS' table to extract data from BICC to oacsSummary: What is PVO for 'FUN_USER_ROLE_DATA_ASGNMNTS' table to pull data from BICC to OACS Content (please ensure you mask any confidential information): Version (inclu…Navadeep.Chowdavarapu 24 views 2 comments 0 points Most recent by AnujGupta_Tom BI Publisher Learning Center
-
Where can we find the latest list of all HCM PVOs to be used in BICCSummary: We want to use BI Cloud Connector to pull HCM data. Where can we find the documentation for all available PVOs supported in BICC ? Content (please ensure you ma…Soumya Suravita 75 views 6 comments 0 points Most recent by Soumya Suravita Reporting and Analytics for HCM
-
BICC VO for PAY_COSTS linking to XLA tableSummary: We are looking for a BICC VO that links the PAY_COSTS Table with XLA tables. This VO should bring in the segment details. Currently we are using PAY_XLA_COSTS_V…Conor Murnane 33 views 4 comments 0 points Most recent by Conor Murnane Reporting and Analytics for HCM
-
24B: BIP - What is the OTBI subject area or tables to get transaction approvers from Learning?Summary: What is the OTBI subject area or tables to get transaction approvers from Learning? Content (please ensure you mask any confidential information): Please share …Nipon 21 views 3 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
We are taken the backup of BI report before cloning but now unable to edit the reportSummary: Hi Team, We are taken the backup of BI report before cloning but now unable to edit the report and I'm able to get below error ? PFA. Thanks, Ajay Content (plea…AjayKumar Maddipati 11 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Customer wanted to automate the process to send payslip over personal email for terminated employeesSummary: Hi Team, Would you please help us to get the steps how to achieve the requirement "automate the process to send payslip over personal email for terminated emplo…Rama123-Oracle 62 views 3 comments 0 points Most recent by Anca Andronic-Oracle Reporting and Analytics for HCM
-
Which table stores bip reports scheduled history data.Summary: Which table stores bip reports scheduled history data. Content (please ensure you mask any confidential information): Hi Team, Can some one will help me to find…
-
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…
-
Filter command field greyed outSummary: Need inputs to enter value in the Filter Command in the FTP delivery option Content (please ensure you mask any confidential information): In the FTP delivery o…Visu 11 views 3 comments 1 point Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM
-
Hi Guys query is returning DATA_DS, please help me where i went wrong int he query.Summary: My Query: select per.person_number, per_name.FULL_NAME PER_ABSENCE_ENTRY_ID , abs.absence_type_id, apae.APPROVAL_STATUS_CD,abs.name absence_type,to_char(apae.st…
-
Looking for Entity Relationship Diagrams (ERD) for SCM modules (Inventory, Order Management, PIM)Summary: Looking for Entity Relationship Diagrams (ERD) for SCM modules (Inventory, Order Management, PIM) Content (please ensure you mask any confidential information):… -
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 … -
Query to get the rollover balance of Annual Absence Plan on January-1-2024Summary: Hi Guys, i have i have scenario, Plan A and Plan B. Plan A is Base plan and Plan B is target Plan where rollover is being transferred. for example Plan A has 20…
-
Translation in PAY_MESSAGE_LINESTeam, We have a requirement to display the payroll error message name and message text. We are using PAY_MESSAGE_LINES to get the details. But this table has only Englis…
-
"HcmTopModelAnalyticsGlobalAM.OrganizationAM.LegalEmployerPVO" Does not give latest LE namesSummary: We are not able to get latest LE name from this "HcmTopModelAnalyticsGlobalAM.OrganizationAM.LegalEmployerPVO" , is there any Synch job that can be run to synch…Pooja Naganalli-Oracle 41 views 3 comments 0 points Most recent by Iulian Brinzoi-Nuta - HCM-Oracle Reporting and Analytics for HCM -
Information about Report and its linked data modelSummary: looking for any table or Subject area where we can get information about Report and its linked Data model. to ensure that every report linked with report after …Amit_Ekbote 1 view 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
PersonProfileItemPVO Issue post 23D, what's changed to impact this?Summary: We have a nightly extraction that retrieves delta data. Since 23D was applied the extraction is retrieving all data, causing timeouts due to the volume it is tr…Rebecca Hawker 11 views 1 comment 0 points Most recent by Alexandru Burcea-Oracle Reporting and Analytics for HCM