Category 81
Discussion List
-
Journey Template reportSummary: Does anyone have a sample of a report that pulls all the configuration details related to a journey template? Content (please ensure you mask any confidential i…Shanna Oppenheim 3 views 0 comments 0 points Started by Shanna Oppenheim Reporting and Analytics for HCM -
I need a unique users report in HCM Fusion.Summary: User Audit Report. Content (please ensure you mask any confidential information): Hello, everyone! I need a report or query that allows me to identify unique us… -
REST API to get worker assignment historySummary: How to fetch Worker Assignment History details using REST API Content (please ensure you mask any confidential information): The requirement is to fetch Worker …Dipika Chatterjee 210 views 5 comments 0 points Most recent by Biplab Sarkar - bisarkar HCM REST APIs -
Need query to get scheduled process details such as process name, scheduled time, parameters.Summary: Need query to get scheduled process details such as process name, scheduled time, parameters. Content (required): I need query where I can get count of active s… -
In OTBI Multiple home email address to show in Single columnSummary: In OTBI, there is a requirement to display multiple home email addresses in a single column. In my case, two home email addresses need to appear in separate col…Shubham Kadam 27 views 5 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
How to Restrict Modification of Certain Contexts in Person EIT Information Using EFF SecuritySummary: Hello, We are currently working with Extensible Flexfields (EFF) on Person EIT Information. Our requirement is to restrict modification of certain contexts whil… -
Is there a way to get attachment attached to questionnaire responseSummary: We need to fetch the attachment which is attached as response to a question. These questions are enabled under guided journeys. Please advise if we have any of … -
Logical SQL not returning dataSummary: I have built a report using logical SQL is not returning expected data - possible subquery issue Content (please ensure you mask any confidential information): … -
How can I get Double Quotes in eText file for column data which has comma (,)Summary: How can I ensure that data containing a comma (,) is enclosed in double quotes when exporting a comma-separated values .txt file from Oracle Example 1 (No comma…Janardhana Kondaveeti 6 views 1 comment 0 points Most recent by RVohra Reporting and Analytics for HCM -
Original Candidate sourceSummary: Content (required): Is it possible to capture candidate’s original source via reporting? Currently the system only tracks application source and we lose key dat… -
oracle.xdo.XDORuntimeException: oracle.xdo12c.xpath.XPathException: Extension function error: ErrorSummary: Hi, am getting below error in BIP level. oracle.xdo.XDORuntimeException: oracle.xdo12c.xpath.XPathException: Extension function error: Error invoking round:java…Ranjith1166 26 views 4 comments 0 points Most recent by Abhinay Singh-Oracle Reporting and Analytics for HCM -
How to display different email address types in separate columnsSummary: We have a requirement to display separate columns for work email address and home email address, one row of data per employee. Content (required): From reading …User_2025-01-29-23-50-34-285 65 views 10 comments 1 point Most recent by Shubham Kadam Reporting and Analytics for HCM -
Query optimization questionSummary: Processing is fast only when not filtering by wlf_assignment_records_f.COMPLETION_DATE Content (please ensure you mask any confidential information): I have a l…Stefano_Mazzocca 4 views 0 comments 0 points Started by Stefano_Mazzocca Reporting and Analytics for HCM -
How to use Work schedule in Eligibility for Fast FormulaSummary: Hi Team, we have a requirement : We have a Absence Type- That should be eligible to only employees who are having work schedule A. How to make it possible in El… -
Requirement is to display image uploaded in DOR in BIP reportRequirement is to display image uploaded in DOR in BIP report. I am able to get the UCM content id how to get the image that was uploaded in XML to use in RTF ? select f… -
In OTBI-Whr to find the Approval Pending with /submitted by/submitted date info in job RequisitionSummary: I am trying to create a pending Job requisition OTBI report, in the subject area Recruiting - Recruiting real time with the requirement in adding information re…Sankaran Lakshminarayanan 5 views 2 comments 1 point Most recent by Venkat Vatikuti Reporting and Analytics for HCM -
line manager DashboardSummary: In Line manager dashboard, we are getting head count from "Workforce Management - Worker Assignment Real Time" subject area. I am able to see all records in thi…Niharika123 233 views 17 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
insert line break inside a conditional statement in rtf letter templateSummary: insert line break inside a conditional statement in rtf letter template bi publisher Content (required): creating an RTF letter template and need to insert a li…Akhil Vutukuri 2.3K views 3 comments 0 points Most recent by Ashish1Soni Reporting and Analytics for HCM -
Unable to deliver the file to SFTP serverHi Team, We have created SFTP server and while clicking on "Test Connection" the connection is showing as successful. But while we are scheduling the extract to the resp… -
Element HDL Template Generator ReportSummary OTBI report to generate sample files to create Payroll Elements using HDL Content Introduction: This report provides sample files to create Payroll Elements usin…Kaushik R-Oracle 9.8K views 128 comments 35 points Most recent by Kaushik R-Oracle Payroll and Global Payroll Interface (GPI) -
Terminated employee still visible as incumbents in position, how to free the vacant positionSummary: Terminated employee still visible as incumbents in position, how to free the vacant position Content (please ensure you mask any confidential information): Vers…Abdelhafid Rhofir 185 views 13 comments 0 points Most recent by Deepak Veetil Reporting and Analytics for HCM -
Poor Query Performance of CMP_ASG_SALARY_VSummary: A simple query on this view runs 40+ minutes. We are experiencing poor performance with the CMP_ASG_SALARY_V HCM view. When doing a simple SELECT statement with… -
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 Report SQL Issue - HelpSummary: Hi, can someone pls help check what's wrong with this SQL below. When I add the Performance Document Participant"."Role Type, I receive this error: I want to fi… -
OTBI agent More Details - success?Some OTBI Agents More Details read: "Last Run 09/12/2025 8:00 AM GMT+00:00 | Agent Successful | Next Run 10/12/2025 8:00 AM GMT+00:00". Other agent More Details read "La… -
Get candidate attachments for BIP Data ModelSummary: Option to get the URL for accessing a candidate's attachment in the Recruiting module Content (please ensure you mask any confidential information): Hello every… -
How to get the USER_NAME or USERID into default value of a data model parameterSummary: How to get the USER_NAME or USERID (or exquivalent) into default value of a data model free form string parameter Content (required): In a data model I would li…Jbgood 1.9K views 5 comments 3 points Most recent by Humberto Martín-Oracle Reporting and Analytics for HCM -
Buyer Assignment Rules OTBI ReportGood Day Experts, Is there a way to create an OTBI report to show details and information for Buyer Assignment Rules? Screenshot below is the view from Fusion Applicatio… -
Multiple Absence Actions Sharing the Same Object IDThere was an error rendering this rich post. -
can we add element entry section under hire an employee, change assignment page in redwood VBSSummary: Hi , Can we add element entry selection into Hire an employee, change assignment, Convert Pending Worker ,Local and Global Transfer, Promote and Transfer pages …KanchamMaheswar 16 views 1 comment 0 points Most recent by Volodymyr Faranosov Human Capital Management