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
-
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…
-
-
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 …
-
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…
-
Employee Dates History ReportSummary: I have been asked to build a report showing an employees employment dates history; showing hire date, rehire date (if applicable), term date, and 2nd or 3rd ter…
-
Manager Self Service ReportingQuestion: For MSS, did you enable self service dashboard reporting via OTBI? How did you reference trend analysis? Thank you. -
OTBI Prompt: Returning Data Not Part of Selected Work EmailSummary: I have a prompt related for Work Email but when I tried to paste 5 work emails, the report return an email (Home Email) which not part of the 5 work emails sele…
-
How do I re-enable download functionality of BI Publisher output when using Firefox?Summary: After Firefox updated to version 123 yesterday, Feb 20, 2024, we can no longer download BI Publisher output anymore. Content (please ensure you mask any confide… -
Workflow Transactions Detail BI ReportContent Hi All, We have a requirement to create a report to fetch all the details of all workflow transactions going through approval. Is there a way to create a single …
-
query to get the vendor email id by vender id in publish report..?Summary: query to get the vendor email id by vender id in publish report..? Content (please ensure you mask any confidential information): Version (include the version y…
-
RTF Template creates incorrect word wrapping in output to PDFSummary: We have a company policy document that needs employees signature. We have an RTF template that contains all the verbiage and signature sections. When we output …
-
OTBI report to be accessed by differing security profilesWe have a dashboard which needs to be accessed by Line Manager, HR and Individuals. Is this possible to segregate this access in OTBI or will we need to create multiple …
-
HCM OTBI: OTBI Report Calculations IssueHi, I am facing an issue in OTBI which involves calculations. Please see the below example Column 1: SUM(Distinct TIMESTAMPDIFF(sql_tsi_month, "Worker"."Person Start Dat…
-
Payroll ReportSummary: Hi, We are trying to find an easy way to run a Payroll Register report from OTBI. I found this seeded Payroll Register report but it has parameters that I am un…
-
Report filter is not working in OTBISummary: Hi we need filter the two departments so When we applied the filter on department is not equal to two department names or dostnot contain also its not working. … -
can you append the sysdate to the file name while delivering the report through agents'Summary: can you append the sysdate to the file name while delivering the report through agents' Content (please ensure you mask any confidential information): Version (…