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 any seeded OTBI Analysis for Person Seniority?I'd like to know if there's any seeded OTBI Analysis which can relate to Person Seniority? -
Report related detailsSummary: Hello, We want to know details for the one of the BI report, how we can find below details, do we have any Query to check all details for the BI report. Report … -
Inbound Integration HCM Extract - Zero RecordsSummary: Hi All, I face a unique scenario where my HCM Extract may not always generate HDL Data records to be loaded to HCM Data Loader. Due to this, a blank .zip file g…
-
BI Report job success but email not deliveredHi, We have come across an issue with one of our bursting reports wherein the Report job is showing as Success, but the email is not being delivered. Can someone help wi… -
how to attach a static pdf from webcenter as attachment into our emailWe want to send a Email with a static pdf file as attachment to employees. So we are using the RTF template as the Email body and. And we have to attach the PDF file as … -
Reports return SQL error since applying security profileHi there, Since doing a restructuring of the business, we applied a person security profile to one of the HR roles so that they could only search for and work with peopl…
-
Track approval workflow status for goal managementSummary: Track approval workflow status for goal management Content (please ensure you mask any confidential information): Hello experts, we have enabled an approval wor…
-
does the system keep track of changes made by the manager on the employee's goal plan?Summary: Is there any way to track the historical data of an employee's goal plan? when the manager makes changes to the employee's goal plan (e.g., in the mid-year time…
-
Is there a table or a view holding "Previous Comments" or "Approval History" related to unapprovedSummary: In order to check a detailed approval status of Goals before approval, I'd like to extract data such as "Previous Comments" or "Approval History" . I'd like to …
-
How to track the number of requested feedback via BI PublisherSummary: How to track the number of requested feedback via BI Publisher Content (please ensure you mask any confidential information): Hi, we would like to generate a re…
-
Select data which are displayed on the All-In-One EvaluationSummary: As per customer's request, I'd like to make a BI report that selects the data displayed on the All-In-One Evaluation. Content (please ensure you mask any confid…
-
Where to find historical data in BICC PVO'sSummary: Need to pull historical person info from PVO's in BICC Content (please ensure you mask any confidential information): Our business has set up an integration bet…
-
BI Publisher Handle No Data in RTF TemplateHello, I want to prepare a report that returns data that I call from the web service via OTBI. However, when I try to return this value in BI Publisher rtf template, the…
-
Deploy Reporting components from Bitbucket/Git to Oracle HCM and vice versaSummary: Deploy Reporting components from Bitbucket/Git to Oracle HCM and vice versa Content (please ensure you mask any confidential information): Currently the reporti… -
Limitation on XDO Tags in BI Publisher Excel TemplatesSummary: The number of XDO tags within our BI Publisher Excel template has exceeded 1000. We are unable to generate additional tags, which is hindering our template desi…
-
OTBI - Reverse geocode time events via sqlSummary: Hello, Is there an sql package available for cloud customer regarding reverse geocoding?. Content (please ensure you mask any confidential information): We are …
-
dashboard parameter resetHello, I prepared a dashboard from a web service data model and this dashboard works with certain parameters. Dashboard consists of two tabs in total. When I select the …
-
BIP Report Status DashboardSummary: BIP Report Status Dashboard Content (please ensure you mask any confidential information): Hi Team, Greetings! As you know -we submit/schedule multiple flows wh… -
Reporting on paper payslip flag from People GroupSummary: We require a report that gives me people who have a paper payslip flag ticket in People Group segments. This is to ensure employees out of business get their pa…
-
Security to Compensation ModuleContent Hi all - we have created a report that pulls compensation module details through BIP. We are using secure views, but when I sign in as the line manager to view t… -
Bypass self-evaluation reporting in Performance ManagementSummary: Bypass self-evaluation reporting in Performance Management Content (please ensure you mask any confidential information): Hi Team, Greetings! We are looking for…
-
query to get deactivation date of userSummary: query to get deactivation date of user Content (required): May I know if any one know how to get deactivation date of user, I tried using end_date from per_user…
-
Configure queries resolvers based on employees branchSummary: We have special setup in the system where we want to minimise data visible to many users; We have employees whose first line of support should be Scheduler (our…
-
I need a subquery that returns whether the manager filled out an assessment of the employees' goalsI need a subquery that returns whether the manager filled out an assessment of the employees' goals - from which tables can this be retrieved? In Oracle HCM Explanation …
-
Profile strength report for checking Talent profile completion status reportingProfile strength report for checking Talent profile completion status for the Organisation reporting? I am not able to find the field for profile strength in OTBI or BI
-
How many reports are there in systemSummary: can we create a report with the followed fields Report Name, Folder or path where, creator, who has access/visibility to it Content (please ensure you mask any …
-
How to report on Recruiting Organization Description assigned in Job FormattingSummary: I am looking for the table / views that will pull in the Job Footer details assigned in the Recruiting Organization Description section in Job Formatting. Conte… -
Duplicate Data Rows for EFF fields in Reporting (Data Issue?)Summary: Hello, We are noticing when we are building basic reports whenever we bring in Job or Department EFF fields in the criteria, we get duplicate rows for employees… -
need query to get activities content type for all the courses along with offeringsHi we have requirement to get the Course names along with the offerings and their activites content type in the bi report. Can any one share me the sql for fetching all …
-
What Application version did OTBI change the Default output from Worker.Assignment NameSummary: We have noticed that within OTBI there has been a change to the default output from Worker.Assignment Name to Business Title. Could someone tell me when this ch…