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 can we get "Starting Date in current Job" and "Starting Date in current Grade" in BI analysisContent I have a requirement to get the details in BI analysis that what is the start date in current grade and job.May be this date can be assignment start date when em… -
Help with Case When statementWe need to derive a Vacation Tier based on either the Assignment, Job, or Years of Service for an employee. It needs to first look at the Vacation Tier field on the Assi… -
Unable to pull Action Reason from Job OffersSummary: After enabling Action Reason on Job Offers based on 26A feature, we are able to view Action Reason on offers. We need to access this Action Reason in Fast Formu…
-
Career Site | Reporting on Candidate Consent and Behavioral Data for Non-Essential CookiesHi team! We are currently implementing ORC for a client and we are working on the configuration of the career site cookie consent management. Non-essential cookies on th… -
pages that are *not* in RedwoodSummary: A user reports seeing pages in NUX rather than Redwood, even though all the learning pages have been migrated to Redwood. How can the learner access the pages t…
-
Query to get the user login time for last 365 days in fusion HCM ApplicationSummary: we are trying to find out the login timings of a Common user, we use this user for scheduling purposes, need a query to fetch the login timings of this user. Co…
-
ORA_ELEARNING type: course or offer?Summary: Content (please ensure you mask any confidential information): I create a course and an offer, both of type ORA_ELEARNING. How to tell if these 2 learning items… -
Option to request overtime in OTL Oracle time and laborSummary: Do we have functionality in OTL Oracle time and labor to request overtime from standard OTL solution. or we can do it using DoR custom solution. Content (please…
-
Unable to configure scheduler profile in OTLSummary: Can any one share implementation guide or steps for configuration of scheduler profile in OTL Content (please ensure you mask any confidential information): Ver…
-
How to add multiple users as Recipients in OTBI AgentProblem: When user performs setup of OTBI Agent, then while adding other user under Recipients tab, system throws this error: Analysis: Access to OTBI agent is provided … -
Performance Participant Request CommentSummary: Content (please ensure you mask any confidential information): During performance evaluation process the manager can add a participant in order to have another …
-
Dynamic Signature Management in BI Publisher PDF Output Not Rendering via UCM/DOR Urgent RequirementSummary: Dynamic Signature Management in BI Publisher PDF Output Not Rendering via UCM/DOR Urgent Requirement Content (please ensure you mask any confidential informatio…
-
Dynamic Signature Management in PDF Job Letter ReportSummary: Need Oracle-recommended approach to dynamically maintain and update signatures in a BI Publisher PDF Job Letter report without modifying the report template whe…
-
OTBI Folder DisappearanceSummary: Is anyone experiencing folders disappearing in the catalog? I pulled a report to see what happened to the folder, and there is no record of it being moved or de…
-
HCM module OTBI / SQL report on employee informationSummary: SQL / OTBI report related to LE / BU / Employee first name & Last name / Person number/ Person ID/ Person type /contact with email / Department / User name if t…
-
BIP report: Profile ID not populated on candidates TableSummary: There is a profile ID on IRC_Candidates that the description says is he foreign key to HRT_PROFILES_B, but it appears to be null for newer candidates. https://d…
-
Oracle Recruiting Offer Dashboard ReportingSummary: Oracle Recruiting Offer Dashboard Reporting Content (please ensure you mask any confidential information): Hi All, Greetings! Hope you are doing well. This requ… -
Consolidated Offer Report and DashboardSummary: Consolidated Offer Report and Dashboard Content (please ensure you mask any confidential information): Hi All, Greetings! Hope you are doing well! We are lookin…
-
Reporting the candidate offer transaction approval attachmentsSummary: Reporting the candidate offer transaction approval attachments Content (please ensure you mask any confidential information): Hi All, Greetings! This is about t…
-
Ability to disable all the custom OTBI schedule reportsDo we have a process in place to inactivate all OTBI scheduled reports (agents)? We have a business requirement to inactivate all scheduled reports for a certain period …
-
HcmTopModelAnalyticsGlobalAM.PersonAM.GlobalPersonPVO does not show some person recordsSummary: HcmTopModelAnalyticsGlobalAM.PersonAM.GlobalPersonPVO and HcmTopModelAnalyticsGlobalAM.PersonAM.PersonDetailsPVO does not show some records though they are avai…
-
Role/privilege is required to retrieve Position Code from OTBI "Position Real Time" in BI Publisher?Summary: Hello Experts, I am trying to retrieve Position information from OTBI subject area Workforce Management - Position Real Time through a BI Publisher Data Model. …
-
Which HCM Extract DBI to use to fetch full state name (region2) from person address?Summary: Extract_address_region2 and address_region are giving only short forms of state. Is there any other way? Content (please ensure you mask any confidential inform…
-
Is it possible / How to create BIP report output in .xlsx format?Is it possible / How to create BIP report output in .xlsx format? Currently we can only see .xls option while creating the template. Please advise.
-
BI SQL FILTERWhen I search for a code in a filter, it correctly returns two values—as shown in the query below—but when I select both, only one code appears in the list of selected v…
-
What is the field name of checklist status?Summary: Content (please ensure you mask any confidential information): Unfortunately it is not per_allocated_checklists_vl.CHECKLIST_STATUS, any other idea? Version (in…
-
Not able to return Questionnaire information from Performance Subject AreaSummary: I have created a new performance document but am unable to have any data returned from the workforce performance - performance rating real time subject area. Co… -
HCM Extract PGP encryption appends .txt extension — supported workaround?Summary: We are generating an HCM Extract file and applying PGP encryption for SFTP delivery. The file is encrypted successfully, but the resulting filename includes an …
-
Query to get attachment URLSummary: I have uploaded the attachment under Skill and Qualifications —> Licenses and Certifications. Need query to get attachment details related license and certifica…
-
Dashboards that shares the health status of integration batches, scheduled loopbacks, notificationsSummary: Dashboards that shares the health status of integration batches, scheduled loopbacks, notifications Content (please ensure you mask any confidential information…