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
-
How to create one report that shows users, roles, and privileges on those roles?Summary: I need to create one report that shows all users and assignment info, the security roles on their accounts, and the privileges associated with each role. Does a… -
What is the minimum information necessary to update contractsSummary: Trying to create a data model and report to fix contracts that are missing PERIOD_OF_SERVICE_ID.I can run an SQL query on any of the tables, filter by PER_CONTR…
-
Which SQL Table store the Activity Information of Time Entry in OTL.Summary: If you have BIP SQL handy. Please share Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable… -
query for exit and entry dates of positions occupied by each employe that applied for a requisitionSummary: Hi all , I came across a requirement : to pull the position entry and exit dates in the date range of application submission date of all the persons who applied…
-
Issue with the Custom Data roleHi, We are using a custom role titled "Hub Data Role - Hub Driver Services". Users assigned this role should be able to view all information related to that specfic job …
-
ORA-64203: Destination buffer too small to hold CLOB data after character set conversion.Summary: How to solve ORA-64203: Destination buffer too small to hold CLOB data after character set conversion. Content (please ensure you mask any confidential informat… -
Impact Assessment of Redwood on the Core HR reports and dashboardsHello experts, we are now planning to implement Redwood for Core HR. Can you advise what we should watch out in the Reporting side? Like Changes in the Subject Areas, or…
-
how to remove blank line appearing at the top of manager and worker comments for employee objectivesWe have a custom BIP report for fetching the employee objectives and values details under performance module. The output of the report is in excel and while exporting th…
-
OTBI Report - Need Query Transaction Console Approver Name for Job Requisition & Job OfferSummary: Need Query Transaction Console Approver Name for Job Requisition & Job Offer i have tried this query select htce.object_name, htce.task_id task_id_hdr, htce.con…
-
Is it still available to use the ORA_ASSN_REC_COMPLETE_PENDING - LOOKUP CODE from HR_LOOKUPS table?Summary: Content (please ensure you mask any confidential information): I am working one report and i need to know all sub status for one learner. I used the following q…
-
Run bip reports via payroll flow or ess jobsSummary: We are planning to create BIP reports, which will run in changes only mode. As a best practise should we be running the report leveraging the last run ESS job o…
-
Report on Extract Definitions / Object Name / AttributesHello, I would like to create a report (Bi Publisher or OTBI). About Extract Definitions. I need following information Extract Definition Name Object Name Attributes Exc… -
Line Manager Dashboard Reports for PerformanceSummary: The Delivered Line Manager Dashboard Report has lot of Tabs and For few tabs i am able to find the Analysis Report. For Performance I am able to see the Below D…
-
Recreating Workforce Goals Reports using BI PublisherHello, For a number of reasons we've had to use BI Publisher to build a report on performance Goals and Goal Plan Eligibility. We've tried to use HRG_PERF_GOALS_SECURED_… -
Time spent per approver in workflow approvalsSummary: We have a requirement to report out how long a specific workflow proves (Approve Job Requisition) remained with each approver within the workflow. Is there a re…
-
What is the column for enrollment date in the WLF_LEARNING_ITEMS_F table?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Secured List Views for compensation worksheet displaySummary: HCM table of Secured List Views for compensation worksheet display Content (please ensure you mask any confidential information): Version (include the version y…
-
Sql query or Table to fetch Compensation Worksheet data in BIP report based on securitySummary: Sql query or Table to fetch Compensation Worksheet data in BIP report based on the roles assigned to the user. Content (please ensure you mask any confidential …
-
Dashboard on Development Area: hrr_tmpl_metric_configSummary: Goodmorning, we're fancing a problema with the Talent Review Matrix in the Dashboard Standard The matrix is empty: analyzing the query from the log, we've seen …
-
Getting Duplicate data on performance and goalsGetting Duplicate data on performance and goals when employees checking from Me >> Performance >> Employee is able to view the list of goals of other employees from his …
-
Multiple legal employers records showing in each employeeThere was an error rendering this rich post. -
Can we track Candidates who agree to Terms and Conditions on the Career site?We are trying to find out if it's possible to track candidates who agree to the terms and conditions when applying through our career site. Candidates are given the opti…
-
Cumulative Salary ReportSummary: Financial report of cumulative salaries per reporting period Content (please ensure you mask any confidential information): Hi experts I have a request to provi… -
**SOLVED** How can I get Manager grade step to display in OTBI?I have a requirement to include the grade step of managers in a report I am building however there doesn't appear to be anything available out of the box for this. Does … -
User who executed or modified a report in Publisher ?Summary: Is it possible to know which user executed and/or modified a report in Oracle Analytics (Publisher) ? Content (please ensure you mask any confidential informati… -
course usage reportHello, I would like to create a report to see course usage to potentially achieve trainings that have not been used for a while. Any suggestions on how to create this re…
-
Headcount and salary report with as of date using Workforce Assignment Salary History Real TimeSummary: Objective: To create an analysis with headcount (aka assignment) and salary data. Issue summary: We believe [Compensation - Workforce Assignment Salary History …
-
PER-1530729 POSITION UPDATESummary: ERROR (PER-1530729) POSITION UPDATE The next error that generates the position 203542 when trying to update any of the fields. Also, please indicate that the Pr…
-
Scheduling FTP report - How to schedule multiple reports with one job?Summary: Our purpose is to launch only one job for multiple reports Content (please ensure you mask any confidential information): Hello experts, We have a requirement t… -
Oracle Fusion Table for Deleted Salary RecordGood Day Experts, What salary table to use in order to track deleted salary records within fusion application? Lets say, we have an employee whose yearly salary is like:…