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
-
OTBI - Legal Employers that use this jobSummary: OTBI - Legal Employers that use this job Content (please ensure you mask any confidential information): Subject Area: Workforce Management - Worker Assignment R… -
how to calculate average percentage of Budget Utilization in workforce compensation module?Summary: My requirement is to find out the average percentage of Budget Utilization in workforce compensation module. How can I derive that? Content (please ensure you m… -
What table(s) joins the converted work assignment to the pending work assignment?Summary: I am seeking information on what table(s) joins the converted work assignment to the pending work assignment? Use case is that information stored on job offer a… -
Issue with Error Message and Reported Hours in OTBI Report for Imported Time EntriesSummary: After submitting the process “Process Imported Time Entries”, a few time cards are erroring out. I need to build an error report that shows: Person Number Time … -
Changing Date format to 'DD/MON/YYYY' in SQL for BIP reportHi, Can you please suggest how to change the Date format to 'DD/MON/YYYY' in the SQL for BIP Reports. Thanks in advance. -
How to report the 'Attachment Count' of a DoRSummary: How to report the 'Attachment Count' of a DoR Content (please ensure you mask any confidential information): Hi, we created a Document Of Record. The employee h…
-
Is there a suitable replacement for PAY_ACTION_INFORMATION table for 'Employee_Rec' type rows.Hello, Could you please suggest a replacement table for PAY_ACTION_INFORMATION for action_context_type (POA) and action_information_category ('Employee_Rec'). We are fac…
-
SQL Query to get Absence Qualified Entitlements for an EmployeeSummary Need an SQL query to build a BIP report similar to what is available on the Absence Records UI which provides details of qualified entitlementsContent I'm not ge…
-
BI Table with ActivityAttemptId or the ActivityAttemptNumberSummary: Hi, I need to load LearningRecordActivityAttemptV3 object. To use LearningRecordActivityAttemptV3, I need to uniquely identify the rows to update using either t…
-
Need SQL query to get the report category details based on the HCM Extract nameSummary: Need SQL query to get the report category details based on the Extract name Content (please ensure you mask any confidential information): We need SQL query to …
-
Absence is wrongly calculating in OTBI reports when applied in advanced mode.Hi Folks, While submitting the absence in Advanced mode, the balance is calculating for whole week even if i apply for two days in a week. What might be the issue? Pleas…
-
How to connect Cloud Database to VS Code via Oracle Developer Tools for VS CodeSummary: We want to know if we can use Oracle Developer Tools for Visual Studio Code (SQL and PLSQL) extension to connect to Oracle HCM Cloud database. We are exploring … -
How to extract records for a specific date that is in CURRENT_YEARSummary: I have an OTBI report showing all employee terminations. What formula can I use to return only terminations in the CURRENT_YEAR? Field is "Worker"."Termination …
-
Termination Headcount from Trend real Time not giving correct headcountSummary: I'm working on an OTBI analysis to calculate and display the turnover percentage for leavers over the last two years as a line graph. The objective is to show t…
-
Headcount and salary report with as of date using Workforce Assignment Salary History Real TimeSummary: Objective: To create an analysis with headcount (aka assignment) and salary data. Issue summary: We believe [Compensation - Workforce Assignment Salary History …
-
BI Report: Empty report is downloaded eventhough the data is present in the view data modelSummary: Able to see the data in view data model. But in report, the data are not getting displayed and while downloading the report, Empty report is getting downloaded …
-
Is there a Subject Area in OTBI that will show all user's "Preferred Knowledge Locale"?Is there a Subject Area in OTBI that will show all user's "Preferred Knowledge Locale"? If so, what is the Subject Area? I've tried several "Knowledge" SA's, and a few "… -
Data is not showing in BI after creating any TransactionSummary: Custom report is not reflecting data immediately after transaction is made in system. Content (required): We have created custom report which is based on absenc…
-
Ability to scan all reports for specific fieldsSummary: Hi - We recently introduced a second Organization tree where we have only had 1 tree since our initial go-live in 2018. With the addition of this new tree, anyw…
-
Personal Payment Method Processing OrderSummary: Hi all So I've seen this asked before on another post but there wasn't a solution. The processing order for Personal Payment Methods doesn't appear to match up …
-
How to restrict special characters for account holder name in redwood personal payment method pageSummary: Customer want validation needs to be thrown as an error when there are Special Characters in the the Account Holder Name. And in personal payment method page I'…
-
Steps to fix back dated State tax rate after payroll has been processed.Payroll for January and February has been processed, and the Balance Exception Report indicates discrepancies for multiple employees across various state taxes. What are…
-
received error messages when running Missing Time reportsHi Team, As we are trying to run below delivered Missing Time Reports OTBI then we are getting below error. Could you please help to resolve the issue. ERROR
-
query to get timecard calculation for an employeeCan anyone help me getting sql query for calculated quantity in Timecards entries of an employee.
-
Extract all data from PAY_RUN_RESULT_VALUES and PAY_RUN_BALANCES tablesSummary: We have a requirement to extract all data from PAY_RUN_RESULT_VALUES and PAY_RUN_BALANCES tables since go live. We tried to build a BIP Report and running them …
-
Issue with Month-wise Active Headcount Count in Workforce Real time Trend Subject Area - OTBI ReportHello All, I am working on a report using the Workforce Trend - Real Time subject area in OTBI. The requirement is to show month-wise new joiners, attrition, and total a… -
last update date not getting for Business unitSummary: Hi We have deactivated Business unit. i was looking for last update date in view#fun_all_business_units_v but i am not seeing any change last_update_date. May I…
-
Subject area for Employee data (About me)Summary: Hi All I am trying to create a report on employee's 'about me' section. Not too sure what subject area/table to use for this? or if someone has something made a…
-
How to Query Cost Code from Oracle Fusion HCM OTL Time Card Tables?Summary: Hi Community, I need help identifying which table/column stores the Cost Code information visible in the OTL Time Card interface in Oracle Fusion HCM. Context: … -
Quick action menu created for BIP is not visible after 25DSummary: I have created Quick Action Menu item for BIP report course completion certificate. after 25D, its not appearing , when I checked in Sandbox , it shows message …