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 can we pass date parameters into the List of values to fetch the data based on the date rangeHow can we pass date parameters into the List of values to fetch the data based on the date range? Based on the dates the recoded should get refreshed in the parameter n…
-
query to fetch global transfer employees in fusion hcmSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Workforce Management - Worker Assignment Realtime, Work Assignment, FTE returns >1 incorrectlySummary: The attached analysis returns an FTE value greater than 1 for 49 records. We believe the calculation for FTE should be FTE = ((standard hours * headcount) / nor…
-
Recruit to Hire Dashboard customizationHi Team, As we have seeded Recruit to Hire Dashboard, we want to have customized dashboard based on our requirement. we want to hide below items from the dashboard. Can …
-
EEO-4 Category table nameSummary: Hi, everyone. would like know where I can found this columns. Regulatory Response Ethnicity - TEXT → I can't found the string data data type. EEO-4 Category → E…
-
24C Worker Sensitive InformationI am testing the Secure Reporting on Worker Sensitive Information feature in 24C. I followed the steps for both Person Legislative Information and Person Ethnicity. I wa…
-
How to fetch Reason value from ORC in BI reportSummary: Hello Experts, Need your help in pulling a field called reason found in ORC module. PFA the screenshot of the field i want pulled. I am aware this field is pres…
-
Ability to burst output file from BIP Report to OCI object storageWe have a requirement to burst output files of BIP reports to the OCI object storage buckets. Currently we don't see any delivery option in bursting that supports this. …
-
Accessing worker details in learning report by learning specialistDear Community, We have the BIP report request from user which required to show worker name, worker number and department information in the report. While the users are …
-
Trying to find a Link between Career Site and RequisitionSummary: We are trying to derive the career sites where a specific job requisition is published. Can you point us to a REST API which can provide this information ( alre…
-
How to enter the 'Export' Action in a DashboardSummary: How to enter the 'Export' Action in a Dashboard Content (please ensure you mask any confidential information): Hi, we created a Dashboard, based on an OTBI Repo…
-
Learning assignment alert delivery reportSummary: We have a requirement to report on the delivery of compliance assigned training alerts for audit purposes. Content (please ensure you mask any confidential info…
-
Need a standard SQL query documentation?Can someone please share a Oracle standard SQL query documentation?
-
How can we fetch Calendar year to date value of any balance in Oracle BI Report.Need to fetch Calendar Year to Date value in Report.
-
Per_Periods_Of_Service Not adding a Row for Voluntary Termination ActionsWe have been noticing that certain termination actions are NOT hitting the per_periods_of_service table. For example, if I submit a retirement for myself and it goes to …
-
Workforce scheduling: can't get details of patterns and shifts to show on analysisSummary: Looking for direction on how to find and capture the patterns and shifts in my analysis. Under Define Availability: Work Shifts, Work Workday Patterns and Work …
-
HR benchmarking data - best practicesHello All We have recently been requested to pull HR bench-marking data, so we can do some analysis on KPIs and metrics that represent the typical performance within our…
-
how can I get multiple seniority dates on the same row in OTBIContent (required): I am reporting from assignment real time, person real time, and person seniority real time. When I have Seniority Date showing, there is one row with…
-
Subject Area (or Table) for Regional General Preferences?Summary: Are the General Preferences: Regional reportable in OTBI/BIP? Content (please ensure you mask any confidential information): Hello everyone, Asking if it is cur…
-
calculation card querySummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Workforce Learning - Learning records Real time returns no dataSummary: Workforce Learning - Learning records Real time returns no data Content (please ensure you mask any confidential information): Hello I am trying to build a repo…
-
Seeded Head Count Reports Not WorkingSummary: We have been trying to run the seeded Head Count reports for our client but none of them have been rendering data. Content (please ensure you mask any confident…
-
Scheduled classes not available in Learning Calendar Summary dashboard?Archived Learning Calendar Dashboard from Oracle demo instance. and unarchived dashboard in our instance. Data is displaying like this but, in oracle demo instance it is…
-
BIP encryption with UTF-8 encoded csv fileHi Team, Can you please help me know how to generate a UTF-8 encoded csv file with encrypted pgp extension file. I am using etext template. Thanks.
-
OTBI Report : Department level DFF issueWe have an OTBI report which pulls the employment level details and department level details of an employee. We would like to pull certain detail of the departments base…
-
How to suppress values in OTBI?I've created an analysis under User System Usage subject area. I'd like to suppress the values like on what I've drawn below: Though I've already configured it to the co…
-
Table for BPM Worklist vacation periodNeed a query for BPM Worklist vacation period Rules. Which table stores the below information.
-
How to connect periods of service with schedule assignmentsSummary: Hello, I am currently trying to report on the work schedule assignments for employees with a past termination date. Would anybody know how to connect the two ta…
-
How to run Oracle Standard Cheque Report of Payroll of HCMSummary: Hello, I wanted to run the oracle seeded report cheque report of payroll module of HCM. But I don't know how to run this report. Thanks Content (please ensure y…
-
Runtime Properties on BI Published Configuration SettingsHello, Recently, the Sever value for parameter "Exclude Line Feed And Carriage Return for LOB" was updated to TRUE which caused some of our interfaces to exclude Line Fe…