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
-
Employees with Work NumbersSummary Return report for all employees and just list work numberContent Trying to build a report that lists all employees and in the phone type column only return Work … -
Count the number of employees per FTESummary Report which present the number of the employees per FTEContent Hi, We tried to create an analysis that count the number of the employees per FTE (Full-Time Equi…
-
Best Practice for reporting team to prepare for Oracle Monthly/Quarterly PatchesSummary Best Practice for reporting team to prepare for Oracle Monthly/Quarterly PatchesContent Hello! We are a team of OTBI and BI Publisher users, new to Oracle HCM. I… -
Trying to create a custom role for BI Consumer (Read Only)Content Dear Community, We have a question regarding the OTBI security : we usually give a read-only role to the dashboard to our line managers (role details in attachme…
-
Connecting Fusion to TableauContent Hi all - Is it possible to connect our Fusion HCM & OTAC instances to Tableau to do more graphical reporting? I know that I've read it might be possible but no r… -
BI Report: usage of fnd_sessions table first_connect and last_connect to track login time of usersSummary BI Report: usage of fnd_sessions table first_connect and last_connect to track login time of usersContent Hi, We have a BI report developed to track the login ti… -
Email a Link to Report Output Instead of Using AttachmentsSummary Can a hyperlink be sent to a user which will take them to the report outputContent Is it possible to send a hyperlink to a report's output rather than sending th…User_2025-01-30-00-59-25-861 69 views 3 comments 2 points Most recent by User_2025-01-23-21-24-21-434 -
BI Folder Structure: R12 vs. R13Summary BI Folder Structure: R12 vs. R13Content We're testing our recently upgraded pod and noticed that the folder structure that shows in Reports and Analytics is very…User_2025-01-25-02-53-28-953 52 views 5 comments 2 points Most recent by User_2025-01-25-04-02-13-126
-
New Hire NotificationsSummary Daily notifications of new hires created the previous dayContent Hi everyone - We are trying to create notifications of new hires created daily using analysis an…
-
BIP Publisher BurstingSummary BIP Publisher BurstingContent Hi, Is it possible to give multiple email addresses in the TO parameter of bursting definition sql query in Oracle Fusion HCM BI pu…
-
Future Dated TerminationsSummary Future Dated TerminationsContent Hello, Does anyone know of a way to pull in action codes that are future dated? When I run the analysis, I can pull in people th…User_2025-01-30-00-38-09-143 73 views 3 comments 2 points Most recent by User_2025-01-25-02-35-56-629
-
Release 13 - 50000 cell limit in BI Answers??Summary Our reports no longer can export the data they need!Content Hi all, Following our upgrade of release 13 there seems to be a limit on 50000 cells exported, we hav… -
Printing details on a single row using a XSL Fixed Position TemplateSummary Need help in printing both parent and child XML details in the same rowContent Hi All, Need your suggestions on how to solve the below requirement: 1. Applicatio… -
Printing details on a single row using a EText Fixed Position TemplateSummary Need help in printing both parent and child XML details in the same rowContent Hi All, Need your suggestions on how to solve the below requirement: 1. Applicatio…
-
How to get a report for all Saved transactions by Managers? BI Report for MSS Saved TransactionsSummary How to get a report for all Saved transactions by Managers? BI Report for MSS Saved TransactionsContent Hi Experts, How to get a report for all Saved transaction… -
Tables relating to NotificationsSummary Question to assist in building a BI Publisher report on Time Card notificationsContent I need to create a BI Publisher report on notifications for time card appr… -
Add dynamic logo to a BI Report (RTF Template)Content Hi All, I wanted to load a logo in UCM to link it with a conditional logic in a RTF template. I followed the instructions described in the document Signatures In… -
unable to query the rejected transaction details from the approval related tablesContent Hi All, We have a requirement to report on the approval transactions (approved/rejected) and we have built the query based on hrc_txn_fnd_bpm_task_vl and hcm_fus… -
BIP - Merging rows using an eText Template based on a conditionSummary The XML returned contains multiple rows for an employee, the requirement is to merge them all into one row using an eText TemplateContent Hi, We have a requireme…
-
-
Automate the Archive process in OTBISummary Automating the Archive process in OTBI for Fusion HCMContent Hi, We take backups of the OTBI catalog across our Fusion instances by archiving the custom folder. …
-
Job Function NameSummary Need Function Name in BI Publisher reportContent Hello, I am building a BI Publisher report and need to pull in the Job Function Name I found the JOB_FUNCTION_CO…User_2025-01-23-21-24-21-434 787 views 3 comments 2 points Most recent by User_2025-01-23-21-24-21-434
-
Dynamic column generation - Reporting with BIP (RTF/Excel Template)Summary Need to dynamically generate columns based on the number of elements currently present in the ApplicationContent Hi, We are currently on Release 13 Oracle Cloud …
-
What job role gives access to Human Capital Management – Approval Notification Archival Real Time suSummary What job role gives access to Human Capital Management – Approval Notification Archival Real Time subject area ?Content What job role gives access to Human Capit…
-
Lost 'Add subject area' functionality in OTBISummary Lost 'Add subject area' functionality in OTBIContent Hello, Since this morning, we lost icon that lets you to add additional subject-area during report creation.… -
TRU detail of an EmployeeSummary TRU detail of an EmployeeContent Hi While developing a report I have a road block to find Tax Reporting Unit detail of an employee. Can anyone please provide tab…
-
what is the fastest way to identify a field and which table it belongs to?Content what is the fastest way to identify a field and which table it belongs to?
-
Selecting multiple default values in prompts in BI reports and OTBI AnalysisContent I have a requirement where I need to select multiple values in the prompts in the BI reports and OTBI analysis. For example: Consider the column 'Assignment Stat… -
OTBI/BI report usage analytics?Summary How to get OTBI/BI report usage analytics?Content Is it possible to get OTBI or BI report usage analytics? input - Report Name Output - list of users who ran thi…
-
Hierarchical prompt for org tree strucutre in BI Data Model ReportContent Is it possible to create a prompt in BI data model report that will give us the whole org tree structure in a cascading way according to different levels as we h…