Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for HCM
Discussion List
-
Notification email send customizationSummary: Notification email send customization Content (please ensure you mask any confidential information): Hello experts, we would like to edit the email sender of th… -
How to Test/preview etext templateSummary Have you ever created etext template to create delimited or fixed length files? Have you faced issues with debugging the template with ????? characters on the ou… -
Accrual balances not roll over to Target planSummary: Hi, I have created the 3 Absence Plans, Out of that one is Main plan where accrual will be calculated and Plan term is based on Anniversary dates. Along with th… -
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? …
-
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… -
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…
-
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…
-
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 …
-
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…
-
how to put criteria on OTBI anylisysSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
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…
-
Table details for My Public Info-->About Me SectionSummary Table details for My Public Info-->About Me SectionContent Hi All, Could you please help me with the table/Column details for employee 'About me' Section. I am a…
-
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… -
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! -
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…
-
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…
-
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): 897
-
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 …
-
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…
-
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…
-