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 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…
-
Which privilege to access per_assignment_secured_list_vHello, I am struggling with the per_assignment_secured_list_v secured view in BI Publisher, as I can't seem to pinpoint the exact duty role that gives the "Report assign…
-
Hide the "View Report" button on the "View Enrollments" screen in the Benefits section.Summary: At the client's request, we have asked you to hide the "View Report" button on the "View Enrollments" screen in the Benefits section. This is because there are …
-
Payslip XML returns INPUT_VALUE_5 (Rate) as -1 but Rate is null in element entry pageSummary: We have created a Legacy element entry for a person through HDL with Input values for Original start date, Original end date, Multiple, Amount. All the values a…
-
Time Change Request Type TableSummary: Hello, does anyone know which table stores the values of Request Type column in Time Change Request page? We are currently building a BIP report and was able to…
-
OTBI Cross Functional Subject Area Reporting Error!Summary OTBI Cross Functional Subject Area Reporting Error!Content Hi All, I am trying to report against the following Cross Functional Subject Areas, Compensation - Sal…
-
OTBI report retrieving Base Salary amount and Annual Salary amountSummary: Content (please ensure you mask any confidential information): Hello experts, do we have a standard OTBI to retrieve Base Salary and Annual Salary amount? If so… -
Headcount and salary report with as of date using Workforce Assignment Salary History Real TimeSummary: Objective: To create an analysis with headcount (aka assignment) and salary data. Issue summary: We believe [Compensation - Workforce Assignment Salary History …
-
Show the pod or instance name on an OTBI Analysis?Summary: We need to be able to label the header of an OTBI Analysis with which pod or instance it comes from. It can be pulled into a data model using the following quer… -
Compensation Zones in OTBISummary Is it possible to report on compensation zone configuration in OTBIContent Is it possible to pull compensation zone information into an OTBI analysis? Based on t…
-
How to remove line feed and Carriage return from clob columnSummary: How to remove line feed and Carriage return from clob column, without using Translate function and Exclude Line Feed And Carriage Return for LOB option in prope…
-
BIP attachment Query not accepting the parameterSummary: Hi, When I try to use attachment query with dynamic parameter(:P_DID) , i am not getting the UCM outputs. If I hardcode any UCM(DID) from revisions table then I…
-
Add Learning Incident Comment into ReportSummary: I had created a Learning Incident report so that we can see who had reported the incident. Learning Admins receive notifications when incidents are reported but…
-
Can we customize the report 'Employee Vacation and Delegation Rules Report'Summary: Since there is no possibility to restrict employees who they can delegate approvals to we need to be able to control/report on creates approval delegation rules… -
BI/OTBI Report to identify list of all users who have access to a specific employeeSummary: We have a requirement to fetch all users who have access to view/modify employment data for a given user. We explored options and we can see such information is…
-
Subject area to fetch Legal Employer Seniority Date at Work Relationship LevelHi, We have moved to Seniority Dates V3 version. We tried to use OTBI to create reports to fetch the Legal Employer Seniority Dates at Work Relationship level. The subje…
-
Probation Period Alert using Alert Composer in R13Summary Probation Period Alert using Alert Composer in R13Content Hi All, Has anyone worked on Alert Composer for Probation Period alert? I have seen no standard alert p…
-
Payroll HCM ExtractSummary: Does anyone have a HCM Extract for an outbound payroll integration already developed? We are exploring the HCM Extract features in Data Exchange and are going t…
-
Which privilege gives access to employee abstract role view own data in OTBI reportSummary: Currently employee not able to view their own data in OTBI analysis with custom employee role. But when I used the seeded employee abstract role it gives too ac…