Category 81
Discussion List
-
User account data restriction issueSummary: Data Restriction issue. Content (required): Hi Team, Me and my HR using same admin user account. And in my organization we have one of the report called Leave B… -
Calculation Component Reference Values vs. NamesSummary: In Oracle HCM OTBI: Is there a way to add in the from the person calculation card, earnings distribution override screen the name of the component reference as …User_2025-03-07-05-52-31-902 28 views 1 comment 0 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM
-
Calculation Card Reporting - CitySummary: We need a way to report on employees that have a split percentage city tax (part work city & part home city to represent working partially in office vs. remote)…Chelsea Holden 31 views 1 comment 0 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM -
Transfer Dashboard's gear icon to the HCM UIHello, Our client has a requirement, in which he wants the user to have access to the page options (gear icon) of the dashboard in the HCM UI, in the exact same manner i…Ioannis Adamou 18 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Is it possible to create multiple tabbed excel output using BI Publisher delivered layout (.xpt)Summary: Is it possible to create multiple tabbed excel output using BI Publisher delivered layout (.xpt) Content (required): Version (include the version you are using,…
-
Reports - Page options available to the user environment?Hello, I have been asked to find a way to make available the page options of the analytics to the Reports tab. To be more specific, we need the gear icon from the analyt…Ioannis Adamou 57 views 6 comments 1 point Most recent by Ioannis Adamou Reporting and Analytics for HCM
-
OTBI Termination Dates for multiple periods of serviceSummary: Termination report in OTBI is giving the same termination date for two different periods of service. Content (required): My termination report is bringing back …Max W 38 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to get list of roles from systemSummary: Content (required): Hi Expert, We have a requirement to get all the roles we have in the system. So we just wanted to know how to get all the roles. Please sugg…Faizan Rashid 47 views 9 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Average Time of Two PhasesSummary: I'm looking for a way to report on the average time an application is in the Screen and Interview phases (combined and separately), but am having zero luck. Any…Jessica D 68 views 4 comments 0 points Most recent by Poorani Gibson Reporting and Analytics for HCM
-
Newer of two datesSummary: I'm looking for logic that will allow me to pull in two different types of hire dates (new hire date, re-hire date) and return the most recent date. Would I do …Scott Conaway 36 views 2 comments 0 points Most recent by Scott Conaway Reporting and Analytics for HCM
-
Restrict results to appear only after a completion date - LearningSummary: Content (required): Hi there, we have a custom field on the course level that tracks specific credits given by a completion of a course. Let’s say Course A give…Bobby Jourdan 16 views 1 comment 0 points Most recent by Bobby Jourdan Reporting and Analytics for HCM -
Absence calendar in line manager dashboard shows more workers for next monthSummary: the absence calendar in line manager dashboard shows absence for current and next month. I found the next next month does not only present direct reports, but a…Wouter.Schaap 43 views 3 comments 0 points Most recent by Wouter.Schaap Reporting and Analytics for HCM
-
Termination submission/creation dateSummary: I am looking for the date a manager enters a termination. Content (required): After receiving a resignation the manager enters a termination in Oracle. This is …Scott Conaway 189 views 2 comments 0 points Most recent by Scott Conaway Reporting and Analytics for HCM
-
Headcount for last day of previous monthSummary: Headcount for the last day of the previous month. Content (required): I would like to create a report that lists the Headcount for the last day of the previous …
-
OTBI report agent is not sending emails to multiple employeesSummary: Created an OTBI report to pull Work Email of the employees and send a pre-set communication. It works when tested for one/two employees, but it does not send th…
-
Active Employees signed up for Job AlertsSummary: How can we report on internal employees enrolled in Job Alerts? Content (required): We're trying to get a gauge on how many active, internal employees have enro… -
How to add multiple filters in HCM Extract Filter CriteriaSummary: We want to add another filter under HCM Extract Data Group Filter Criteria to filter out terminated employees who has been rehired later from our result set. Co…GauravGupta39 621 views 4 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
how to add a manager email as cc in a bursting report sqlSummary: I have a report which i'm trying to schedule, but i'm stuck at the cc part. i need to add the manager in the cc field. below is my sql, how do get the manager v…
-
Payroll Run Error ReportsSummary: Payroll Run Error Reports Content (required): Hi All, Greetings! What is the best option available to get the payroll run error list - apart from the flow 'Run …Parag Hiremath 16 views 0 comments 0 points Started by Parag Hiremath Reporting and Analytics for HCM -
Can anyone assist with joining two tables in Learning? WLF_EVENT_ASSIGNMENTS_F and WLF_LEARNING_ITEMSummary: I am trying to join the course and the associated initiative information from the two base tables in Learning. Content (required): Joining the learning_item_num…Thulasi Ram 114 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Subject Area Access for Compensation - Salary Details Real TimeSummary: I have given an employee the two roles below ORA_CMP_COMPENSATION_ANALYST_JOB ORA_CMP_COMPENSATION_MANAGER_JOB This gives the employee access to Compensation - …Mark Stoker 77 views 5 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
FND_SESSIONS recording delay?Summary: Is there a delay in the data recording for FND_SESSIONS Content (required): We created a report to get the user count of accesses, using FND_SESSIONS. We ran it…User_2025-02-12-18-16-11-815 34 views 2 comments 0 points Most recent by User_2025-02-12-18-16-11-815 Reporting and Analytics for HCM -
Wage Basis Rules Configuration ReportSummary: I have been tasked with creating a report for the Wage Basis Rules so that we can confirm the setup when an element is added to the system Is there a subject ar…User_2025-02-04-08-51-08-912 53 views 3 comments 1 point Most recent by Eric Geddes Reporting and Analytics for HCM
-
Oracle HCM Cloud: Where can I see the seeded Packages for BIP?Summary: Does Oracle have a list of DB packages that we can use for BIP? I saw this one "pay_balance_view_pkg" but I wanted to know if Oracle have a full list of package…
-
when i ran My Bi reports I'm getting error is ORA-01427: single-row subquery returns more than oneSummary: Hi Team, when i run my report some countries coming data and some of times als coming the data but some times I'm getting below errror: ORA-01427: single-row su…AjayKumar Maddipati 714 views 13 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
ODBC Error - ADFService11g on OTBI AnalysisSummary: After 22B went into our Test environment, a report built on a few subject areas no longer works. It is giving us the following error: State: HY000. Code: 77031.…
-
OTBI Agent - Italic in narrative textSummary: Content (required): Hi, I'm creating an agent to send automatic emails: is it possible to insert some italic text? In case, could you please tell me how? Thank …Alberto Americi 16 views 4 comments 0 points Most recent by Alberto Americi Reporting and Analytics for HCM
-
Restricting report access to read only using Application RoleHi, In HCM (Reports and Analytics), We are trying to restrict reports access to read only for particular users using Application role. For that created a new role assign…
-
Custom Data Model - ProfileApprovalNotificationSummary: How to custom the seeded data model in order to add flexfields Content (required): Hi, I need to add flexfields from one Profiles section (Honor and Awards) in …Alice Gouzy 147 views 3 comments 2 points Most recent by Alice Gouzy Reporting and Analytics for HCM