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
-
Can we filter data using values from two columns?Summary: To obtain the data using values from two different columns. Content (please ensure you mask any confidential information): I am working with Workforce Managemen… -
How can we convert CLOB datatype to string in OTBI Reports?Hello, We are trying to remove HTML tags from a CLOB datatype column in OTBI report by using Substring and Replace function in the analysis. This is resulting us to get … -
Organization tree OTBISummary: We have an Organization Tree in Fusion HCM where: LE = Top Parent Node Division = Child Node under LE Departments = Child Nodes under that Division LE-->Divisio…
-
How to get shift name start time, end time for certain date, from the work schedule caledarSummary: In oracle Fusion, We need a query to identify the shift name , shift start time and shift end time as the following parameters shall be passed Emp number Date C… -
Can we report on the number of job requisitions raised by "use" type (template, position etc)Summary: We are looking to establish the behaviour of users and which way they raise job requisitions in Oracle Recruiting. Is it possible to report on how many requisit… -
Oracle FDI – HCM securityHello Everyone, We have a requirement to restrict all access to C-Level executive data (e.g., CEO, CFO, CHRO, etc.) within Oracle Fusion HCM FDI Analytics. This restrict… -
How to display report parameters on the OTBI report output.How to display report parameters on the OTBI report output.
-
OTBI Report with SQL query filterSummary: Hi Team, We have a custom reporting requirement that involves applying complex, SQL-based filters. We are planning to implement this logic within an OTBI report…
-
Are there any seeded alerts for HR Help desk ?Summary: Hello Experts, We are looking to implement HR Help Desk for a client. However I am a little puzzled regarding the notifications capabilities of this module. Is …
-
BI Author user should have Read only access to Specific folder in Fusion BI CatalogSummary: Hi Team, We have a requirement where the user with BI Author access should have read only access on Specific folder in BI Catalog,Please let me know if you have…
-
Need to Extract Termination Transaction Approval DetailsSummary: Need to Extract Termination Transaction Approval Details Content (please ensure you mask any confidential information): Hello Experts, We have a requirement to … -
OTBI Analysis Report – Duplicate Rows Issue Even After Enabling DISTINCTSummary: I am working on an OTBI analysis where I am seeing duplicate rows in the output. For example, the same Person Number and Person Name (e.g., "101 – Ben") is repe…
-
Want to fetch row values based on another column's value.I want to print mid salary values which are highlighted in screenshot, based on columns "overtime" and "grade rate name".
-
SQL query for Time Entries with Payroll result for the selected periodHi All, I have a requirement to fetch the columns as attached in the excel screenshot. The challenge i'm facing is i'm not aware how to join the Time Entries with Payrol…
-
Where is the submission date stored on the team time cards?Summary: I'm writing a query to check for time that hasn't been transferred to payroll and I would like to include the submission date field. Which table contains this f…
-
HCM OTBI- How do I run report to see any positions with an entry in the 'Funding Source'?Summary: Need run a report to see if there are any positions with an entry in the 'Funding Source' field however I'm unable to find the field in any HCM Subject Areas. C…
-
Number of workflow Notification Emails sent from HCMSummary: Looking for number of emails sent from HCM through workflow notifications by Module identifier. For Example - Number of emails triggered by personal information…
-
SQL Query to get balance value for a balanceSummary: Hi Team, I am looking for a SQL query to get balance value for a balance as of effective date. For example:- I need to get balance value as of 16th June 2025. F… -
Deeplink for line mamager to see direct reportee performance document.Summary: Hi Team, @Naga M -Oracle , I see below deep link will redirect to particular document in redwood version for line manager only when he is a document manager. 'h… -
HCM Approvals report secured by locationSummary: I have a requirement to create a report or analysis of approvals and their statuses, but it must also consider the employee’s location. The report should only d… -
Access to customize reports in Publisher greyed outHi all, Hoping someone could assist with an issue regarding access to customize reports in Publisher. The user has BI Author and BI Admin. The folder permissions for the… -
NETWORKDAYS Logic In BI ReportHi , As a Business requirement we want to get the Working days between 2 days. I tried to get this using below query. But getting 0 as output. (select count(*) from tabl…
-
OTBI Report shows wrong annualized salary and annualized full-time salaryOTBI Report shows wrong annualized salary and annualized full-time salary Navigation Tools Reports and Analytics Catalog Created OTBI report based on "Compensation - Sal…
-
Is there any way to get back the archived transactions related workflow transactionsSummary: I want to get the information on archived transactions details. Content (please ensure you mask any confidential information): Recently we have click on archive…
-
Generate Employment Letter from Employee Self ServiceSummary: Hello Experts, We have a requirement to develop the Employment Letter from the system from the employee self service. We have checked in the delivered Document …
-
Sample report (preferably OTBI) of candidates that have applied using multiple emailsSummary: Does anyone have a report (preferably OTBI) of candidates that have applied using that one email. In essence, same candidate name and address applying with mult… -
Restore saved OTBI analyses after user name changeHi guys, One of the HR Users of the customer married last weekend. So her name changed, as well as her username changed. On the old user name she stored some analyses in… -
Issue is when we add termination date in two subject areas OTBI reportSummary: Hi Team, when we add the two subject areas it showing correctly but when i adding termination date it showing two rows as below ? one is with termination record… -
Not able to view seeded template at the seeded path after customising the reportI have customized the seeded template for the US Payslip report and it is present at the custom path:/shared/Custom/Human Capital Management/Payroll/Payment Distribution…
-
Request for SQL/OTBI to Extract Scheduled Process Parameters (ESS)Details: We are looking for a way to extract Scheduled Process details (ESS), specifically the following information that is visible in the UI for processes such as Calc…