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
-
BI Publisher Report SQL Error : SQL or ORA exceptions caused due to invalide sql , database packageSummary: I've created a headcount report that combine all workforce informations based on per_all assignments, compensation data based on cmp_salary_v cmp_salary_v2... i… -
How to wrap text in BIP report with excel outputSummary: Is there a possible way to wrap the text in BIP report? In the current setup, the description in the field is too long to fit within the cell, making it difficu… -
We are trying to pull notes and audit data using Compensation - workforce compensation real timeSummary: We are trying to pull notes and audit data using Compensation - workforce compensation real time. Pulling anything from Notes in the data source immediate bombs…
-
Query to fetch overall rating from Performance documentSummary: Hi All, Can you help me in sql query to fetch overall rating from the performance document? TIA Version (include the version you are using, if applicable): Code…
-
OTBI Analysis - No results using subject area "Workforce Management - Worker Assignment Real Time"Summary: No results when creating simple analysis in OTBI using the subject area "Workforce Management - Worker Assignment Real Time" Content (required): Hello, I tried …
-
HCMAIAgentBy enabling the Enhanced Representative Agent and Personal Information Assistant AI Agent in HCM would their be additional License cost for the customer. If yes which SK…
-
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…
-
Can attachment content be copied on BIP Report outputSummary: Can attachment content be copied on BIP Report output Content (please ensure you mask any confidential information): Hi All, Greetings! We have a requirement ab… -
Update blue on blue colouring for BIP list of values in menu based promptsSummary: In BIP when we select values in a prompt where options are derived from an SQL query, we see a selection window where the selection shows in a shade of blue, bu…
-
Sql Table to get the details of BIP Data model QueryContent Hi, Is there any database tables available to fetch the details(Query) used in a BIP Report. We would like to see the list of reports using a particular field sa… -
BIP Report returning two rowsSummary: We have a sql statement that returns 1 row, but bip is putting it in excel in two rows. Notes on the bottom, all the other ones spanned across both rows. Also w…
-
Which table has the information for Rule Builder for Checklist Template redwood taskSummary: Hi team, Which table has the information for Rule Builder for Checklist Template redwood task. Need the table where Rule builder name stores for the checklist c…
-
Custom report is not triggering automatically after the Make EFT Payment process is completedSummary: Actual Behavior: Custom report is not triggering automatically after the Make EFT Payment process is completed (following upgrade to 25C). Expected Behavior: Re… -
Retrieving learner-submitted attachments through the BI reportSummary: I need to fetch learner-uploaded attachment details via the BI report from the specified path below. UI Path - Edit Assignment > Related Materials > Learning As…
-
ORA-64203:destination buffer too small to hold to hold clob data after character set conversationSummary: I was using below logic for getting job profile responsibilities and it was throwing the error "ora-64203:destination buffer too small to hold to hold clob data…
-
Standard report for Oracle journeysSummary: Standard report for journeys Content (please ensure you mask any confidential information): Hello experts, does anyone know if there are standard reports delive… -
OTBI issue issue,Workforce Management – Absence Real Time subject area.Summary: Hi , OTBI issue issue, calculated absence duration when using the Workforce Management – Absence Real Time subject area. Example: Employee submitted three conse…
-
Unable to find “Enterprise Scheduler Job Application Identity for HCM” user/Application RoleSummary: Unable to find or assign “Enterprise Scheduler Job Application Identity for HCM” user after recent Oracle release Content (please ensure you mask any confidenti… -
Can we differentiate custom verbiage for Emp & Payroll in Personal Info workflow FYI Notifications.Summary We are currently working on customizing the workflow notifications for Personal Information changes (specifically modifying the PersonalInformation_AddressPostRe…
-
How to connect organization hierarchy with job requisition?Summary: I am using recruiting real time subject area and trying to connect Job Requisition with Level 3 Organization Name but unable to get result on the Level 3 org na…
-
OTBI – Reporting on L2/L3 Org Hierarchy in ORC (Blank Hierarchy Fields)Summary: We’re currently trying to build an OTBI report in Oracle Recruiting Cloud (ORC) that includes organisational hierarchy information beyond the flat attributes. A… -
How to identify records in ASSIGNMENTNODE PVO that do not appear in Employee's History?Summary: When using the ASSIGNMENTNODEPVO, I see records for employees that I do not see in their history in HCM. For example, an employee resigned and this was entered … -
SQL query to fetch public holiday according to the work schedule of an employee.Summary: need a SQL query that fetches public holiday according to the work schedule of an employee. Content (please ensure you mask any confidential information): I nee…
-
Credit Time AU Disbursement Transactions not available in OTBISummary: Hi Team, I am trying to build an OTBI report for Credit Time AU but unable to retrieve Disbursement transactions. These transactions are visible in the UI under…
-
per_national_identifiers security?Does the table per_national_identifiers have AOR security? I see quite different row counts depending on whether I run a count (*) from pni when logged in as a country H…
-
What tables hold questionnaire details for RecruitingSummary: I've created a test interview questionnaire for hiring panel members to complete for shortlisting purposes and want to report on it. Content (please ensure you …
-
Disable BI Report Emails in Non-Production InstanceSummary: Disable BI Report Emails in Non-Production Instance Content (please ensure you mask any confidential information): We are planning to test some process by test … -
Redwood Launch for Reports and AnalyticsSummary Is there a tentative launch date/quarter for the Reports and Analytics tool/OTBI in Redwood? Content (please ensure you mask any confidential information): Versi… -
BICC PositionPVO not extracting historical effective-dated rows for HCM PositionsSummary: Hello, We are extracting the following HCM Position PVO from BICC into OCI Object Storage and then loading it into our database: HcmTopModelAnalyticsGlobalAM.Po…
-
I want SQL query to fetch data from talent review meetings , employee view potential assessmentSummary: below question and answers i need to fetch against the employee. (navigation talent review meeting in progress → select any employee in meeting → Actions tab→ v…