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
-
SQL query to fetch the list of values for each value setSummary: Business requirement is to fetch the list of active values for each value set code in excel. Need to develop SQL query to fetch Each segment Value set code valu… -
OTBI Analysis not fetch all Consolidation Grouphello expert, I have an OTBI Analysis on payroll balances, but it's not able to fetch data from all the consolidation groups in the system, it only pulls from one one co…
-
employees job interestsSummary: Report on employees job interests Content (please ensure you mask any confidential information): In opportunity Marketplace employees can record their interests… -
OTBI Report integrated within performance document is not loading first timeSummary: OTBI Report integrated within performance document is not loading first time Content (please ensure you mask any confidential information): I have OTBI report c… -
Performance OTBI to extract Task Status, Section Names, Rating LevelsDears, we have a requirement to build an Analysis to extract performance document task status and ratings given to each document section. To do so we are crossing "Workf…
-
Analysis relational filterSummary: I am trying to create an OTBI analysis as a new Oracle customer. Certain fields have multiple values. I am wanting to create one unique row per person , where t… -
Report to fetch employees that have not setup goalsHi, Does anyone have below- Report to fetch employees that have not setup goals (100% weight enforcement) for the goal plan applicable for current review period. -
Privilege required to see Home Phone and Home Email Address in BIP ReportSummary: Content (required): We have few BIP reports created to cater to the client requirement. We see that the report doesn't fetch the Home Email Addresses and Home N…
-
BIP Report not retrieving data for single value in parameter, But same is working fine in DataModelSummary: BIP Report not retrieving any data when single value is selected in parameter, But the same is working fine in Data Model. Please help. Content (please ensure y…
-
Fusion HCM - OTBI Report - Can't view other employee's data only my own ?Summary Fusion HCM - OTBI Report - Can't view other employee's data only my own ?Content I have created a OTBI report with the subject area 'Workforce Management - Worke…
-
Active department not found in reportHi, We are using the department level to differentiate between departments (divisions, sections, units). We have created a new tree version based on the new requirements… -
for-each OTBIHello everyone, I have the following problem: I have a report that is grouped by several groups and subgroups. I need to be able to total the columns for each subgroup a…
-
Need to report on Employees work schedules and patternsContent Hello, We need to be able to report on employees work schedules and patterns so we can create a report that looks like a calendar and show the days that employee…
-
Not available Inbound Interface type HCM Extract in oracle fusion hcmSummary: Not available Inbound Interface type HCM Extract in oracle Fusion HCM. We need to read element details and reload through HDL process. Content (please ensure yo…
-
Session Variable for Payroll Run Results real time to restrict to managers onlyHello, In Workforce Management - Worker Assignment Real Time we're able to use this session variable filter "Workforce Management - Worker Assignment Real Time"."Assignm…
-
Tips, Suggestions of migrating Taleo Reports to ORacle REcruiting CloudSummary: We have taleo reports which we want to create also in oracle recruiting cloud. I Would like to ask what are the possibilities of migrating besides manually crea…
-
BI report: how to differentiate between learning outcomes and prerequisitesHello, is it possible to differentiate between learning outcomes and prerequisites? which table can we use to retrieve learning outcomes and what table for prerequisites…
-
What table that holds actual work schedule of employee ?I want a query that gets the actual work schedule of employee in this screen
-
Performance Management Goal Report - Fusion OBISummary Listing of employees that have been assigned a goal planContent I am trying to write a report in Fusion OBI that will pull all employees that have been assigned …
-
Consolidated List of OTBI and BI Publisher Reports Posted (14 April 2015)Content The following is the list of published OTBI and BI Publisher reports between 10 December 2014 and 10 February 2015: * OTBI: Employee Salary and Performance Ratin… -
OTBI Vacancy ReportSummary: Is there a way to report using Subject Area(s) all current employees and any requisitions and vacancies so we have one entire list? For example a report that sh…
-
Can any one share sql query to fetch employee contacts details(contact person_id,date of birth)Summary: I have a requirement to fetch employee conatct details(Children),contact person Id, date of birth and their marital status, can anyone help me? Content (please …
-
Veteran StatusSummary PER_PEOPLE_LEGISLATIVE_F ;PER_PERSON_LEGISLATIVE_DATA_LEG_DDF'Content Can someone please help on attribute mapping from the application screen(i.e Armed Forces S…
-
2717700.1Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Currency conversion rate not applied for monetary item in TCSThe currency conversion rate was expected to be applied to the equity data loaded through the external data screen in the TCS system. However, it appears that the system…
-
HCM Custom Extract Guide for Payroll ReportsSummary Sample extract with modularized UEs for customized payroll reportsContent Change Notes Date Version Change Reference 16-May-2018 v1 First Version 18-Sep-2018 v1.… -
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…
-
Seeded Process/Report/Data Model customizationSummary: Once we did customization of seeded Process/Report/Data Model, after applied any patch/upgrade then the customization changes will override. Content (please ens…
-
Is it possible to report on Number of Positions requested, approved, rejected, pending?Summary: I have a requirement to design a Dashboard designed to track the overall timeline to 'Hire an new employee' from the time the initial position is requested/amen…
-
Sql query required to identify time card approver and assignee detailsSql query required to identify time card approver and assignee details. We tried to join hrc_txn_header, hrc_txn_data and fa_fusion_soainfra.wftask to get the details. B…