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
-
-
Case when statements to evaluate values based on a groupSummary: Content (please ensure you mask any confidential information): I am working on an OTBI report based on the Workforce Management - Checklist Real Time subject ar… -
Duplicate element entry report with entry detailsSummary: I have a requirement where I need to report on more than one element entry for a person where the input values differ. Attached is the OTBI analysis details on …
-
How To Embed OTBI Report To Responsive UI (Performance)Content Requirement ============ Manager able to see OTBI absence report using me -> career performance page -> Performance-> Employee Performance Document (Specific Emp… -
Filter Inactive Requisitions in ReportsSummary: Inactive requisitions can be filtered on application by selecting the check box filter. What is the corresponding column (OTBI or BIP) which can help to filter …
-
OTBI Hourly Rate calculation for employees on monthly pay cycleSummary: I am modifying an existing report on employee's salary. The organization has bi-weekly and monthly pay cycles. When calculating the hourly rate some monthly emp…
-
-
Rating data is displayed in different rowsSummary: For the Perfomance Document Section I want to have two cases illustrated in two different columns: I wrote a Case-statement that if Perfomance Document Section …
-
Need a Sample SQL to fetch Benefits Enrollment Data using a Batch Name from HSDLSummary: I have loaded the Benefits Enrollment using HSDL where we provide Batch Name. My requirement is that using the Batch Name as a parameter, I need to fetch the lo… -
How To Add A New Column With Custom Date FieldSummary: I have an OTBI report where I need to add a column (see expected date column below) that when there is a Termination Date it shows the Termination Date BUT when…
-
Details of employees who are having the access of respective modules.Hi Everyone, For audit reason We have received an requirement where our need to is to get details of employees who all are having an access for respective modules and al…Jebarsan Thangam John Durai Raj 11 views 0 comments 0 points Started by Jebarsan Thangam John Durai Raj
-
how to create Dynamic Parameter in Logical SQL in OTBISuppose a field/column- Effective Date of Balance in Payroll should be between two dynamic parameters such as Start date and end date. Start Date and End date will be as…
-
Where to find HR Compliance and HR Operational ReportsWe recently went through an Oracle implementation, and was wondering where can I find HR compliance and HR operational reports. Our Implementation partner mentioned that… -
Report to fetch the user logs in the system.Summary: Hello We have come across a requirement where we need to understand if there are any standard pages/reports through which, we can fetch: The logs of all the use… -
Query to get the list of roles in applicationSummary Query to get the list of roles in applicationContent Hi Experts, Is there any seeded query or custom query available to pull the list of all seeded and custom ro…
-
Download a Spreadsheet that has a link to attachment in the Journey RecordSummary: Our company is looking for a quick way to audit the attachments that have been uploaded into Journey's Content (required): “Is there a way to download a spreads… -
Payslip Template ChangesHi all, I'm hoping someone can help me here. Our payslip is a customised version of the seeded one provided by Oracle that currently has every page in landscape. We'd li…
-
Time Zone in OTBI is not in sync with timezone set in user preferencesSummary: Time zone in OTBI/BI Publisher is not in sync with the time zone set in user preferences 1) How to find out all the users who have this mismatch? 2) How to sync…
-
auditing for document of records viewwe have a requirement to get auditing report for who are viewing the document of records. we are trying to get it from OTBI but data is not coming from those columns. ca… -
Subject area or tables we can find the status history in its different phases of a candidate.Hello. In which subject area or in which tables we can find the status history in its different phases of a candidate who has not been hired as an employee. Thanks and r…
-
Comparing current Job Titles to previous week Job Titles in OTBISummary: Hi, I've been tasked to compare current Job Titles to Job Titles in the previous week. Can anyone assist in explaining how this can be done via an OTBI reports …
-
OTBI Comparison between two tables with the same fields in one tableHello! I would need some help with this idea of an analysis. The idea would be to make a comparison in a single table of two different tables with the same fields. Somet…
-
Legal Disclaimer check box field under the External Career Site cannot be obtained from the reportThe Legal Disclaimer or Privacy Statement column under the Recruiting Career Site cannot be obtained from the BIP and OTBI report. We would like to ask for your help bec…
-
Query For External Record Learning Experience(Non Catalog Learning)Summary: I am unable to find below two fields to fetch a data from 'Record External Learning Experience' screen. Field1: URL Field2: Start Date (Under Completion Detail)…
-
Absence calendar inc work patternSummary: Is it possible to report on work patterns/worker availability in OTBI Content (please ensure you mask any confidential information): Hello With the ability for …
-
How to schedule an OTBI report using agent if the report has two dates as prompt?Summary When we schedule this OTBI report with agent, it pulls all data which are not in the range of default valuesContent We have an OTBI report which has "from date" …
-
Does an Agent(OTBI) continue to run even though the user who set it up is inactive?Summary: Is there any way to find out the agents created by a user(Inactive now) in "MY Folder"? Also does an Agent continue to run even though the user who set it up is…
-
Headcount and Termination # for Turnover and ESG reportHi there, We are looking for the columns in subject area to display precise headcount and termination number for Turnover and ESG reports. Below are other numbers which …
-
BI Publisher : I need to create a report to track the changes on employement for my employeesSummary: I need to create a report to track the changes on employement for my employees with situation before the action and action reason and the situation after the ac… -