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
-
Common Question: I didn't get any rows in the subject area, what's wrong?Typical Symptoms: you selected columns and didn't see any results, or once you added certain column/s, then you didn't see any results. Content: Q: "I didn't get any row… -
Common Question: How to Ask for HelpSummary: How to ask for help in Reporting and Analytics for HCM Content: 1-Start by naming your subject area. If you don't know that, see: Common Question: In what parti…
-
Common Question: How to Create a Table Style PromptSummary: The attached video shows how you can create a table style prompt. This is useful when you can't have a dashboard, but table prompts don't offer multi-select. Co…
-
Common Question: How to paste or copy an XMLSummaryExplains how to paste an XML ContentOften you may see sample reports in this forum, and this how you copy and paste the XML. 1-select new analysis 2-select a subj…
-
Common Question: How to Edit an Analysis in a DashboardSummary: Explains how to edit an existing analysis in a delivered dashboard. Content: In the relevant section on the xyz properties button, select Edit Analysis. Use Sav…
-
Common Question: In what particular subject area can I find these columns?https://community.oracle.com/customerconnect/discussion/40249/hcm-otbi-subject-areas-to-database-lineage-mapping-spreadsheet Typical Symptoms: you see columns on an appl…
-
OTBI Logical SQL complex query assembler - NOW 10 subject Areashttps://us.v-cdn.net/6034893/uploads/IRBUUHV044EZ/logical-sql-assembler-v5.xlsx Summary Now updated - Combine analyses from up to 10 different subject areas (V4) Content… -
OTBI Workforce Trend: For better performance, use equi-filter on Calendar Month End Date columnSummary: This is an announcement to provide guidance to improve response time of Workforce Trend reports and dashboards. Content (required): 1- Response time of reports … -
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 …
-
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…
-
Numbering Adjustment in RTF TemplatesCustomer have multiple paragraphs in a report built using RTF template which are numbered and some of them have conditions so if the condition is met the paragraph is di…
-
How to Prevent Spacing between unmet conditions?Summary: I am currently in the process of consolidating multiple offer letters into a single document. Within this composite offer letter, I've included several sequenti…
-
BI Publisher - RTF Template - Numbered List in Offer LetterSummary: Hello everyone, I am new to build the BI Publisher, I would like to check a feasibility for my client requirement. My client offer letter has a numbered list e.…
-
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…
-
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… -
HCM Extract Delivery via emailSummary Attempting to send a extract via BI report in emailContent We have an extract setup that uses Bi to deliver the data in a report. In the extract, we are able to …
-
Old value of Seniority Date doesn't appear in the report.Summary: Hi, We are building a BI Publisher report to track changes in different attributes in the system alongside Seniority Dates. So while we perform changes in that …
-
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…
-
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 …
-
User Prompt Results Causing ORA-01795 Error (IN statement 1000 expression max limit)Summary Need solution to get past ORA-01795 error caused by expressions returned from user prompts into an IN statement when selecting AllContent Hello, Appreciate any h…
-
Hide Disable Actions Menu in BI Publisher Report or Hide Export and Schedule buttonSummary: I want to hide Action menu in BI Publisher Report or want to hide Export and Schedule button. Only need online view. Is there any way to do this ? Version (incl…
-
Workers Compensation wage reports neededSummary Looking for recommendations and examples of reports related to Workers CompensationContent Our team that administers our Workers Compensation programs has not fo…
-
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 …
-
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…
-
Participant Feedback Report including feedback from 360 performance - need helpSummary: Hi there, hoping someone could help me out: This report using Subject Area: Workforce Performance - Requested Feedback Real Time does not include the participan…
-
Participant feedback questionnaire reportContent Hi, I am not able to pull a report for participant feedback questionnaire. Can someone help? Regards, Nivya Version 19C -
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…
-
What Oracle IP address(es) should be provided to recipients of reports via SFTP delivery option?Summary: We need to provide IP addresses to an external third party so that they can whitelist them in order to successfully receive BI Publisher reports directly from O… -
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…
-
Where can we get the History of the Position for a report.Summary: I am trying to do a report for Position Details and trying to find the 'History' changes which can be found in the Position "Details" page just below the "Grade…
-
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…
-
Position History ReportingSummary Is it possible to report on changes to positions themselves over a period of timeContent I have a requirement to report on historical changes to positions in OTB…
-
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…
-
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…