Category 81
Discussion List
-
payroll report with gross pay showing element entry deductionsSummary: I need to create a report (OTIBI or BIP) that shows a person name, person number, pay period, pay period week, gross pay (for the pay period), add-in bonuses, (… -
Seeded Termination Report in HCMSummary: Good morning everyone, Does anyone know if there is a seeded termination report in Oracle HCM. Also, is there a best practice for verifying inactive employees? …Daniel McMillian 74 views 8 comments 0 points Most recent by Vibha Pandey - Oracle Reporting and Analytics for HCM
-
Create Security Report in OTBI with details of roles both past and present with dates and statusI tried submitting this question in the HCM Report Sharing Center that was discussed during yesterdays HCM Customer Connect but was getting an access denied error so pos…
-
OTBI Leave of Absence Report - No Absence ModuleSummary: Hello, We are trying to use the Assignment Event SA to build a report that will reflect all of the employees who are currently still on Leave of Absence and hav…CCannadayCTR 48 views 11 comments 0 points Most recent by CCannadayCTR Reporting and Analytics for HCM -
Run Payroll Costing Report flow relation with Payroll Costing Report Extract?Hi All, I'm trying to understand if there is any relation between Run Payroll Costing Report flow and Payroll Costing Report Extract? My requirement is to modify Payroll…
-
Anniversary report for specified dates in the NEXT MONTHSummary: Anniversary report for specified dates in the NEXT MONTH Content (please ensure you mask any confidential information): I have an anniversary report using Subje…JHaden3 246 views 9 comments 0 points Most recent by Andreea Herovic Reporting and Analytics for HCM
-
What is the BICC PVO (View Object) to extract data for pay_bank_accounts?Summary: I would like to extract bank accounts number from personal payment method. Examples of PVO are HcmTopModelAnalyticsGlobalAM.CompensationAM.PreSalaryPVO, HcmTopM…Babatunde Ayodele 116 views 3 comments 0 points Most recent by Babatunde Ayodele Reporting and Analytics for HCM
-
Getting extra employees in BI report those are not direct or indirect reports of logged in managerSummary: Created BIP report to get direct indirect reports of manager however we are getting few extra employee those are not direct or indirect of logged in user (line …Swati U 40 views 4 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Job requisition approver using OTBISummary: Job requisition approver using OTBI Content (please ensure you mask any confidential information): Hello experts, we would like to build an OTBI analysis specif…Oriana L. 65 views 7 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Talent HCM Extract: In value set want to return multiple rows.Summary: for each employee under talent profiles there are some languages which person added for each language there is one content_item_code from table 'HRT_CONTENT_ITE…Abhijeet Kambare 36 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Sample Manager Level OTBI reportSummary: Content (please ensure you mask any confidential information): Hello experts, do you have an example of OTBI report retrieving for an employee the entire manage…Valerio Curzi 50 views 2 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Fusion BIP Reports Permissions Changes AuditHi, Is it possible to know the person name/ID/number who updates the permission of various reports/folders in Reports and Analytics for BIP. Thanks!Shilpa Varghese 32 views 5 comments 1 point Most recent by Shilpa Varghese Reporting and Analytics for HCM -
Report Data PurgingSummary: How often your organisation request Oracle to purge the report job history? Content (required): We have reviewed the report job history and have noticed there a…Sejal R 81 views 2 comments 1 point Most recent by Gaurav Bharadwaj-Oracle Reporting and Analytics for HCM
-
Join between HR_ORGANIZATION_UNITS_F_TL and per_all_assignments_m table in Oracle Fusion HCMSummary: Join between HR_ORGANIZATION_UNITS_F_TL and per_all_assignments_m table in Oracle Fusion HCM for fetching employee division. Content (please ensure you mask any…Hitha Harikumar 796 views 16 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Overtime Report for Direct and Indirect EmployeesHi all, I'm looking to build an overtime report that can be used by mangers to see their direct and indirect reporting lines claims, etc I've usually used the 'Assignmen…
-
How to convert data rich text format to plain text in BIP.Summary: Am getting below output for one of Field format,:1. Words: 17Characters (with HTML): 897challa praveen 90 views 3 comments 0 points Most recent by challa praveen Reporting and Analytics for HCM
-
Subject Area Access for OTBI ReportingI am trying to create a report of all our Department levels and the hierarchy. I am using the Workforce Management - Work Relationship Real Time subject area. I don't se…
-
Query to fetch EOSB (End of Service Benefit) details from Oracle Fusion HCMSummary: Query to fetch EOSB (End of Service Benefit) details from Oracle Fusion HCM like : Hire date Hiring position Hiring grade Current grade Current position End of …Hitha Harikumar 252 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
what is the name of column and table under which I can find address typeSummary: what is the name of column and table under which I can find address type (e.g. current,mailing,home)etc of a person ?Since I need to add fetch data of person ha…
-
Grade null for Job requisition OTBISummary: Grade null for Job requisition OTBI Content (please ensure you mask any confidential information): Hello experts, we are building an OTBI report with "Recruitin…
-
How to retrieve the job req status for BIPSummary: How to retrieve the job req status for BIP Content (please ensure you mask any confidential information): Hello experts, we would like to build a BIP report wit…Oriana L. 84 views 4 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Customize BIP Standard Data Model and Report.We are converting the standard report into Customize report including data model When we modify the data model it does not affect in the report and doesn't make changes … -
Is there an updated HCM OTBI Subject Area to Table Mapping document that can be shared?Summary: Looking for the current HCM Reports - OTBI Subject Area to Table Mapping? I have release 12 and wondering if there is a current one. Content (please ensure you … -
HR_Action table in Workforce Trends subject areaSummary: The 23R4_HCM_Semantic_Model_Lineage spreadsheet contains HR_Action table that I am unable to find in R13_23A_HCM_OTBI_Database_Mapping_with_ViewObjexts document…
-
The 'termination category' stopped working in OTBI in 24ASummary: The 'termination category' field in the 'workforce management - work relationship real time' subject has stopped working for me in OTBI. I created a report in m…
-
Chetana Pawar 98 views 4 comments 0 points Most recent by Chetana Pawar Reporting and Analytics for HCM
-
Query to extract second manager level (under top manager) for all employeesSummary: Content (please ensure you mask any confidential information): Hello experts, do you have a sample query to retrieve for each employee the second level manager …Valerio Curzi 233 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
-
Query/ table to find the new joiners detailsSummary: Hi team, Please help to find the Query/ table to find the new joiners details in Oracle Fusion HCM such as: Current Job Title Last Title (Designation from previ…Hitha Harikumar 23 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM