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
-
Need to report on Document Record attachmentsContent can we report on Document Records attachments count? Has anyone done it? Can anyone share a report or any with me? Thank you in advance! Version 21B -
Shared folder report are not recived by users and when only through my folder recived by usersSummary: HI Team, when i scheduled through shared folder BI report are not recived by recipients and when scheduled through my folder only recived by recipients. May I k… -
What is the Subject Area for Things to Finish (which are displayed on the user home page)?Summary: We have a requirement to show the count and Details of Assigned to Me under Things to Finish (which are displayed on the user home page) in an OTBI dashboard, s… -
How to calculate avg HC i.e (each month end active headcount / no. of months ) in OTBISummary: How to calculate avg HC i.e (each month end active headcount / no. of months ) in OTBI Content (required): Version (include the version you are using, if applic…
-
How to set up time period for 12 week rolling percentageIn the "Workforce Management - Workforce Trend Real Time" subject area, in the "Workforce Trend" folder, there are the following fields: I need to use these in a calcula…
-
Equate a node from Root Data Group and a child Data Group on EText for HCM ExtractHello Experts, Have you tried anything like this in etext template & HCM Extract combination? I have a node in my Root Data Group "Emp_DG' that I want to equate with a c… -
Line Manager Element Entries ReportingContent Hello everyone, We have a requirement that our line manager population needs to report on Element Entries (OTBI Report). When we run the report managers are able… -
Options to perform data extraction from FAW DBSummary: We are looking to perform data extraction from FAW and load into a snowflake DB for some strategic reporting solutions. Is there any recommended approach for su… -
Learning Module | Sql query to get details of default assignment rules of the courseContent I have a requirement where I need to create refresher alerts for mandatory courses – based on the renewal period set for the course. Notification will be trigger…
-
regexp_replace not working in etext templateSummary: regexp_replace not working in etext template Content (required): We have a requirement to remove extra semicolon from the string. Using regexp_replace, we are a…
-
Missing Work Phone TypeSummary: I'm looking at the subject area mapping, and playing with a few subject areas, but I cannot figure out how to build an analysis to see which employees are missi…
-
Can I put a link inside my Bursting query?I want to add an oracle link to send it in the mail notification in the message I print inside my bursting query, is this possible? -
Impossible to open an OTBI reportSummary: Impossible to open an OTBI report Content (required): Hello experts, we have seen that, since a couple of weeks, a specific user is not able to open a report an… -
Recruiting - recruiting real time subject area not giving expecting dataSummary: We built an analysis using Recruiting - recruiting real time subject area while extracting the data we will able to get only Open Phase information However we w… -
FAST FORMULA PER_PERIODS_OF_sERVICE ATTRIBUTE_DATE1 DBII want to find the database item that the Attribute_date1 field in the per_periods_of_service table corresponds to for use in the Fast formula, but I couldn't find it. C…
-
how can I get one seniority date when multiple seniority dates are there for a person in OTBISummary: I am reporting from Workforce Goals - Goal Status Overview Real Time and Workforce Management - Person Seniority Real Time. When I have Seniority Date showing, …
-
Add timestamp so hours and minutes information capture while different phase in Job OfferSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
How can we pull data in custom report for the field name "Action" on Termination page.Summary: I am trying to generate a custom report and want to know the column name for the field name “Actions” in the Termination page. We do get the data for the other …
-
Fetching Workforce Structure from Job Profile Type in BI queryContent Hi Team, I have a requirement of fetching "Workforce Structure" from Job Profile using BI query.Please help me with the query. Thanks Sandip Karmakar -
Original Candidate sourceSummary: Content (required): Is it possible to capture candidate’s original source via reporting? Currently the system only tracks application source and we lose key dat…
-
Dependent ReportSummary BIP that provides Dependent info (Name, Person Number, Age, SSN, etc)Content This a BIP that includes Dependent data (sorry, couldn't do an Answers report) -
Payroll GL costing details in HCM fusionSummary: Please guide me to get the below columns where to fetch in hcm fusion tables Ledger Group Accounting period GL Distribution status Open item status Monetary amo…
-
How to take Length of service(in years), Service category and transfer detailsSummary: How to take Length of service(in years), Service category and transfer details? Content (required): Hi All, We got a BI report requirement to show employee's Le…
-
How can I pass the current date to a job that runs a BI publisher report with a text parameter?Summary: I have a report that takes a date in TZ format (ex: '2023-03-10T00:00:00.000+05:00'), through a text parameter. I need to create a scheduled job for this report…
-
OTBI: Multi Tab Excel Downloadable OTBISummary OTBI: Multi Tab Excel Downloadable OTBIContent Hi All, We have a requirement of creating a single OTBI analysis with multiple layouts. Each Layout should have a … -
Data Lineage on the FAW HCM LearningSummary: Looking for Data Model / Data Lineage for FAW HCM Learning area. That will have the joins/ information relation between the entities. Can anyone help with that.… -
OTBI:Individual Comp: Single row with Award Amount and Frequency in spite of data model constraints1- Below OTBI report has been built using "Compensation - Individual Compensation Real Time". It provides insights into the Awards awarded to an employee and the frequen… -
OTBI created to fetch details of Absence accrual balance is not picking latest dataSummary: Content (required): We have created a custom otbi report which fetches the details of accrual balance. But we observed that the data is not getting updated on d…
-
What is the process for adding group totals on an OTBI analysis?Summary: I want to add a group by employee number and to show its total trip distance for all start dates. Content (required): I have created an analysis based on Expens…
-
What does it mean to have 'INITIAL' in the 'STATE' field in the hrc_txn_data table?When I query the records with 'DRAFT' from the transaction table, the STATE field is reflected as 'INITIAL' AND 'SAVED'. What exactly does INITIAL mean?