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
-
Is it possible to have conditional Display of report parameters on the basis of value in other paramSummary Is it possible to have conditional Display of report parameters on the basis of value in other parameter ?Content Hi Experts, Is it possible to have conditional … -
BI Pub folder/object security reportContent Hello, Are the catalog folder/object level permissions stored in a DB table? Can we report on what users/roles have been applied to folders/items to secure them?… -
OTBI Dashboard prompt defaultContent I have an OTBI dashboard prompt that I want to default to the current logged in user. However, the session (server) DISPLAYNAME value is in a different format an…User_2025-01-23-21-24-21-434 68 views 5 comments 2 points Most recent by Raghavendra Raghunath-Oracle -
Excel based Template Report- Does not provide PDF export optionSummary Excel based Template Report- Does not provide PDF export optionContent One of our BI Report, The Report was created using an Excel based template (Means: Created… -
What is Talent Rating Subject areaContent Hi Team, We have the talent rating where we have, Performance rating, Risk of loss etc. Is there any possibility to get the from OTBI? I know, We can get through…
-
Report for delegation using BPM worklist vacation rule screenContent A report is required to show BPM Workflow information where a task has been assigned due to a vacation rule taking effect. We are trying to get the following inf…
-
Query to return employees related to a particular Representative type for a given AoR and scope of rSummary Query to return employees related to a particular Representative type for a given AoR and scope of responsibilityContent Hi All, Please share Query to return emp… -
HCM Cloud - OSHA ReportsSummary Looking for documentation (HCM Cloud) on 300, 300a and 301Content I cannot find any configuration documentation related to these reports. Can someone please dire…
-
BI publisher SQL for finding users who are active in the security console but terminated in the applContent Hi experts, We have found an issue where sometimes when an employee is terminated in HCM they are still showing as an active user in the security console. To res… -
Column Formatting for hashtag resultsContent Hi all, I'm hoping the request I'm asking is relatively simple to do. We have an OTBI report that when run within OTBI, displays date values as '00/00/0' but whe…
-
RTF TemplateContent Scenario: I have created two data sets in my data model: G1 and G2 G2(Parent) G1(Child) Parent will always have one row and its corresponding child can have a ro… -
Using EL Expressions to Filter an OTBI Report which is embedded in the applicationContent Hi, Is it possible to filter an embedded report based on contextual variables? For example the following EL expression #{bindings.DisplayName.inputValue} returns…
-
OTBI Elements Report is not Pulling in All ElementsContent I've built a simple OTBI report for Retirement Deductions and Matching Contributions. My company has 401K, 403B, and 457 Retirement Plans. So, I've filtered for …
-
Pay Code / Element Mapping to General LedgerContent Is there a Subject Matter Area which permits you to build an OTBI report of the Pay Codes and the GL Coding or Concatenate Segment associated with the specific P…
-
OTBI Agent to send one email for each recordSummary OTBI Agent is sending the entire report to the recipientsContent Hello Everyone, I need some help. We are trying to implement a mail merge that will be triggered… -
Create Custom Subject AreaContent Hello experts We need to do a dashboard with an easier layout to deal with. and better UX then Publisher native Is it possible to use a query and create the subj… -
Issue with Views in HCM cloud Learning Management (WLF_LRNR_COMPLETION_DETAILS_V) in SpecializationSummary Joins are missing in the Specialization item type part in the Views WLF_LRNR_COMPLETION_DETAILS_V and WLF_LRNR_COMPLETION_SUMMARY_VContent In the code of the vie…
-
How many columns can report based on Excel Template have?Summary How many columns can report based on Excel Template have?Content Hello. I am busy creating a data migration extract (BI Report) that contains a lot of fields. I … -
Oracle Documents of Records linkContent Hi Guys, Is there a OBIEE BIP SQL CODE code that can turn the column value into a clickable link, please see image for reference. Here's my current sql code. tha…
-
Unable to Create Cross Subject Area Report for Succession - Incumbent Plans x Candidate DetailsSummary Unable to Create Cross Subject Area Report for Succession - Incumbent Plans x Candidate DetailsContent As we are preparing for Talent Reviews, I have been trying…User_2025-02-08-03-57-26-191 31 views 8 comments 0 points Most recent by User_2025-02-08-03-57-26-191
-
Report jobs how can we view BI Publisher reports scheduled by OTHER users ?Summary Report jobs how can we view BI Publisher reports scheduled by OTHER users ?Content Hello , We enter with an admin user the “reports and analysis “-> report jobs.… -
Base Salary and Payroll elements tablesContent Hello experts, I need to extract by SQL compensation data for a specific employee. Do you know in which table I can find the following information: -Base Salary … -
Need query to pull finalised or processed pay period namesSummary Need query to pull finalised or processed pay period namesContent Need query to pull only finalised or processed pay period details?
-
E-Sign Policy documentSummary E-Sign Policy documentContent Hi All, We have a requirement to create BIP template using provided Onboarding Policy template(.RTF). In the Template we need to ad…
-
call Dashboard from HCM page -how to keep BIP paramsContent MY BIP report has two params (one dependent on another). I need to create a dashboard and display the dashboard under 'My Client Groups'. I did it all. However, …
-
Last Update Date in OTBIContent Hi, Can someone help me to find where to get Last Update Date for "About This Record" in Person tab for "Extra Information". Flow will be go to Person=> Extra In…
-
BIP SQL to show the Emplid, Name and Today's date of the Login userSummary BIP SQL to show the Emplid, Name and Today's date of the Login userContent I am creating template report which should automatically show Emplid and name based on…
-
per_addresses not having dataSummary per_addresses not having dataContent I don't see PER_ADDRESSES TABLE GETTING POPULATED, Instead the tables like per_addresses_f is having data but the per_addres…
-
List of Core HR Audit Tables - For Building Audit report in BIPSummary List of Core HR Audit Tables - For Building Audit report in BIPContent Can anyone provide me the List of Core HR Audit Tables - For Building Audit report in BIP
-
Need help in restricting infolet in Legal Employer Transfer PageContent Dear All, I have created an OTBI infolet on Legal Employer Transfer UI in Assignment section. Now this infolet is visible in all the pages where Assignment secti…