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
-
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… -
Is it possible to report on Interview Requests?Summary: Is it possible to report on Interview Requests? I've seen the post linked below, which I thought was asking the same question, but the answer appears to be dire… -
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…
-
How to get active user report based on employee idSummary: Is there a scheduled process or BI report which gives a list of all active employees in Oracle based on employee ID? Content (please ensure you mask any confide… -
Scheduled Report taking the extract in UTCSummary: Hello, The query is that if we are scheduling a custom report in IST time zone like 2.45 AM IST BUT the scheduled report is extracting the data from form 9.15 P…
-
Missing conditional paragraphs in Job Offer previewHello, I have created custom Job Offer RTF template with Oracle BI Publisher tool. I have included multiple conditional paragraphs, but only facing issues with paragraph… -
Does anyone know formula for Turnover% in Line Manager DashboardDoes anyone know formula for Turnover% in Line Manager Dashboard ? or do we need to edit the report, check the query and find it out ourselves. There is literally no doc…
-
Moved: accessing benefits of terminated employeesThis discussion has been moved. -
How to rearrange row in OTBI report?Summary: Hello, I need some help. I want to rearrange the performance tasks according to the order below per employee but every time I sort, the entire column sorts. Wor…
-
Table name or query to get timecard transferred to payroll detailsSummary: We need Table name/ Query/ Report to fetch details of the timecard transferred to payroll status. We have observed that when we run the Load timecard batches fl…
-
How to list all Performance Documents sent to employeesSummary: We have sent all our employees an annual appraisal document and we are trying to identify how many have completed it. Please advise how to list all Performance …
-
Moved: Absence Plan does not update when worker's employment details updated.This discussion has been moved.