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
-
Required table for component group rules setupSummary: Hi Team, Could ypu please provide us the table where payroll component group rules stored in oracle fusion Payroll module Setiup name > Component Group Rule. fo… -
Table to get Absence plan details in Payroll element taskSummary: Hi Team, Could you please provide us the Table or SQL query for the input values of Absence plan details, Absence Payments, Accruel Liability and Balance Paymen…
-
While running the talent report the technical competencies are not fetching for one employee.Hi Team, Need assistance on talent report, the report not fetching the technical competencies for one employee. But when we run the data model the data is coming. Thank …
-
How to provide the correct Return Value from the List of Value query in the BIP Data ModelSummary: I have this BIP Data model which extracts the pending approval of a certain user. This used to work before but now I am getting this error "Invalid parameters r…
-
I need help on my SQL for With and Without Goals ReportSummary: Hi, I hope someone can help me with my query. Only the employees "With Goals" are showing up. The employees "Without Goals" is not showing up in the report. I n…
-
Query to fetch candidate personal email address and personal phone numberHello Team, Please provide SQL query to fetch candidate's personal email address and personal phone number. These details should be taken from candidate info/candidate t…
-
Benefits OTBI Subject Area for Plan ID, Coverage Amount and Age Grade Rate.Summary: Hi Team, I am working on the OTBI reports for benefits module. Kindly suggest me the subject area for below mentioned columns. Benefits Plan ID Coverage Amount …
-
How can I safely handle cases where GET_VALUE_SET returns null, and default the value to 0Summary: When the value set returns null (i.e., no leave has been taken), the formula either fails or doesn't return the expected accrual. Even though I am checking for … -
BICC | Delta data records are not displayed correctlyHi, The BICC is to be used for the extraction of data. When testing the delta method, there are discrepancies between the status in the PER_ALL_ASSGINMENT_M table and th…
-
subject area for learning item in Development PlanSummary: Hi all, I am trying to retrieve the subject area for a specific section of Development Plan. 1. 2. So far I have retrieved all table info related to "Basic info…
-
Need to fetch the Content ID of HCM ExtractSummary: We have requirement to fetch the Content ID of HCM Extract through BI report. Any one have idea how we can fetch Content Id. Content (please ensure you mask any…
-
cannot add descriptive flexfield to Skill and qualification OTBI reportSummary: Hi all, I am creating a Data model report on OTBI to extract all info related to a section in Skill and Qualifications: I was able to retrieve all sections name…
-
PVO that has attribute columns in per_location_details_fSummary: We are on FDI 25.2—looking for a PVO which has the attribute columns in the per_location_details_f table in Fusion. Content (please ensure you mask any confiden…
-
Capability to add CSP Progression Comments in OTBI analysisHi All, Currently, it is possible for a recruiter to add the comments while moving a candidate to different phase / state. The comments are visible in Progress tab under… -
Oracle Fusion BI Publisher - RTF - Generate Multisheet Report Excel OutputSummary: Hi Team, We have a requirement where we need to generate an excel output with 3 tabs in the output file. Sheet1 name: Static value as "Parameter" and it has to …
-
'Time type' field column mapping from which table to fetch itSummary: Hi All, We are creating one report to get the employee overtime unpaid overtime details. we are looking for 'Time type' field column mapping from which table to…
-
Is there a query that returns all valid grades ever associated with a position with eff datesWe found an issue on Positions where Valid Grades, previously deleted via HDL, are returning as a valid grade in the UI when any change is made on the Position itself. W…
-
Where can we get the History of the Position for a report.Summary: I am trying to do a report for Position Details and trying to find the 'History' changes which can be found in the Position "Details" page just below the "Grade…
-
Historic values for pay_bank_accounts tableSummary: Historic values for pay_bank_accounts table Content (please ensure you mask any confidential information): This table has MASKED_IBAN field but when I change it… -
icp sortingHi, I am trying to sort the icp column so that the recurring records comes first and with in recurring records the latest records comes first and after recurring the non…
-
query to fetch educational details.query to fetch educational details.
-
Is there any SQL to help me identify missing Associations in a Taxable Benefits Calculation CardHi, We have started Payrolling Benefits this tax year and have identified an issue where a Calculation Component, along with the Calculation Component Details have been …
-
Workforce Performance - Performance Rating Real Time is not fetching ex-employeesSummary: "Workforce Performance - Performance Rating Real Time" subject area is not showing any ex-employees when i try to see their performance document info. When i ch…
-
Oracle FDI: Predictive Analytics for attritionsSummary: In FAW/FDI , any examples for predictive analytics for exit risk using HR Core subject areas? We see diversity analysis in demos but there is no catalog exists …
-
AbsenceTimeEntryPVO - AncAbsenceType missing some valuesSummary: AbsenceTimeEntryPVO - AncAbsenceType missing some values that exists in base table HWM_TM_REP_M_ANC_ATRBS_V Content (please ensure you mask any confidential inf…
-
Showing Attachments on Notification Worklist for "Request New Position" & "Request Position Change"Hello Community, I'm working with Oracle Cloud HCM and have a question regarding the visibility of attachments on approval notifications in the worklist. My Goal: I want…
-
otbi calculation only displaying whole numberSummary: Calculation is not showing the correct actual number (incl. decimals) Content (please ensure you mask any confidential information): Hi All Unless I'm doing som… -
Need to update the absence Entry before holiday and after holidaySummary: Hi Everyone , We have requirement where we have to update absence entry for employees who is in long term absence. Below is requirement:- First Step: Check for … -
SQL query for Planned Schedules on Time ManagementHello! I need help in developing an SQL query for generating the Planned Schedules for employees on the Time Management navigation: My Client Groups>Time Management> Pla…
-
What is impact of Enabling Extensive Flexfields in Oracle Fusion Analytics(fusion data intelligence)Hi , What is impact of Enabling Extensive Flexfields in Oracle Fusion Analytics fusion data intelligence, from following point of view. Data Replication time Performance…