Get Started with Redwood for Oracle Cloud HCM Begin Now
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.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for HCM
Discussion List
-
Oracle Recruiting - DeepLink to Candidate general profileContent Hi Team, Is there a way to have a deeplink for candidate profile (general profile)? Thank you, Shikha Version 20D
-
Report to identify Users when Clicked on Learning Tile under My Client GroupsSummary: Report to identify Users when Clicked on Learning Tile under My Client Groups Content (please ensure you mask any confidential information): I am looking to see…
-
Job offer approversSummary: We need to create a report that includes: 1. Requisition Number 2. Job Offer Candidate Full Name 3. Job Offer Business Title (under Offer Assignment Details) 4.…
-
Why are there different formats of the Transaction Analysis Duty role codes?Summary: Some Transaction Analysis Duty role codes follow this format: "ORA_FBI...DUTY_HCM" and others this format: "FBI…DUTY". Is there any significance to the role cod…
-
Participant Feedback - Questionnaire Responses duplicationSummary: Dear Team, We have a Performance template which has the Participant feedback included and would like to capture the responses provided by the Participants in th…
-
HCM Position HierarchySummary: Hello, I created an OTBI using Position Real Time subject area but I am not able to get the desired results. Example, I have below position hierarchy Position1 …
-
function to return fast formula return variabledo we have any function / package in hcm that we can use in BI query to retrieve the return values from a Fast Formula. Like we have one for value sets (pay_ff_functions…
-
Building a custom report for pay ratesSummary Client is using the newly released salary basis based on rates of pay. There are no OTBI subject areas and need to create a new data model.Content The tables hol…
-
SQL query of Fast Formula retrieving manager+1 and manager+2Summary: Content (please ensure you mask any confidential information): Hello experts, do you have an SQL query or fast formula to retrieve the employee manager+1 and ma…
-
Custom BIP reports - Security access to view scheduled job outputsSummary: Hi All, We have 5 custom BIP reports, which are shared via scheduling to 5 different groups of people in our organization. We are not sending the output via ema…
-
HOW TO DELETE INACTIVE USERS IN fUSIONSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Extract run Failing after adding new FastFormulaSummary: Extract is failing after adding new rule to get the correct parking tier based upon employee salary Content (please ensure you mask any confidential information…
-
OTBI report prompt to display only direct reports for Line managersSummary: We have created an OTBI report using the subject area - 'Workforce Learning - Learning Management Real time'. We have created a prompt which displays all the Em…
-
Difference between Headcount and worker count in fusion analytics dashboardsSummary: Why are there two extremely similar workbooks (for many metrics) which include Person Count and some which do not. Their descriptions show the only difference i…
-
How to print salary amount in Latvian and Estonian in BI Report?We have a requirement to generate Employment Contracts for Latvian and Estonian employees. We got everything to print in the letter except the salary amount. As per requ…
-
HCM Reporting/Extracts usage recommendationsSummary Out of plane vanilla sustainable reporting ideas for HCMContent Disclaimer: following post expresses personal opinion of author based on many years and many rele…
-
Where can I find release notes regarding OTBI and BI Publisher for HCM?Hello, I am looking for Release Notes or What's New regarding OTBI and BI Publisher for HCM Cloud. Could you please help me find where they are? Kind regards Alice
-
Candidate date of birth and gender are not pulled from OTBI reportSummary: Hi, I have used Recruiting-real time subject area ans used "person date of birth", "person gender" columns to fetch the candidate date of birth and gender. Howe…
-
unable to find the table which stores the approver details for fusion bpm nor rest api, please helpSummary: Hi Experts We are unable to find REST API or fusion table to extract the approval rules and the approver details. Below is the more details Would like to extrac…
-
Fast Formula or query retrieving the number of working daysSummary: Content (please ensure you mask any confidential information): Hello experts, it is possible to build an SQL query or Fast Formula retrieving the number of work…
-
looking for ytd and ptd bip reportSummary: lookind for ytd and ptd bip report Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Co…
-
Report to get Original Date Earned of element entrySummary: Report to get Original Date Earned of element entry Content (please ensure you mask any confidential information): Hi Team, Greetings! Does anyone have the repo…
-
Determine Account date for PAY_COSTS entriesSummary: I am trying to figure out how to get back to the accounting date from each entry in the pay_costs table. We have a need to get this down to the person for some …
-
Canada's Employment Equity Questionnaire (Legislative Requirement)Summary: Hi Team, I would like to ask for your thoughts if you have configured or added this legislative requirement of Canada to the system? It's like a set of question…
-
ORACLE FUSION HCM QUERY TO GET USER ACCOUNT LOCKEDSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Can i see what a user sees from PER_ASSIGNMENT_SECURED_LIST_VWe have a user downloading a report but seeing just 600 result compared to another users that can see more than 800. The only thing in the report that could prevent him …
-
Personalization of help desk requests page in redwoodSummary: We have requirements to personalize help desk requests page to split category field to category and sub-category, noting that the page is redwood and personaliz…
-
Terminated employee still visible as incumbents in position, how to free the vacant positionSummary: Terminated employee still visible as incumbents in position, how to free the vacant position Content (please ensure you mask any confidential information): Vers…
-
In Oracle Fusion HCM, eText template with UTF-8 character set converting space to special character.Hi Community, I am facing an issue in eText template with UTF-8 character set, whenever for a field if it has space as a value it's converting space to special character…
-
Page breaks do not work for bursting (RTF template -> Excel output)Report has RTF template and it is exported to XLSX format only. Resulted Excel has 2 separated sheets (from functional logic one Excel file contains 2 reports are spaced…