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. (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 to compare output of two files in oracle fusionSummary: We've created a custom BIP report to get the salaries of each employee. This output from the publisher, we wanted to match with the document with same format wh… -
Pulling Goal Success Criteria without the HTML TagsSummary Is there a way to pull goal information without the html tags?Content Hello, I am looking to report on the Goal Information from HCM Fusion Release 11. When we p… -
For Goal notes report as well the description is in HTML format in the report.Hi Team, We are trying to pull a goal report along with long description and it is pulling the text in HTML format. Is there a possibility to get normal text for descrip… -
Report/Tables to extract User Role change History for every role assigned/revoked on a userSummary: Hi Experts, We have a requirement from the customer to track the history of changes on a user roles. Ex, If a user has been assigned a role on 01-Jan then that …
-
BIP Report: Position title change data irrespective of their current employment status.Summary: Hi experts, I am looking for a report which can return previous and current employment fields if position gets changed. Mainly looking out for these fields: Pre…
-
How can we apply calculation at column level in OTBI reportSummary: We have a requirement to put condition at column level to find out requisition which has approved days greater than 60days. EX- We have a report at dashboard, w…
-
Can I make the parameters more dynamic so they show only values relevant to the management hierarchySummary: Can I make the parameters more dynamic so they show only values relevant to the management hierarchy in line manager dashboard? Content (please ensure you mask …
-
Is it possible to create a pivot table "view" in Excel BI Publisher?Summary: Is it possible to create a pivot table "view" and one with a report in a regular table? Content (please ensure you mask any confidential information): I'm tryin… -
Historical Date Reporting - BIPWhat would be the equivalent OTBI's SET VARIABLE PARAM_EFFECTIVE_DATE='2006-05-18'; in a data model. I am trying to create a BIP report where users can enter an as of da…
-
Personal Payment Method Processing OrderSummary: Hi all So I've seen this asked before on another post but there wasn't a solution. The processing order for Personal Payment Methods doesn't appear to match up …
-
Exempt from State Income Tax Withholding Report QuerySummary: Exempt from State Income Tax Withholding Report Query Content (please ensure you mask any confidential information): Hi Team, Greetings! Is there an existing re… -
Salary details are not getting fetched for Subject area Recruiting-recruiting real timeSummary: I have seeded compensation manager role with required duty role Compensation Transaction Analysis Duty and Compensation Transaction Analysis but still i am not … -
I am trying to add Division to an analysisSummary: I am trying to create a "Master Employee Data" report that includes payroll information so I'm using the Compensation Details - Salary Details Real Time subject…Jenna Savage - Hunter Douglas 51 views 12 comments 0 points Most recent by Jenna Savage - Hunter Douglas
-
Query for finding Assignment number from Calculation Card under Associations.Summary: Need a query through which we can find assignment number from calculation card under association. Content (required): Hi All, Can anyone please share the query … -
Query to fetch DFF's used across modules in a PODSummary Query to fetch DFF's used across modules in a PODContent Hi Team, Please help with this: Please share query which shares all DFF's used across modules in a POD l… -
Unable to report on Guided Journey QuestionnaireSummary: We've created a guided journey questionnaire as part of the requisition process for hiring managers, however we are unable to report on the data. We've had an S…
-
OTBI Report- Annualized Salary values not populating from the Compensation -Salary Details Real Timewe have an OTBI Report that utilizes two subject areas. It includes some absence related columns such as Periodic Accrual, Processed absences etc.. from Workforce Manage…
-
Need to report on Work schedule with attached work pattern and attached holidaySummary: Hi Every one, I need help to develop one absence report where we can see work schedule and attached exceptions and workday/non workday. Below is sample output:-… -
SQL code to fetch Overtime, bonus, commissions, merit increases, and locality pay for employeesSummary: Hi Experts, Please provide the SQL code to fetch overtime, bonus, commissions, merit increases, and locality pay for employees. Thanks. Content (please ensure y…
-
Oracle HCM BI Table to retrieve employees Eligible for a compensation planSummary: Content (please ensure you mask any confidential information): Hello experts, we are building custom BI reporting collecting compensation plan columns at the em… -
Absence Calendar Subject Area not showing all dataSummary: When I run my report using the Absence Calendar Subject Area a large amount of data is missing. I have tried running the Generate Daily Breakdown of Absence Det… -
Does anyone set up goals and perform management for Redwood ? Are any issues faced ?Summary: Does anyone set up goals and perform management for Redwood? Are any issues faced? Content (please ensure you mask any confidential information): Version (inclu…
-
Ability to Report on Person Profile Competency Rating vs. Model ProfileSummary: Hello, I need guidance on whether it's possible to generate a single analysis that compares an employee's rated competency with the competency level associated …
-
Absence notification is not sent to Line Manager after Employee withdraws it.Summary: In the Absence approvals, when an absence is requested by an employee and is approved by their Line Manager, when the employee attempts to withdraws the absence…
-
Report - send notifications to usersHi together, We have following requirement from our customer: They want to have one report, where they can check (based on security level through AOR) which notification… -
Need to skip HTML tags while displaying in the outputContent Hi All, We are facing an issue in Performance Management in Fusion Cloud. In the back end database table in one of the column (HRA_EVAL_RATINGS -- COMMENTS) whic…
-
How to include a pdf attachment in a custom NotificationSummary: How to include a pdf attachment in a custom Notification Content (please ensure you mask any confidential information): Hi, we created a BI custom notification.…
-
how to call BIP report using REST webserviceSummary: I want to get the BIP report output using REST webservice REST API for Oracle BI Publisher - Run report I have followed oracle doc and this Run Oracle BI Publis… -
Generate query related ODA reportsSummary: I want to generate analytics report for responses for specific queries like feedback query to understand bot responses and communication with user to improve pe…
-
Need table names or SQL for Approved OTL timecard details in BIPSummary: Hi Team, I Need table names or SQL for Approved OTL timecard details in BIP. We need particular person entries and along with approver comments. Navigator->my c…