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
-
Is there a way to give Delegations for Reporting?Summary: We would like a manager to allow an employee to pull reports for her direct reports We tried Role delegation and Approval Delegations but none of them help with… -
Learning Calendar reportSummary: Hi Folks, Learning calendar view is blank and does not have the calendar view Please help to fix this All other reports for learning calendar title and learning… -
Error opening journey reportHi experts, When I try to open the journey report, this error appears. It happens every now and then, not all the time. Is there a way to solve this problem? Thank you, … -
OTI Query for Fetching Free Text Fields from QuestionnaireDear Community, I am working on an OTBI report and need some help with querying data from a questionnaire called "Student Touchbase". The Questionnaire consists of sever… -
BI Report: usage of fnd_sessions table first_connect and last_connect to track login time of usersSummary BI Report: usage of fnd_sessions table first_connect and last_connect to track login time of usersContent Hi, We have a BI report developed to track the login ti… -
https://community.oracle.com/customerconnectHow can I get employee's dependent detail and emergency contact number in OTBI report
-
we have given the row num in select statemnt but we need row count also ?Summary: Hi we have given the row num in select statemnt but we need row count also ? need row count=2 ? Content (please ensure you mask any confidential information): V… -
Ethnicity Formula broken in report after 24A updateSummary: We have a report that has been in use without issue for a few years. In this report, we are getting a general active headcount of employees and contractors with…
-
Level 02 Organization Name are not generating in the HR Help Desk ReportsThere is a requirement to include the Level 02 Organization Name in the Help Desk Report. However, after adding the columns 'Level 02 Organization Name' and the suitable…
-
OTBI - what is Worker Creation DateIn OTBI, when looking at the subject areas in the analysis reports, what does the following mean: Subject area: Workforce Management - Worker Assignment Real Time Folder…
-
OTBI agents and P2THello! We are setting up our first OTBI agent to send out daily notifications and wondering what will happen to the agent in test environments. Will it be automatically … -
We have ORC Offers Transactions Report but need to add country column for below query ?Summary: Hi Team, We have ORC Offers Transactions Report but need to add country column for ? Content (please ensure you mask any confidential information): select a.OBJ…
-
Worker Assignment Event history - job title / position title as of assignment effective dateSummary: When we are running OTBI analyses with the Worker Assignment Event subject area, we need to be able to see what the associated position name/ job code names are… -
How to use AOR subject area to show active AOR's for inactive assignments?Summary: Trying to get a list of inactive assignments with active AOR Content (please ensure you mask any confidential information): I'm trying to use the subject area "… -
Hide seeded HCM cloud OTBI Dashboards from Dashboard MenuSummary: Business does not want to see HCM cloud product seeded OTBI Dashboards from Dashboard Menu Content (please ensure you mask any confidential information): Versio…
-
How to see scheduled processes submitted by others?Summary: How to see scheduled processes submitted by others? Content (please ensure you mask any confidential information): If I (admin) submit a process my colleagues (… -
Report Error- Oracle HCM BIP ReportSummary: Error populates for a HR Admin user with data security that excludes specific HR depts. The report parameters page does not load for these types of users. This … -
Identify Headcount and FTE by Dept and Job AND Display Number of Open Requisitions by Dept and JobSummary: Requirement is a report showing active headcount and FTE by Dept by Job AND # of open job requisitions (Filled Date is null) AND # open FTE. Is this possible? Y…
-
Extracting Requisitions from Career SitesSummary: Hello Guys, We would like to create an analysis or a data model that allows us to extract all requisitions posted on various career sites. Currently, we are enc…
-
Report/Dashboard about Performance ModuleContent Hi Guys, Does someone know where could we find Performance Reports or Dashboards standard? I hope in your answer, Best Regards, Giuseppe
-
Hire Report - Two subject area report erroring with two measuresSummary: Hello, we are building a hire report using the Workforce Management - Worker Assignment Event subject area and we only need one field from the Workforce Managem… -
Which table stores the below candidate profile email options.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…
-
How do I query Estimated Time To Hire from ORC using BI Publisher?Summary: I need to query data on Estimated Time To Hire for existing requisitions. Any information is greatly appreciated. Content (please ensure you mask any confidenti…
-
Sql query or Table for Worksheet Display and Default Worksheet Display assigned to compensation planHi team, Sql query or Table where the information stored for Worksheet Display and Default Worksheet Display assigned to workforce compensation plan in HCM compensation …
-
Count Distinct by Two AttributesSummary I am not able to get distinct count by management level and genderContent Hello - I'm creating a simple analysis to count the number of employees by a grouped ma… -
Sql query or Table name for Workforce Compensation plan cycles assigned to planHi team, We are unable to find the table where the "Plan cycles" information stored for HCM compensation module. Could you please provide us the table or sql query to ge…
-
How to translate BIP Report Parameter TitleSummary: We have a requirement to translate the report parameter label. We couldn't get any link from Community or MOS to check the translation. We would require your su…
-
External Provider learningSummary: External Provider learning Content (please ensure you mask any confidential information): Hello experts, we would like to create a BIP report with the details o… -
We need termination reson column but how to link with any table ?Summary: We need termination reson column but how to link with any table ? PER_ACTION_REASONS_TL Thankss, Ajay Content (please ensure you mask any confidential informati…
-
Unable to map missing columnSummary: Our team is redesigning an OTBI report and is facing an issue with mapping the column from the old subject area "Workforce Learning - Learning Management Real T…