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
-
Employment contracts - Audit missing action code fieldSummary: Hi experts, we are trying to add the field "Action code" as selected attribute in the audit for the Worker Employment Contract business object but it seems it i… -
Which table stores the Action Reason for salary?Summary: It doesn't seem the per_all_assignments_m but some other pay_* table, any idea? Content (please ensure you mask any confidential information): Version (include … -
BI Publisher eText (Fixed Position) Number formatting issue.Summary: Hi everyone, I’m working on a BI Publisher eText template (fixed-position layout). I have a column that must display an amount as a 13‑character, left‑padded nu… -
Extract instances of overrides in time cardsHi all, I would like to extract or get the number of overrides per timecard of an employee. The new Redwood layout for time cards is so confusing to me, in this example … -
Transaction Console - Old Pending Transactions that should be ExpiredSummary: It was recently discovered that there are multiple pending transactions from 2022-2024 in Transaction Console that should have expired (screenshot attached). I …
-
Employee is not available in Responsive UI but can access only via Person ManagementSummary: ADT | EE#321204 not exist in Employment info & Seniority Date pages, but available in Classic UI, we can able to access the employee in Classic UI (From Person …
-
How to customize "No Data Found" message in BI Publisher Interactive ReportsSummary: Customize the message "No data Found" in BIP Reports (Interactive Layout) Content (please ensure you mask any confidential information): Hello experts, I am loo…
-
Which tables are used to link the Goal Plan Assignment ID with archived transactions?Summary: Could you please specify which database tables store the Goal Plan Assignment ID? Additionally, which tables are used to establish the relationship between the …
-
Process Imported Shifts log file SQL queryHi Team, We are using the REST API to load shift data and running the Process Imported Shifts job to process the imported records. We would like to understand which data…
-
OTBI To fetch the Requisition NumbersSummary: I have a requirement to fetch the Recruitment Number & Recruiter Full Name . The Subject Areas used ( Individually) 1. Recruiting - Recruiting Real Time 2. Recr… -
Customize the Organization Chart ReportSummary: Hi All, Can you please helps us with any Sample BI or OTBI Report for Employee Organization Chart Content (please ensure you mask any confidential information):…
-
I want to check any report available which give the Org Chart data.Summary: We have requirement to fetch the Org Chart data from BI report. So is there any report available which give this data. Navigation : Me → Connection → Search Emp…
-
Need Guidance on Mapping Employee Numbers in OTBI Expense-to-Payables ReportingSummary: We have developed an OTBI report using the Payables subject area to retrieve invoices imported from Expenses and to track the payment status of those expense-re…
-
Department Hierarchy data in the "Workforce Learning - Learning Records Real Time" subject areaSummary: we are combining the "Workforce Learning - Learning Records Real Time" and "Workforce Management - Worker Assignment Real Time" subject area's to get the count …
-
Accrual Plan Balance value for the future dateSummary: We are trying to fetch the accrual Plan Balance value for the future date records. Content (please ensure you mask any confidential information): As of now, we …
-
Learning records - courses without any enrollmentsSummary: I have just found out that the learning management real time subject area will be deprecated so we need to rebuild our report using the learning records subject…
-
Proposed User and System Person Types in the Recruiting Real Time Subject AreaSummary: I'm building a custom version of the delivered Recruit to Hire dashboard. For the prompts, I want to be able to pull in the proposed User Person Type and System…
-
Report requirement- Employee name, Employee ID, Job name, Assignment ID & Assignment start dateSummary: Our client is looking for a report to fetch the columns- Employee name, Employee ID, Job name, Assignment ID & Assignment start date Which seeded report matches…
-
Output Manager Hierarchy in OTBI with a column for job title following each Parent Manager nameSummary: Output Manager Hierarchy in OTBI with a column for job title following each Parent Manager name Content (please ensure you mask any confidential information): H…
-
I'm trying to write a SQL that will show SIT withheld by stateSummary: I'm trying to write a SQL that will show SIT withheld by state so I can find out which legislative updates will affect our employees. Content (please ensure you…
-
Individual compensation plan -Hide salary advance amount value on workflow notificationSummary: We have "Salary Advance" ICP plan under manage personal contribution and business is asking to hide salary advance amount value on workflow notification for all…
-
Is metric tracking available for AI agents similar to AI Digital Assistant?Is there any available metric tracking for the AI agents we are putting on our pages that are replacing the AI Digital Assistant? Currently we are utilizing the analytic…
-
Formatting BI Publisher chart axis labels to display integers onlySummary: I am working on a complex report in BI Publisher that is based on uploading an RTF file, and in this chart I need to display only integer numbers on the X-axis.…
-
“Connection is either null or invalid” Error Only for HR Specialist (Custom Role)Summary: We have a BI Publisher report in the Custom folder. When I run the report using my implementation user, it works correctly and generates output. But when we log…
-
Is it possible to save my preferred filter within the dashboard?Users cannot save or retain their own personal filters in the reports or dashboards. I understand that we can only configure default report filters/parameters - this fea… -
Query to fetch departments with cost centre and cost centre managersSummary: Hi, i need a query with departments assigned to cost centre and cost centre managers. Please help Content (please ensure you mask any confidential information):…
-
How to Hide/Show Analysis in Dashboard Based on a Parameter ValueHello everyone, I’m working on an OTBI dashboard and need some guidance. The dashboard contains multiple analyses, and I would like one specific analysis to display only… -
Activity Report IssueHi, im working with a issue in my Activity report, that need course and offering info, the problem rise because of a excel course that they use the same activity for all… -
Display Department Title on all levels of Department Hierarchy OTBISummary: Need to pull a report of all levels of our Functional Department Hierarchy with Department level 1,2,3,4 Name, and Associated Department Title. Content (please …
-
SQL to fetch learning catalog profileSummary: In which database table(s) can I find the learning catalog profile ID and learning catalog profile number Content : Background information: In version 25D Oracl…