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
-
Sql query for employment term numberSummary Does someone have a query for the employment term number?Content Hi, I'm really need an sql query for that shows the person number, person f.name, person l.name,… -
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 …
-
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 …
-
An unresolvable error has occured. Please contact your administrator for more InformationSummary: Getting unknown error as "An unresolvable error has occurred. Please contact your administrator for more Information" While clicking on Start Synchronization fo…
-
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…
-
Learning Table Details to fetch Learning Access Group related fields along with access group membersSummary: I have requirement create BIP report to fetch all learning item along with access group related details like Access Group selection method, Access group Run as,…
-
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…
-
learning alert template that works on condition basedSummary: Template that works based on learner added at course level and learner added at offering level Content (please ensure you mask any confidential information): He…
-
Limiting restricted, Confidential and PII fields BI Authors in HCMSummary: Our goal is simple: Make OTBI authorship available to as many HR and potentially non-HR employees as possible while being conscious of security. Example: Make a…
-
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…
-
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 …
-
Report/Tables to extract User Role change History for every role assigned/revoked on a userSummary: Hi Experts, We have a requirement from the customer to track the history of changes on a user roles. Ex, If a user has been assigned a role on 01-Jan then that …
-
Dynamic Header generation in RTFSummary: Is there a way to create an RTF or Excel template that allows us to dynamically populate the header? Content: The requirement is to fetch pre‑screening question…
-
OTBI - values turning to blank after more columns are addedSummary: I have built a report that combines two subject areas: Compensation - Salary Details Real Time and Payroll - Element Entries History Real Time The report is sho…
-
Clicked metric is not available for reporting or data extraction in ORC CampaignsSummary of the Issue In Oracle Recruiting Cloud, the “Clicked” metric is visible and functions correctly at the campaign level in the user interface. However, this metri… -
How to get shift name start time, end time for certain date, from the work schedule caledarSummary: In oracle Fusion, We need a query to identify the shift name , shift start time and shift end time as the following parameters shall be passed Emp number Date C… -
Can we load the Worker by Passing the LegalEntityId not the Legal Employer Name via HDL ?Summary: As we have a requirement to load the Worker (Person, Person Name and Assignment for new record) via Legal Entity Id not the Name. Can you please suggest any way…
-
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…
-
OTBI ResourcesContent Resources to help you get the most from OTBI. Training Oracle Applications Analytics Cloud Service Videos (Oracle Learning Library) - many are no longer availabl… -
Information: Query to get last P2T/T2T Refresh DateSummary: In order to get last refresh date from backend, below SQL can be used: select * from ask_deployed_provision_configs last_update_date column in this table gives … -
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…
-
BIP report, for identifying the missing Time EntriesSummary This will be useful If we are expecting to see missing time entries in report or infolets. This SQL query logic is based on the Working hours of the User.Content…
-
Report for Missing TimecardsSummary Employees without time card associationContent Hi All, We have a requirement to identify and report those employees that are missing time card association. I am … -
cant show HR Representative in Otbi reportHello , I want to create a otbi report where i want to see my subordinates which is i am HR representative. I am the line manager of some employee and HR Representative … -
Access to Reports and Analytics section - Roles and privileges requiredSummary: Hi All, We had the requirement to build a custom data role which will give the user the access to Reports and Analytics work area and role should provide access…
-
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…
-
How to find the difference between two date attributes in eText templateSummary: We need to find out the difference between two dates and add 1 to the result in eText template. Content (required): We need to find out the difference between t…
-
Incorrect drill-down results (action link to BI content) when using UNION in OTBI AnalysisI've written an analysis against the Workforce Goals - Goal Status Overview Real Time subject area. I had to use a UNION to accommodate some complex criteria and breakou…