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
-
ORC:Date of Probity, Date of Interview, Date of review fields in Subject AreaSummary: Currently there is no any subject area available in ORC to get details directly against Date of Probity, Date of Review, Date of Interview and other phases. can… -
For impact analysis on BIP data models which meta data table is used in Fusion HCMSummary: As a part of impact analysis how can we find particular field is getting used in which BIP data models. Content (please ensure you mask any confidential informa…
-
Query to get Payroll costing details to match with EFT paymentsSummary: Need query to fetch the Costing of payments - Accounts, Account Type, Cost amount (Debit & Credit), Accounting date and prepayment details. It needs to be match… -
Workforce Management - Workforce Trends Real Time subject area data dictionarySummary: Workforce Management - Workforce Trends Real Time - metrics calculation We are using the Workforce Management - Workforce Trends Real Time subject area for tren…
-
User-Defined tables name in Oracle HCM BISummary: Content (please ensure you mask any confidential information): Hello experts, do you know the BI table to extract user-defined tables? Thanks in advance for you… -
Using OTBI Analysis, how can we append sysdate (MM-DD-YY) to the filename?Summary: Using OTBI Analysis, how can we append the date (MM-DD-YY) to the filename? Content (please ensure you mask any confidential information): Can we append sysdate… -
Pivot Table > Sorting Date in Ascending Order Not WorkingSummary: Pivot Table > Sorting Date in Ascending Order Not Working Content (please ensure you mask any confidential information): Hello, We want to display the time card… -
COUNT in a CASE statement for a calculated field in OTBISummary: Need to create a calculated field using COUNT and CASE statement Content (please ensure you mask any confidential information): I am using this Subject Area: Wo…
-
Scheduling analysis for last day of monthSummary: Analysis schedules for end of month Content (please ensure you mask any confidential information): Hi everyone, Is there a way to schedule reports (analysis) in…
-
Query to get assessment questionnaire responses for an employee from learn moduleSummary: Query to get assessment questionnaire responses for an employee from learn module Content (please ensure you mask any confidential information): Hello, I'm tryi…
-
Courses Link table name for LMS reportFrom which table we can get the course link in bi reports. Can anyone help me with the table name. Thanks, Dara Nagasai -
SQL to pull Number of Days between two dates (one is a Parameter Date)?I'm currently using BIP Report. This sequel works on me if I'd like to use SYSDATE: TO_NUMBER(TRUNC(SYSDATE) - TO_DATE(TO_CHAR(SEN.SENIORITY_DATE, 'YYYY-MM-DD'),'YYYY-MM… -
Need query to resignation approved employeesHi, I have a requirement to send emails to employees whose resignation is approved. So I want to use bursting to send emails to employees. Can anyone help me out with th…
-
Rehire recommendation details are inconsistent in OTBI reportSummary: Need help with fetching data for Rehire Recommendation for terminated employees Content (please ensure you mask any confidential information): Hi, We have an OT…
-
How do I extract a portion of a text field before a special character in OTBI?Summary: One of our Display Name fields shows Preferred Name Last Name (pronouns). What is the expression to extract the portion of the text before the "("? Content (ple…
-
BIP Report Tagged to OTBI Dashboard is taking long time and error outSummary: BIP Report is developed and tagged to OTBI Dashboard. Taking longtime more than 10 minutesand then error out Content (please ensure you mask any confidential in…
-
Combine multiple Ethnicities in OTBI "Two or more races"Summary: Per the below - we have some Team Members that classify with more than one Ethnicity and the "Two or more race" option is no longer available in Oracle. This is… -
How to add multiple IF function in the Field Browser using Microsoft Word - BI Publisher?In my RTF template, I'd like to put a message for employees who are not belong to a specific department: However, in our case, some employees under 'ABC Expert' departme…
-
BI Report Access Issue - User Unable to Open and Access Report.Hello Community, I'm facing an issue with a BI Publisher HCM user information report. A specific user is unable to open and access the report, and I'm hoping someone can…
-
Audit of BIP Report ChangesSummary: Audit of BIP Report Changes Content (please ensure you mask any confidential information): Hi Team, Greetings! Is there any available feature to track or audit … -
Is there syntax in OTBI I can use to round down?I have age in years as 22.6 which I need rounded down to 22. Using ROUND rounds up to 23; applying data formats rounds up. e.g: ROUND((CURRENT_DATE - "Workforce Manageme… -
We are using Assignment Event Real Time and do not see correct Termination headcount in BI reportsSummary: We are using assignment event real time subject area and reporting annual turnover for previous 5 years. We are not seeing the correct turnover headcount when w…
-
How to get the Unique values in the table based value set query ?Summary: I need to get the List of unique manager name based on all the associates. But I couldn't use the distinct or any to get the unique value. Is there a way to han…
-
OTBI Report to get capacity rule's booked seat from Learning ModuleHello Expert's, Want OTBI Report to get Booked seats from Capacity Rule in HCM Learning Module. Please check below navigation and Image. My Client Groups> Learning Catal…
-
Blank lines while printing success criterion in OTBIWhen I printing success criterion in OTBI reports, it is giving blank lines before and after text of success criterion. Probably, the reason is that it is defined as HTM…
-
Results to be displayed vertically instead of horizontallySummary: Whenever I create a new OTBI Analysis it displays horizontally Content (please ensure you mask any confidential information): How do I change this to show verti…
-
SQL or ORA exceptions caused due to invalid sql, database package state or some database exceptionsSummary: Me pueden ayudar con el error que genera solo para periodos del 2024, el informe es un Publisher .
-
Repeating Groups - Excel Template BI PublisherSummary: Hi, I am trying to create a PO History Report and I am wondering if there is an easier way to group the data by a specific PO? Right now I have PO Number and PO…
-
How to access deleted data information using BI Publisher?Summary: 22A Record Additional Data When Deleting an Assignment Record Using Employment Info Page indicates accessing the deleted data information in BI Publisher (PER_E… -
OTBI Payroll Reporting - How to Generate Employee Data as of Payroll Period & not Current DateWe currently have an OTBI report using the Payroll - Payroll Balance Real Time subject area. Currently, if we run this report it pulls in the employee Business Unit as o…