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
-
Date parameter is throwing an errorSummary: A date value is stored in the screen_entry_value field. I created two date parameters (p_week_start, p_week_end). I am trying to use the screen_entry_value in m… -
How to apply "Group By" Condition on a column - in OTBI Analyis?Content Hello Everyone, I have a requirement to apply "Group By" condition on OTBI analysis. I am applying this condition in under Advanced tab - Advanced SQL Clauses. B… -
SQL to get number of Grades in a Grade laddersSummary: I need SQL to get number of grades contains in all the grade ladders that organization is having. If anyone having it please share Content (please ensure you ma… -
Facing issue in RTF template(This exists with maximum width.)Summary: Trying to add two new extra fields in the existing RTF template is giving an error. (Error: This exceeds the maximum width.) Content (please ensure you mask any…
-
Analytics for scmSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Need help SQL to pull Previous work schedules and present Work schedules of employeesSummary: I am currently working on a project that requires retrieving both the previous and current work schedules for employees from our database. I would appreciate yo…
-
For Performance documents, is there a report area available to show completion date for tasksSummary: We need a report to identify the date each of the tasks within the process flow of our performance documents are completed. If they are not complete, we would e…
-
make etext template Tab delimitedSummary I need to make a report tab delimited, however I cannot seem to accomplish with etext template.Content I found this, but can't seem to apply it. I guess I am not…
-
Looking for advice regarding creation of a report to load details into Costing for PersonsSummary: We currently have a report in place which gets run daily to load information via HDL to load into the Costing for Persons. It has been made aware the report is …
-
Way to hide hyperlink on Workflow Notification / BIP RTF template based on Security Role?Summary: My customer wants to have me hide a "View Attachments" hyperlink on a DoR notification (BI Pub - RTF template) based on specific AoR role. I don't see how to pi…
-
BI Publisher Desktop 64 Template stop working and Publisher Menu does not show in MS WordSummary: BI Publisher Desktop 64 Template stop working and Publisher Menu does not show in MS Word Content (please ensure you mask any confidential information): BIPubli…
-
Experience with Fivetran BICC integration with Oracle Cloud HCMWe are looking for an integration tool to support us with the data ingestion from HCM to support our analytics team to extract and analyze HR data. I want to hear your f… -
Can conditional formatting be applied to the total cell in BIP pivot layout?Summary: Can conditional formatting be applied to the total cell in BIP pivot layout? Content (please ensure you mask any confidential information): Hi Experts, I could … -
People Group Segments Subject AreaSummary People Group Segments Subject AreaContent Hi All, In which subject Area I can find assignment people group segments while creating analysis ? Thanks.
-
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…
-
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 31 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…