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
-
Sickness balances by proration periodSummary: I am trying to export the person number, minimum date and maximum date for all staff who between September 24 and March 26 had received "Statutory Sick Pay" whi… -
trying to edit a BPM location for change location approval but no option enabled for thisSummary: I am trying to edit a BPM location for change location approval. I have created and entered into the sandbox, then when i am trying to enter the BPM worklist pa…
-
Detailed requisition information is not visible for any usersSummary: The approval transaction page is displaying only the approval timeline, and detailed requisition information is not visible for any users. Content (please ensur…
-
OTBI Conditionl FormatingI’m facing an issue while building a formula in OTBI (Subject Area: General Ledger - Journals Real Time). Requirement: I want to calculate a value that combines: Journal… -
Need PVO name to fetch additional attributes from Assignment DFFSummary:We have additional attributes populated in Assignments and they are visible in Fusion OTBI BIP table per_all_assignments_f can you please let us know from which …
-
ORC report to show the most progressed candidate phase for every open requisitionHello - We want to create a report to provide recruiters a list of all open requisitions and the phase of the most progressed candidate for the respective requisition. W… -
OTBI New Calculated Measure Formula for Age at End of the Month from report run dateI need a formula that would provide me with the dependents age as of the end of the month from the report run date. If the report is scheduled to run on the 1st day of t…
-
I want SQL query to fetch data from talent review meetings , employee view potential assessmentSummary: below question and answers i need to fetch against the employee. (navigation talent review meeting in progress → select any employee in meeting → Actions tab→ v…
-
How to get data in oracle fusion hcm country vise which HCM offering they using in oracle fusion hcmSummary: Hi Team I am looking for how to get data in oracle fusion hcm country vise which HCM offering they using in oracle fusion hcm Could you help me on this Content …
-
Which privilege gives access to employee abstract role view own data in OTBI reportSummary: Currently employee not able to view their own data in OTBI analysis with custom employee role. But when I used the seeded employee abstract role it gives too ac… -
Visualization ConfigurationsSummary: After selecting the OTBI analysis in Source type , Search for the analysis is /Shared/Custom folder This is coming blank nothing coming up. Is there any search … -
Need Guidance/References: Reporting Post-Approval Timecard Edits in OTLSummary: Hello Everyone, We have a requirement to build an OTL BI report that captures post approval timecard edits. Specifically, when an employee updates a timecard af…
-
oracle cloud hcm bi publisher absences error handling reportHas someone written or found documentation for the steps to write an oracle cloud hcm bi publisher absences error handling report (or similar) that writes error messages…
-
Agentic AI Usage tokens consumption reportsSummary: Hello. Any advice on where to find the catalog contents for the Agentic AI Usage tokens consumption reports? I believe there are some catalog files in customer …
-
HCM subject area "Workforce Profiles - Library Objects Real Time" join questionHello. Any advice on how to join the HCM subject area workforce profiles - library objects real time to workforce profiles - person profile real time ? Not finding commo…
-
Customize / add new options to Selection Process Diversity delivered reportSummary: I'm hoping someone can help me understand how to modify delivered Selection Process Diversity analysis (I know I have to make my own copy to edit) that is part …
-
Approver Name of a transaction with OTBISummary: Create an OTBI report with Transaction details, the initiator and approver Content (please ensure you mask any confidential information): Hello experts, is it p… -
Same element is showing in Pretax and voluntary deductions in Payroll register reportSummary: Individual 401k element is showing up in pretax deductions and voluntary deductions in payroll register report. It should show up only under Pretax deductions n…
-
Absence Accrual Report is getting Timeout error.Summary: Absence Accrual Report is getting Timeout error. Error Code: SQL Query execution time exceeds the limit (500 sec)..stopped processing We have reproduced the iss…
-
solution for withdraw conditional statement in alert which workedSummary: Withdraw conditional statement Below is the solution for conditional statement Content (please ensure you mask any confidential information): Hi ${assignedToDis…
-
conditional statement course, specialization and offeringSummary: Conditional statement scenario's when learner are added at course → only course name with due date will get displayed with link to course 2. When Leaner are add…
-
Absence approval based on Line Manager TypeSummary: Hi Team, We have a scenario, where in there are 2 types of line managers (Line Manager; Shift Manager). So when employee submits a absence, first the approval n…
-
Query to get Languages in ORCSummary: Based on the screenshot I provided, What table in HCM can I get the list of values for the Languages in ORC. Content (please ensure you mask any confidential in…
-
User Login Activity QuerySummary: We have a contractor and would like to measure his level of effort within our company. Is there an existing query or report that shows how many times a specific…
-
BIP report layout hyperlink works with hard-coded parameter, but not with dynamic field valueSummary: I am trying to create a drill-through from one BIP report to another. The source report is a report created with the Layout Editor, and the layout file ends in …
-
Report is taking some time to reflect changed dataSummary: We are noticing that reports in Oracle Fusion HCM are taking considerable time to reflect updated data. For example, when changes are made in the application or…
-
We tried to use Reflect Changes from Edited Reports Sooner solution in fusion but it is not workingSummary: Hi team we have made the changes in the PR PO Approval Pages as per our requirement. We need to test the output. As a standard functionality system will take 24…
-
Extract the transaction console comment in OTBIHello, I have a requirement where I need to report (in OTBI) on the comments visible in the Transaction Console. Specifically for the termination quick action, in which …
-
How to create a report that includes employee information and the date of the last system access.?I'm trying to create an analysis with the last access information of employees to Oracle Fusion Cloud and I'm having trouble. Could you help me retrieve this date in the…
-
Bi report changes are not reflecting on ORC offer preview pageSummary: Bi report details with recent changes are not reflecting on candidate's application preview offer Page. Content (please ensure you mask any confidential informa…