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
-
how to use get_variable in IF condition in RTF templateHi Team, We have a requirement to display the data in report based on net sal, to get this done we are using below tag in RTF template and its not working, we tried diff… -
Business Unit Name ER_EXT_SEC_HISTORY_ASSIGNMENTS_UETeam, We have created an extract and using PER_EXT_SEC_HISTORY_ASSIGNMENTS_UE. Attributes: Business_Unit_ID - Extract Historical Assignment Business Unit ID (DBI) Busine…
-
Capture the Learning Activity description in OTBI reportSummary: Content (please ensure you mask any confidential information): Hi there, is it possible to get the description of an Activity in an Offering from the Learning R… -
Length of service calculationSummary: How to calculate Length of service from latest hire date of employee? Content (required): I am using Workforce Trend Real Time Subject Area, I need to show the … -
Create Report to Include Sign On Bonus from Offer LetterSummary: I have an analysis report that list candidates that we had hired. However, I need to add Sign On Bonus amount into the report. I found the "Other Compensation" …
-
OTBI Analysis for Remote Workers and Onsite Associate Work Location State and Postal CodeSummary: We currently have a large population of workers who work remote or their "Work Location" is classified as their home office. Our population of around 18,000 wor…
-
TuroverSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t… -
HCM table to fetch eligibility status of compensation plan.Looking for HCM table to fetch eligibility status of compensation plan as "Eligible" or "Limited".
-
Is there a way to pull out job offer comments in OTBI?Summary: Is there a way to pull out job offer comments in OTBI? Content (please ensure you mask any confidential information): Hello Experts, We are challenged to pull o… -
Integrate OTBI with ODASummary: I need more clarity on the feasibility of the integration of OTBI/BI publisher with ODA. Is it possible to access OTBI report from ODA ? Content (please ensure …
-
OTBI report returning Lookup codes, how to fetch meaning instead of codesSummary Few Talent profile attributes in OTBI report returning lookup codes.Content Hi, In the Person profile>License and certifications section few fields are lookup ty… -
Progression Ladder for a bi_query_reportSummary: how to join rates to per_grade_ladder_f and per_grade_steps_f for a bi_query_report to show Progression Ladder > Grades that belong to Ladder > Steps in Grade >…
-
Getting error while uploading PGP key in BI AdminstrationSummary: Getting below error while trying to upload the PGP key. Importing public key file xxxx_public.asc failed: reason = Key file could not be imported: exit value=2 …
-
BI tables to retrieve Compensation Plan Status and track compensation plan approval flowSummary: Content (please ensure you mask any confidential information): Hello experts, we need to track manager compensation plan status (i.e Submitted; Work In Progress… -
Optimizing Infolet Loading Time on the SpringboardHello Community, We’ve designed and implemented multiple infolets for employees, line managers, and HR, placing them on the springboard to provide quick access to releva… -
Request for Infolet Samples to Enhance User Experience in Core HR, Absence, ORC, OTL, and PayrollHello Community, I’m currently exploring ways to enhance the user experience for employees, line managers, and HR teams in Oracle Cloud by leveraging infolets effectivel…
-
While creating Value set on oracle fusion getting error.The value column is not valid. (FND-2806)Summary: The value column is not valid. (FND-2806) In value set TID_Grade_Value, value column LISTAGG(distinct(prv.value), '; ') WITHIN GROUP(order by prv.value ) "UPGRA…
-
How to have a Batch ID parameter which is present in BIP Report in the Dashboard?Hi , We are creating a dashboard of a BIP Report for our use-case, BIP Report has a parameter called Batch ID with which we will pull the data regarding that batch load.…
-
Payslip - Other Deductions Section is showing doubled amountSummary Need help in determining if the issue is just with the BI Report or if the dataset is pulling in the wrong informationContent An employee had his garnishment (In… -
Payroll - Element Entries History Real Time Assignment ManagerSummary: Payroll - Element Entries History Real Time assignment manager subject area - what to find assignment manager to class employee as direct or Indirect staff Cont…
-
OTBI report update historyWe have several OTBI reports being updated that are not deployed by our support team. How is the owner updated to System Account? Is there a way to get the audit history…
-
How to show person data at the time of absence submission in OTBI?Summary: We have a requirement to show the person data at the time of submitting their absences. But the OTBI report brings the latest job name, FTE, department, busines…
-
Determine Account date for PAY_COSTS entriesSummary: I am trying to figure out how to get back to the accounting date from each entry in the pay_costs table. We have a need to get this down to the person for some … -
admin is unable to see contents in user foldersSummary: In the past we have been able to see the contents in a users folder when in Admin view. Now we can no longer see the files. Has anyone else experienced this iss…
-
How to clear cache in BI report?Hi Team, I have added roles with full access to BI report folder permission but user who has the role unable to view the folders. Could you please advise how to clear th…
-
Calculating Days in Calendar Year on a Suspended StatusSummary: Part of our annual incentive program, we prorate any worker who has been in a Suspended Assignment Status for greater than 90 days in the Calendar Year. Looking…
-
Can anyone help with a report to find potential duplicate employeesSummary: We have Contingent Workers who instead of being re hired as Permanent employees against the CWK record, these are being rehired as new employees creating duplic…
-
Help in query to retrieve Relationship Criteria on Eligibility Profile for BenefitsSummary: Hello! I am currently biulding an query to get all the Eligibility profiles and their criterias. Currently, I am in need to find the table to give me the relati… -
Questionnaire report with Question that has multiple answers - duplicating rowsSummary: Has anyone successfully been able to get a report on questionnaires that has a 'check multiple choices' question on one row for an employee who selects multiple…
-
Getting multiple values with HZ_LOCATIONS queryHello, I am creating a BI report to fetch location values from HZ_LOCATIONS table for longitude and latitude along with person details from employee table. The query is …