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 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? -
Need to restrict Public output of a report to a group of peopleSummary: Currently report output generated using "Make output Public" is visible to everybody but we want to restrict this Public output of the report to a particular gr…
-
[OTBI] Delete HTML tag when exporting report to csv fileSummary: Delete HTML tag when exporting report to csv file Content (required): In order to delete the HTML tag in the OTBI report, the data format of the desired column …
-
Location Report - No ResultSummary: Content (required): Attempted to run a seeded BI Publisher report but there are no results. Shared Folders/Human Capital Management/Data Exchange/Location Repor…
-
How can I create dependent working parameters in SQL report?Hi, I have 'person number' and 'absence start date' parameters that I will use in my sql report and I have defined lov value set for them. But I want start date to come …
-
How to fetch sample termination extract containing sample data from HCM fusion ?We need sample termination extract containing sample data from HCM fusion as we are not renewing our contract with Oracle. Please let us know how to fetch this data .
-
How can I get mass results for Responses in Assessment?Summary: We assigned our organization (~7,200) a video to watch and asked everyone to answer a feedback question. All that was fine except now I am trying to report on a… -
Is the External Application Merge feature of FAW GASummary: Currently working for a customer who has a lot of custom SA's which they would like to bring into FAW. Merging the SA's into the FAW RPD seems to be the easier … -
BI Publisher SQL helpHello Team, i have written below sql to fetch count of time entries. select REC.RESOURCE_ID, count(distinct(to_char(start_time ,'yyyy-MM-dd'))) as Counter from HWM_TM_RE…
-
How to Pull Future Dated InformationSummary: How to Pull Future Dated Information from HCM Content (required): I have created a report in OTBI using the Payroll - Calculation Cards Real Time Subject Area. …User_2025-03-07-06-11-23-192 39 views 4 comments 0 points Most recent by User_2025-03-07-06-11-23-192
-
Tables to get the talent ratingSummary: What are the tables to get the Talent ratings(Performance rating) Content (required):Navigation Me->Directory(search for employee). Go to show more and click on…
-
Removal of first two rows in OTBI outputHi Team, When we schedule the OTBI report with excel output, Output contains first line with header and next line is blank. Our actual output starts from third line. How…
-
Add "Business Object Type" and "Attribute" columns to the Delete Audit ReportSummary: We had a custom report called 'Delete Audit Report' and the client wants to add columns on it for 'Business Object Type' and 'Attribute' same on what we see on …
-
Termination Headcount MeasureSummary: Subject Area: Workforce Management - Work Assignment Event Real Time, Assignment Event, Termination Headcount calculating terms on the last day of the month in … -
Reporting on Termination Counts - An analysisSummary This post provides an explanation on the calculation of termination counts in OTBI.Content The post contains a brief synopsis and also a sample analysis xml to c… -
Assignment Event/Workforce Trends - Counting a Termination on the Termination DateContent Hello Experts! I'm using Assignment Event Real time and have noticed that terminations are counted the day after their termination date. I suspect it's counting … -
How to count terminations as effective on termination date itself?Summary Looking for ways to summarize terminations per period (i.e. monthly) based on the termination date itself, rather than the effective start date of the term actio…
-
Are there any dashboard prompt experts or videos out there?Summary: Trying to create an EDI dashboard cross referencing with the new Learning Subject Area Content (required): I need to access data in three subject areas "Workfor…