Category 81
Discussion List
-
Report on Denied Absences (OTBI)Summary: I am trying to create a report on Absences which are in "Denied" Approval Status using the Workforce Management - Absence Real Time SA. The Approval Status fiel…Gary Miller-39965 57 views 9 comments 0 points Most recent by Gary Miller-39965 Reporting and Analytics for HCM -
How can some Audit details be reported in Oracle Cloud HCM?Hi, I need some application security details that the client requires. For Example; User Login and logout Roles assigned to the user and their changes Password change in… -
HR_DOCUMENTS_OF_RECORD_AUDIT Missing DFF Value for Assignment Number (Purged I-9 Report Issue)We are encountering a critical issue with generating a purged I-9 report due to a missing Descriptive Flex Field (DFF) value in the HR_DOCUMENTS_OF_RECORD_AUDIT table. T…Sunil Kumar A 26 views 1 comment 0 points Most recent by Shweta Ganguly-Oracle Human Capital Management
-
How to identify the employees who didn't receive Outlook invites after a course is assigned?Summary: Hi, Is there a query to identify the recipients of Outlook invites after a course is assigned? we have a situation where some individuals received the invites w… -
Issues experienced when using agentsHi everyone, We have a reporting team member has raised a few issues when using agents for reporting. Below are the symptoms of the problem. The agent failing The agent …
-
Remove Manager role from Worker self-evaluation Performance TaskSummary: Hello, I need help to check if my case statement below is correct. I encountered errors several times so I'm not sure what is the problem with this. I want to i…
-
How to restrict to get one level of indirect employee data of manager?We want to get the data only for Indirect employee of the Senior Manager? but we are getting Indirect employees reportees data also. In query we have used PER_ASSIGNMENT…YAMINI DANTOORI 12 views 0 comments 0 points Started by YAMINI DANTOORI Reporting and Analytics for HCM
-
Query to fetch legal reporting unit mapped to a legal entitySummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
exceeds the maximum limit error even after using filterSummary: exceeds the maximum limit error even after using filter Content (please ensure you mask any confidential information): Hi Team, Greetings! We are getting below …Parag Hiremath 4 views 0 comments 0 points Started by Parag Hiremath Reporting and Analytics for HCM -
Renaming Evaluate button in Performance Review is impacting other areasSummary: We want to rename the button Evaluate in Performance Evaluation but when we change it the change is impacting the same button which is used to View once the eva…
-
Query to find fusion user details with their rolesI need to create a BI report which retrieves user information like user_id,username , email of the users along with their role information like role_id,role_common_name,…
-
What is the role of the Manager in Self-Evaluation?Summary: Hello, I'm currently working on Performance Task Status Report for my organization. I've changed the Role to Task Assignee. In the Worker Self-Evaluation, there…
-
Is there a log or audit report available that tracks the changes made to the existing schedules?Summary: Can we access logs for changes in the report schedule? Is it possible to generate a historical report of those changes? Content (please ensure you mask any conf…
-
Email Address FormulaHi Everyone, I am building a report for one of our HR partners. She is using the report as a file loader to put employee data in an external employee recognition platfor…
-
Unable to pull salary amount into OTBISummary: Hi, I am currently building an OTBI report and I am unable to pull the Salary Amount into the report. The report is crossing multiple subject areas and I have i…Sylvia Wong 11 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Payroll query that fetches results only if for the Employee Generate Payslip flow is not run.Summary: I need to create a BI report which retrieves Employee Information of the users along with other Common columns also needed to see if whether is employee get pai…Ketan-Oracle 9 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
HCM OTBI subject areas to database lineage mapping spreadsheetSummary This spreadsheet documents HCM OTBI subject areas to database lineage mapping and subject area security. Content This spreadsheet is published by Oracle OTBI Dev…Raghavendra Raghunath-Oracle 37K views 177 comments 124 points Most recent by User_GDABQ Reporting and Analytics for HCM -
hide an RTF hyperlink field on notification report conditionallySummary: Hi forum and BI Publisher Experts: i wish to hide a URL hyperlink only when ( 2 ) previous data model person number values (will not be shown on report) are equ…
-
Workforce Goals - Goal Tasks Real Time 'Development Goal.description same as 'Task Name.description'Creating a simple analysis to report each development goal along with it's associated task(s) by using the Workforce Goals - Goal Tasks Real Time subject area. The 'Deve…Melody Herbert 10 views 2 comments 0 points Most recent by Melody Herbert Reporting and Analytics for HCM
-
REST API for Salary, Payroll elements and StocksSummary: Content (please ensure you mask any confidential information): Hello experts, do you know where retrieving REST API for Salary, Payroll Elements and Stocks? Kin… -
Talent Review Meeting Report-Security BIPSummary: How can we limit the visibility of the Talent Review Meeting Report so that facilitators can only view the meetings where they are assigned as a facilitator, wi…
-
Need to report the number of Goal plan assignees who have Goals Created/Not createdSummary: Hi peers, My client wants a report that gives a count of the number of employees that have created goals as well as those who haven't yet created (even a single…
-
How can I export list of delivered reports for fusion HCM?Summary: Where can I find list of core delivered reports for fusion HCM modules. Content (please ensure you mask any confidential information): Version (include the vers…
-
HCM report for monitoring access visibilityHi All, As a part of Executive and above (10,000+ employees) salary migration to the Fusion system, we are planning to introduce controls on salary visibility and access…Sachini 13 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
What Oracle IP address(es) should be provided to recipients of reports via SFTP delivery option?Summary: We need to provide IP addresses to an external third party so that they can whitelist them in order to successfully receive BI Publisher reports directly from O…BeachDreamer 250 views 5 comments 0 points Most recent by Christopher Haupt Reporting and Analytics for HCM -
Name of the table that stores the 'Location Based Access' infoSummary: Hi, I'm trying to figure out the table name that stores the 'Location Based Access' info. Navigation: FA → Tools → Security Console → Administration → Location …ganapathysundaramd-Oracle 6 views 0 comments 0 points Started by ganapathysundaramd-Oracle Reporting and Analytics for HCM -
Report to trace the elements costed from Journal entries along with transaction numberSummary: Report to trace the elements costed from Journal entries along with transaction number Content (required): Hi Team, Greetings! Once the entire payroll cycle is …Parag Hiremath 21 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for ERP
-
Employee time card punch in, punch out details SQL query in OTL fusion HCMSummary: Hi Team, We have a requirement to send notification to employees who has missed their time card punch in, punch out. Can anyone please help me with the sql quer…Prasad Singamaneni-Oracle 8 views 0 comments 0 points Started by Prasad Singamaneni-Oracle Reporting and Analytics for HCM