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
-
IBAN with BIPSummary: Hi experts, we need to create a report with the Employee's Personal Payment method Details like IBAN and bank account info. Does anyone know how can I create si… -
OTBI parameter issueSummary: Hi Experts, I need some assistance. I'm working on the Talent Profile Report and wanted to capture all the details in one report. I picked up multiple values by… -
per_person_secured_list_v view problemSummary: per_person_secured_list_v view is ignoring past events Content (please ensure you mask any confidential information): Hi, we have an admin user and she should h… -
I need a query to get the attached images from HR document record and print it in RTF templateSummary: I need a query to get the attached images from HR document record and print it in RTF template Content (please ensure you mask any confidential information): Ve…
-
Recruiting OTBI Performance issueSummary: Hi Expert, I need your assistance. I'm trying to combine two subject areas 'Recruiting - Recruiting Real Time' and 'Recruiting - Recruiting Event Real Time' and…
-
SQL query to fetch all postal codes and their corresposding county, city and state in US legislationHi All, I need an sql query to fetch all the postal codes and their corresposding county, city and state in US legislation. Please help Thanks. Sowmya
-
Get current and future termination EE records in OTBIHi, We are trying to build a demographic file that should pull the data of EEs as of system date and also future terminations in next 7 days. I have tried using the pref…
-
when the employee has signed the contractSummary: Hi experts, we have the following requirements: for all the employees it is necessary to retrieve info such as their person number and when they've signed the e…
-
Fast Formulas for Candidate Selection ProcessesWe have requirement to candidate selection process. After the final interview, once one candidate is moved to the "selected" phase, other candidates should have to be au… -
Compensation Zones and Grade Differentials of an employee in BISummary: How can I get the Compensation Zone and Grade Differential an employee is assigned to? I saw from previous posts that the details are in the CMP_ADDRESS_ZONES t…
-
Index Match formular for OTBIHi all, I am after some help on a formular that works similar to an index match formula in MS Excel I'm after the Legal Employer value of Managers using the manager pers…
-
OTBI: How can we run a report with the previous month start and end dateSummary: How can we programmatically run an OTBI analysis report with the previous month start and end date? Content (please ensure you mask any confidential information… -
Future new hire reportI am using Workforce Management - Worker Assignment Event Real time subject area. I am trying to pull all new hires and rehires. In order to included the future hires I …
-
How do I add the last absence end date from the last 5 occurrences?Summary: I need to report on the last absence end date on the attached report. It is currently filtered by rolling last 52 weeks and number of absences measure of 5. Is …
-
Unable to map missing columnSummary: Our team is redesigning an OTBI report and is facing an issue with mapping the column from the old subject area "Workforce Learning - Learning Management Real T…
-
Tables to pull the data for the eligibility profiles under compensation profile usage.Hello Team, The requirement is to pull the data for the eligibility profiles under compensation profile usage which are assigned to grade ladder. Please suggest the tabl…
-
Is it possible to deliver xml within body of email via BI Publisher?Content (please ensure you mask any confidential information): I understand this is possible by setting the delivery method as HTML via bursting, however is there a way … -
Hi Guys query is returning DATA_DS, please help me where i went wrong int he query.Summary: My Query: select per.person_number, per_name.FULL_NAME PER_ABSENCE_ENTRY_ID , abs.absence_type_id, apae.APPROVAL_STATUS_CD,abs.name absence_type,to_char(apae.st…
-
Workforce Management. Changes to view without informing customers: HWM_TM_RPT_ENTRY_VSummary: Workforce Management. Changes to view without informing customers: HWM_TM_RPT_ENTRY_V Content (please ensure you mask any confidential information): Hi Oracle C…
-
Overtime period field on payroll relationshipSummary: What table(s) can I find the Overtime Period field on the payroll relationship. I am being pointed to HWM_RP_TM_PERIODS_TL but this table does not seem to have …
-
not able to fetch latest date even after using MAX functionHi team i am trying to fetch latest last update date record in below query but unable to do it.i am looking for 2022 as a latest date record but when i use max function …
-
Tables for BI Consumer role, BI Administrator Role, BI consumer role in oracle fusion HCMSummary: Hi All, I need a table name or query for BI Consumer role, BI Administrator Role, BI Author role in oracle fusion HCM. Need to write a SQL query like, who have …
-
Payroll element BI table where retrieving employee Assignment IDSummary: Content (please ensure you mask any confidential information): Hello experts, I should retrieve for an employee the assignment id where a payroll element is loa… -
concatenate error in otbi reportSummary: CONCAT(NVL(TO_CHAR("Worker"."days"), '0'), ' Days, ', NVL(TO_CHAR("Worker"."months"), '0'), ' Months, ', NVL(TO_CHAR("Worker"."year"), '0'), ' Years') i tried t…
-
we would need a report with the previous and new cost center OTBI ?Summary: Hi Team, Hope all doing well ! we would need a report with the previous and the new cost center ? Could you please help me on ? Thanks, Ajay Content (please ens… -
how to create ORC otbi hires based on nationalitySummary: We have requirement to create otbi report for hired list based on nationality in ORC module. Content (please ensure you mask any confidential information): Vers…
-
Variable Prompt not filtering Analysis.I am trying to create a prompt for an analysis in OTBI. This analysis was created using Logical SQL. When I created a column prompt, I got the error - "Failed to Load(Od… -
Benefit analysis with benefit plan decline detailsSummary: I have created an analysis following the steps provided by the below post to get details of a benefit plan if any one declines the benefit enrollment. The analy…
-
Promotion and Demotions Report not pulling the intended dataSummary: Promotion filter pulls in Job change code change data as well which creates duplicates when actually there was only one promotion. Content (please ensure you ma… -
OTBI - recruiting - recruiting real time > Job Application issueSummary: Hi everyone, I'm customizing the 'Applications by Requisition' standard OTBI analysis. Trying to add the candidate Interview feedback field in the current analy…