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
-
Report allows user to see data from multiple Legal EntitiesThe issue is that when the user tries to access a report, if they have this role assigned: Compensation Administrator CAN Data Role They can pull more data, outside of t… -
Need query to get the list of all privileges for a given roleSummary: Need query to get the list of all privileges for a given role Content (required): Navigation: Tools > SecurityConsole > Roles If I query a role name, I am getti…
-
The supervisor hierarchy should be displayed in the report as a graphical representation.Summary: The supervisor hierarchy should be displayed in the report as a graphical representation. Content (please ensure you mask any confidential information): Require…
-
Dashboard prompt dependentSummary: Creation of a Dashboard prompt with Job Family, Job Function and Job Profile field dependent from each other. Content (please ensure you mask any confidential i… -
Remove Null value from Dependent LOV prompt in OTBISummary: When we creating dependent prompt using "limit by" option in the OTBI prompt, NULL value gets appended in the list of values. If user is running with NULL param…
-
unable to query the rejected transaction details from the approval related tablesContent Hi All, We have a requirement to report on the approval transactions (approved/rejected) and we have built the query based on hrc_txn_fnd_bpm_task_vl and hcm_fus… -
Using SET VARIABLE PARAM_EFFECTIVE_DATESummary I'm trying to default the "SET VARIABLE PARAM_EFFECTIVE_DATE=" back 3 daysContent I'm trying to set the "SET VARIABLE PARAM_EFFECTIVE_DATE=" prefix. I want to us…
-
OTBI Dashboard Prompt with Presentation Variable - dependentSummary: Trying to create multiple prompts using presentation variable. goal is that prompt 2 will be dependent to filter values from prompt1 but using the variables. Is…
-
Prompt filtering based on another promptSummary: Hi, I have 2 prompts as presentation variables and I need them to connect between each other. For example when I selected a specific country on the first filter…
-
Need query to get Employee contribution and pretax deduction information of person Result?Summary: Hi Team, I need BI Report query for Employee contribution and pretax deduction information from Fusion Content (please ensure you mask any confidential informat…
-
Has anyone created a custom role for staff outside of HR to access other staff addresses?Summary: Content (please ensure you mask any confidential information): I am still figuring out how to create custom job roles for HCM, but I am hoping someone that has …
-
Issue in adding Ethnicity Column.Summary: Hi All, I have an OTBI report that tends to fetch all the performance details of an employee, we are trying to add ethnicity column in the report with formula: …
-
Case Worker is not able to remove the attached document with the caseSummary: Case Worker is not able to remove attachments with in the case , remove option is not appearing for the case worker. Content (please ensure you mask any confide…
-
Issue with Vertical(portrait) view of offer letter over mail on mobile devices.We have noticed a display issue with the offer letter email when viewed on mobile devices in portrait mode(vertical view). The email requires horizontal scrolling to vie…sreenivasulu.devineni-Oracle 11 views 2 comments 2 points Most recent by sreenivasulu.devineni-Oracle
-
Need inputs to handle NULL values in OTBISummary: Need inputs to handle NULL values in OTBI Content (required): In case if an employee doesn't have Visa permit record then we are getting value as 00--0 in the O…
-
OTBI Report - Advanced Query - presentation variable is null, how to handle?Summary: In OTBI Report, I have used Advanced Query to combine multiple subject areas. As a parameter I'm using presentation variable. If the presentation variable is pa…
-
Add record ‘creation date’ in an otbi reportSummary: I would like to add the event 'record creation date' in an OTBI report I am developing, using the 'workforce management - worker assignment event real time' sub…
-
Person Management>HCM Group Override - Cannot find this field in Reports and Analytics.Summary: Trying to build a report that includes the values of the field "HCM Group Override" in Person Mangement in Oracle Fusion. I cannot find this field, and I've loo…
-
Presentation variable in Column Filter possible?Summary: Hello all, Not sure if this is possible - I would like to use a variable inside a column filter, for example for YTD Actual I have filtered on scenario Actual H…
-
How to use Choose and when condition in fusion hcm bip rtf templateSummary How to use Choose and when condition in fusion hcm bip rtf templateContent Hi Team, We have created BIP Report to send notifications based on legal employer wise… -
Windows 11Summary: Hi Team, Windows 11 in our organization roadmap for next year. Can someone please point to Oracle Fusion HCM Cloud documentation that covers the OS supported by… -
Define attachment type securitySummary: Understand how setup and maintenance "Global Attachment Entities" security checks work. Content (please ensure you mask any confidential information): Please, i…
-
Need inputs to display Town_or_city, Region_1, Region_2 and Region_3 values in BIP reportSummary: Need inputs to display Town_or_city, Region_1, Region_2 and Region_3 values in BIP report Content (please ensure you mask any confidential information): We have…
-
Convert Date to Mon-YY Format in Edit FormulaGood Day, Is there a way to convert date column to Mon-YY format in edit formula instead of using Column Properties > Data Format? Thank you.
-
How to check the which stage of TLSS workflow transaction got flagged incomplete?Hi Team, Could you please confirm Is it feasible to add a column to identify in which stage of TLSS workflow transaction got flagged as incomplete, for example while doi…
-
Issue and Resolutions from the Transaction ConsoleSummary: Hello, I was able to find the issue description and resolution information from the table "HRC_CONSOLE_FAULT_DETAILS_VL". However, I'm unable to connect the act…
-
sql query to get resignation approval statusSummary: Hello , I need to add column "pending with " in BIP if Resignation is pending for approval with Line Manager then "pending with "column should display "pending …
-
BIP reportsSummary Apply data restrictions on BIP reportsContent Hi , Is it possible to place restrictions on a BIP report output based on Role ? eg: I have a BIP report to display…
-
List of Approvers in Workflow NotifcationSummary: List of Approvers in Workflow Notification Content (required): Hi , I need a list of Approvers who are going to approve the transaction in below format. I have …
-
Is it possible to track how many employees clicked on a particular tile in the HCM Open Page - Eg: PSummary Is it possible to track how many employees clicked on a particular tile in the HCM Open Page - Eg: Person ManagementContent Hi Team, Is it possible to track how …