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
-
Bursting emails are not triggered when sent from any other email apart from domain @oracle.comSummary: We are currently using bursting email notifications to notify employees . However, we have encountered an issue. When we set the "From" email address (Parameter… -
Requesting details on FDIHi Team, We are planning to implement FDI module ( Reporting ); and I am unable to get much details on FDI on CCC as well as on HelpCenter. Can you kindly assist on the … -
How do I get current status of previously terminated employees onto a report?Summary: I have a termination report with all prior terminations on it. However, for rehires, I want it to show that they terminated but I need to know that they are cur…
-
Table with the worker number field of the HCM module in Oracle Cloud FusionKind regards, Please help me to identify the table that has the worker_number field, it is not the person_number of the HCM module in Oracle Cloud Fusion. Thank you for …
-
how to add additional attributes in payslip xmlSummary: how to add additional attributes in payslip xml Content (please ensure you mask any confidential information): Hi All, We need to add emp's passport detail in p…
-
Employee Length of service (LOS) sql query based on Hire Date/Rehire Date in fusion hcmHello Team, I need a sample Employee Length of Service (LOS) SQL query based on hire date/rehire date in Fusion HCM to use outbound integration for one of my customers. … -
OTBI Analysis Report is not giving Salary Information as expectedWhen we are running the OTBI report, the salary information for the terminated employees is not displaying as expected, and for a few employees, salary details are getti…
-
Filter Criteria Changed in OTBI report when i run the schedule processIn OTBI Report ,few DFFs were missing from subject area and also the filter criteria changed to "Assignment Status Type is not equal to / is not in INACTIVE; INACTIVE_PA…
-
How to merge rows in OTBI?Summary: Hello, how can I merge these rows below? There seem to be an extra row under Role/Assignee and Due Date. Thank you Content (please ensure you mask any confident…
-
How to show the "Not Started" in graph even if its 0 count?Summary I have this graph of Document Status (Not Started, In Progress, Completed). I want to show the "Not Started" even if its 0 count. How can I do it? Content (pleas…
-
oracle query for Organization Card/social securityHi, I'm looking for a way to get this information from the following image in an Oracle Fusion query
-
Divide Incorrect OTBIHi All, I have a LSQL report which returns an incorrect value when dividing. I've tried other operators such as addition and multiplication, and the formula calculates t… -
Using Case Statement on Performance Document StatusSummary: Hello everyone, I need help on my case statement. Can you please check if this is correct. There are errors when I use the statement. I want to only have 3 stat…
-
Historical Location Data Workforce Learning - Learning Records Real TimeSummary: Content (please ensure you mask any confidential information): We have started to move our reports to the Workforce Learning - Learning Records Real Time as the… -
How to attach custom bi report to document of recordsSummary: How to attach custom bi report to document of records Content (please ensure you mask any confidential information): Hi All, We got a requirement to attach bi r…
-
Work Schedule future dated rows not joining correctly OTBISummary: We have a report comparing the work schedule vs the work schedule assignment. Work schedule (Assignment real time) Work Schedule Assignment ("Person Schedule As…
-
Finding Business Owner of Dynamic GroupsI am reaching out to inquire whether anyone has knowledge on how to find the report owners for Dynamic Groups within oracle system. Specifically, I am interested in unde… -
OTBI learning Report issueSummary: I have imported Learning OTBI report from instance to another In Instance 1 the OTBI report for Learning is working fine Instance 2 OTBI is not fetching any dat…
-
How can we download the uploaded document File from/via BI Publisher using SQL queryHi , Is it feasible for an employee to download the uploaded document file from/via BI Publisher using an SQL query? Thanks, Ravi Chaitanya
-
BIP | SFTP issuesSummary: In which table holds the FTP failure error messages. Content (please ensure you mask any confidential information): Assume that BIP report unable to place the f…
-
USING SUBSTRING IN CASE STATEMENTSummary: Trying to extract Working Hours from ORC Requisition Internal Description using SUBSTRING in a CASE statement Content (please ensure you mask any confidential i… -
BI Publisher - Data RequirementsI need help trying to find Tables that contain the following information for HCM if possible Full Time Equivalent (FTE) Maximum salary in Oracle Country Gender e.g. M, F…
-
Case Worker is not able to remove the attached document with the caseSummary: Case Worker is not able to remove attachments with in the case , remove option is not appearing for the case worker. Content (please ensure you mask any confide…
-
BIP | SFTP filenames with .XLS or .XLSX extensions are not readable in SFTPSummary: Hi Experts, My requirement is to place the SFTP file in .XLSX format. SFTP filename with .XLS or .XLSX extensions are not readable in SFTP, but filenames with .…
-
How to display in a Report a Document of Records (DoR) Image AttachmentSummary: is it possible to achieve the following requirement? 1. Update an image to a DoR as attachment 2. In a report enter a DoR ID as a parameter and then print/displ…
-
No results using subject area "Workforce Management - Worker Assignment Real Time"Summary: Hello, I'm trying to create a learning report showing employee's division, branch, department. I get results I need except from the 3 criteria. I have both HR A…
-
OrganizationAM.OrganizationUnitPVO field OrganizationUnitTranslationPEOTitleSummary: HcmTopModelAnalyticsGlobalAM.OrganizationAM.OrganizationUnitPVO field OrganizationUnitTranslationPEOTitle showing NULL VALUES Content (please ensure you mask an…
-
How to get completion record for learning activities under course and offering?Summary: Hello, I'm trying to create a report for completion of activities. Can anyone point me where to find from the Workforce Learning - Learning Records Real Time su…
-
How do I query Administrator Profile Options?We often find that there are Administrator Profile Options that are enabled or disabled during upgrades that we are unaware of and are not part of the release notes. Bec… -
Performance Issue - per_availability_details.Get_availability_detailsWe've developed a BI Publisher Report, but it's experiencing performance issues. When run ad-hoc, the report times out (Timeout Error), and when scheduled, it takes over…