Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
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
-
How to map multiple columns from 2 different subject areas to one dashboard promptSummary: Hello everyone, I have 2 different OTBI analyses - 1 that refers to the Workforce Management - Worker Assignment Event real time and the other one refers to Wor… -
Original Referral SourceSummary: How can we show the original referral source from the candidate's general profile? Content (required): If an employee refers a candidate for the first time the …
-
Missing time card OTBI/BIP report or analysisSummary: Content (required): Is it possible to create an OTBI or BIP report to show employees who have not handed in their time cards? Either standard or customized repo…
-
Customize- Payroll Register Report for the Latest ProcessSummary: Can we add additional attributes by customizing the seeded extract "Payroll Register Report for the Latest Process". Content (required): Can we add additional a…
-
Can't view own record in OTBISummary: I have a custom role where I would like to see my own data, only in OTBI but not to be able to correct it in HCM. Like add absence to my own person. I don't wan…
-
Table for security console audit?Summary: We have auditing enabled. Specifically, the "Oracle platform security services" option. We need the table names where audit tracking takes place with respect to…
-
Difference between primary assignment flag and primary flag in per_all_assignments_m tableSummary: Hi , Can anybody let me know what is the difference between primary assignment flag and primary flag in per_all_assignments_m table. How these two columns behav… -
OTBI report to Fetch Details of learning items assigned based on learning user groupsSummary: Hi Team, I am working on one OTBI report requirement - to fetch the details of learning course completion eg. learning item name, course completion date e.tc. T…
-
How can I pull a terminated employee's last annual salary into an OTBI report?Summary: Terminated Employees salary is not returning the expected amount. Content (required): I'm trying to create an OTBI report to use for balancing my payroll. One o… -
Concat string values in OTBI/BI AnswersSummary: Concat string values in OTBI/BI Answers Content (required): Is there a possibility to have a function like listagg for strings in OTBI/BI Answers? -
Table that stores BIP error detailsSummary: Which table stores BIP error details text? Content (required): We are trying to build a custom BIP report to summarize all BIP job errors into a notification em…
-
BI Publisher Integration with Google CalendarSummary: Can we integrate BI Publisher with Google Calendar (i.e.) To make a web service call from BI to Google Calendar API and create and update events. Please share i…
-
Document Record Deep Link in SQL Query - use parameter regarding uploaded document record IDSummary: There is a requirement for BI report to have direct / deep link to a document record for persons Content (required): I found the Deep Link URL and several of it…
-
How can I exctract Person Address ID field in OTBI?Summary: Content (required): Hello experts, I need to extract in some way the Address ID field to overwrite employee home addresses by HDL. Is it possible to find this f… -
How can I exctract Work Terms Number field in OTBI?Summary: Content (required): Hello experts, I need to extract in some way the Work Term Number field to update employee managers by HDL. Is it possible to find this fiel…
-
Need to know tables used for storing geographies for use in BI publisher reportSummary: Can someone help me with names of tables that internally store all geography hierarchy information in HCM. I need to use this in my BI publisher report to extra…
-
Combining Oracle HCM Source and data from Microsoft Excel file sourceSummary: Combining Oracle HCM Source and data from Microsoft Excel file source Content (required): We have created a report where we have defined a data model with a joi… -
Job offer letters issuei am working on recruiting module in HCM Cloud i wanted to create Job offer letters. we have mulcible templates for same requisitions using some conditions in main templ…
-
Table / View for New Features and Opt In Features?Summary: Is there a table / view that can be queried via BIP which would allow us to create a report of all of the implemented and non implemented features as seen in th…
-
How to display different email address types in separate columnsSummary: We have a requirement to display separate columns for work email address and home email address, one row of data per employee. Content (required): From reading … -
How to get a PTO Accruals report with ONE line of data for balance per EE?Summary: We are using a 3rd Party for our PTO Accruals (UKG). Primary issue: Some EE's are in 2 plans, so they have 2 lines of data. The issue is that UKG will only pick…
-
OTBI report for role , Security Context & Security context Value access assigned to userSummary: Creation of OTBI report for role , Security Context & Security context Value access assigned to user Content (required): HI Team, We have one requirement to cre…
-
How to Remove Person number From Human Capital Management - Approval Notification Archive Real TimeSummary: In Subject area Human Capital Management - Approval Notification Archive Real Time, column Subject "Approval Notification Details"."Task Title" can we remove Pe…
-
How to display the recruiting candidate's department name in OTBISummary: Content (required): I have a candidate who's department in the job offer is different from the one in the requisition. Using OTBI, is it possible to display the…
-
How to generate a report for HCM users who are not using SSO loginSummary: HI Team, We would need to generate a BI report which will contain all the users who are not using SSO login instead they are using their username and credential… -
List of Approvers in Workflow NotifcationSummary: List of Approvers in Workflow Notification Content (required): Hi , I need a list of Approvers who are going to approve the transaction in below format. I have …
-
Fiscal Year, quarter and Month in OTBI reporting as a parameter and also as a fields.Summary: We have a requirement to report Employee Details based on Fiscal Year, Fiscal Quarter and Fiscal Period. In the subject Area Workforce Management Assignment Eve…
-
Excel BIP report: Comment field split over several rows and columnsSummary: BIP report: How can we make sure that comment field is not split up over several rows and columns when exporting report to Excel? Content (required): Hi, we hav…
-
Delegation ReportSummary: Content (required): Is there a report or a subject area in which we can report all current delegations? We want to find which people are delegating to others an…
-
SQL Query to get HRBP assigned to an employee (when AOR uses organization hierarchy)Summary: We need a query to find HRBP assigned to an employee when Organization hierarchy has been used to assign the AOR(area of responsibility). It doesn't include any…