Category 81
Discussion List
-
Need table references for Managed Object Groups / Element SetI have created an Object Group of the type Element Group and added a few elements to it. Now, I am trying to retrieve the list of elements from a BIP (BI Publisher) Repo…Sai Krishna Adabala 12 views 1 comment 1 point Most recent by Chai-Oracle Payroll and Global Payroll Interface (GPI) -
I need a query which will fetch Percentage of employees with high risk of lossSummary: I need a query which will fetch Percentage of employees with high risk of loss in oracle fusion talent management Content (please ensure you mask any confidenti…Pritha 18 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
I need a query which will fetch Percentage of employees with succession plansSummary: I need a query which will fetch Percentage of employees with succession plans in fusion hcm talent management Content (please ensure you mask any confidential i…
-
I need a query which will fetch Percentage of turnover of top performing employeesSummary: I need a query which will fetch Percentage of turnover of top performing employees Content (please ensure you mask any confidential information): Version (inclu…
-
I need a query which will fetch Cycle time in days for the formal performance review processSummary: I need a query which will fetch Cycle time in days for the formal performance review process from start to finish Content (please ensure you mask any confidenti…
-
how can I create an alert within OTBIHello, how can I create an alert within OTBI? I need to send email notifications to both the manager and the employee. Is there any documentation or guidance available f…italoanjos 16 views 2 comments 0 points Most recent by Dhilip Kumar P. Reporting and Analytics for HCM
-
convert person from text to number in BIThe person number is presented as text when we export a report with the number to excel. Is there a way to get this person number as number value in reports? WouterWouter Schaap 12 views 4 comments 0 points Most recent by Carl Bequilla-Oracle Reporting and Analytics for HCM
-
Report for Qualification EntitlementsSummary: Hi, we have a requirement to create a report for the Qualification Entitlement details of employees. We have checked OTBI and BIP (both ANC_PER_ABS_QUAL_ENTL an…
-
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
-
Customizing Email notifications for timecard transactionsWe have a requirement where we need to send customized email notifications for the below timecard transactions: If a timecard is submitted by employee, a custom email no…Rini_Varghese-Oracle 1 view 0 comments 0 points Started by Rini_Varghese-Oracle Reporting and Analytics for HCM -
OTBI showing home department instead of worked/cost department for reported hoursWe’ve noticed a reporting discrepancy between HCM and OTBI when it comes to department allocation for hours worked. In HCM, an employee’s hours are correctly charged to …Trupti Khodke 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How can I pull an open requisition report that lists each Req's AOR representative?Summary: We would like to pull a report of open requisitions that includes a column listing the req's AOR Representative of a particular type. Content (please ensure you…Cheryl Burwell 14 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
In which table do I find the name of school in Skills and Qualification > EducationSummary: In this query hpi.item_number_9 returns the ID of the school field. But I do not know with which table the ID must be linked to display the description of the s…Consultant Ian 22 views 11 comments 0 points Most recent by Carl Bequilla-Oracle Reporting and Analytics for HCM -
Total current hours worked per employee in reportI am trying to run a report that will show every employee with the total number of hours they currently are contracted to work subtotalled (we have quite a number of emp…Karen Wilson 88 views 4 comments 0 points Most recent by Jose Guerra Reporting and Analytics for HCM -
SQL query to fetch the Candidate university name from Academic qualification section in ORCHi Team, Need assistance, we are trying to fetch the university name from the candidate education qualification section. But not getting the data from this table IRC_PRO…xbyz-Oracle 7 views 1 comment 0 points Most recent by Carl Bequilla-Oracle Reporting and Analytics for HCM
-
BIP Web Layout Editor (.xpt) Pivot table Header's Vertical alignmentSummary: Is there really no Vertical Alignment in Measure labels header in a pivot table in .xpt report template? it looks in the center in edit but in the output: I tri…Carlo Reyes-59977 3 views 0 comments 0 points Started by Carlo Reyes-59977 Reporting and Analytics for HCM
-
Hiding columns based on conditions in BI report excel outputRequirement: Based on the employee who is viewing his/her compensation, we need to do hide few columns depending upon the employee's LDG and his eligibility. Can anyone …Rini_Varghese-Oracle 13 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Getting Person ID of the direct reportee from a comp page for which the Manager is viewing the dataSummary: On the Compensation Info page, we have a requirement to embed a report with additional compensation information details and when a manager tries to click and vi…Rini_Varghese-Oracle 14 views 2 comments 0 points Most recent by Rini_Varghese-Oracle Reporting and Analytics for HCM
-
How to see who deletes datamodel/report in catalog?Summary: How to see who deletes datamodel/report in catalog? Content (please ensure you mask any confidential information): A datamodel is missing under analytics/catalo…Stefano_Mazzocca 4 views 1 comment 0 points Most recent by Dhilip Kumar P. Reporting and Analytics for HCM -
Query to fetch all the workflow transaction in HCMSummary: Team, can someone please share me the query to fetch all the transactions recorded in HCM Cloud(Transaction Console), I tried to query from fa_fusion_soainfra.w…Satyanarayana M-Oracle 4.3K views 7 comments 0 points Most recent by AnnaMorelli Reporting and Analytics for HCM
-
Hiding columns based on conditions in BI report excel outputRequirement: Based on the employee who is viewing his/her compensation, we need to do hide few columns depending upon the employee's LDG and his eligibility. Can anyone …Rini_Varghese-Oracle 13 views 3 comments 0 points Most recent by Rini_Varghese-Oracle Reporting and Analytics for HCM
-
employee tax declaration table name in fusionSummary: Content (please ensure you mask any confidential information): Hi team , need help on table name . where we will get all employee chooses which tax regime data …supriya kadam 1 view 1 comment 0 points Most recent by Rakesh Ghosh-Oracle Payroll and Global Payroll Interface (GPI) -
we have 3 level for performance goal categorySummary: Hi we have 3 level for performance goal category for employee need to validate sum of weights for each category not great than specific value form UDT, goal ent…Mohammed Alharbi 11 views 3 comments 0 points Most recent by Mohammed Alharbi Performance Management -
Formula for Days Open in OTBI for Job RequisitionsSummary: I'm creating an OTBI report for Posted Requisitions. Currently I'm using Job Requisition Open Date from the Recruiting - Recruiting Events Real Time and to get …Nicole A. 23 views 1 comment 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM
-
OTBI report to pull BPFM hierarchySummary: Could you please help in pulling the BPFM Hierarchy using OTBI Content (please ensure you mask any confidential information): Version (include the version you a…Nagarani M 13 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Can we create a dashboard using cards?Summary: Is it possible to create a visual dashboard within Oracle HCM to display key HR metrics such as headcount, billable vs. non-billable employees, attrition trends…Smruti Samruddha 16 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
Report on if employee has viewed / downloaded DOR?Summary: Hi team, We have recently been asked if we can report on if an employee has viewed / downloaded a specific DOR and/or its attachment? I am unsure on whether or …Luke.Findex 23 views 5 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Workflow Notification addition to DM and BI template not showing up on UI page (ManageCompensation)Summary: Hi Forum: on a Redwood-enabled workflow notification, our additional JobCode field we added in Employee Details section of ManageCompensation report/DM does not…
-
I'm unable to upload rtf template in report or it is showing uploading since long timeSummary: I'm unable to upload rtf template in report or it is showing uploading since long time. Content (please ensure you mask any confidential information): Version (…Anup Karmankar 23 views 4 comments 0 points Most recent by Ashish_Sahoo_Trinet26624 Reporting and Analytics for HCM
-
Can we set BPM expiration date for Absence Approval Tasks per absence type?Summary: In 24D, there is a new function in Absence Management called "Action on BPM Transaction Expiry," where we can configure each absence type to automatically appro…Shannon Teves 12 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM