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
-
Getting duplicate record in OTBI reportSummary: Content (required): Hi Expert, We have built an OTBI report for talent meetings and when we are running the report there is a record that is coming multiple tim… -
Need a sample SQL Data model using DFF and EFF Flex FieldsSummary Need a sample SQL Data model using DFF and EFF Flex FieldsContent We have several EFF and DFF fields were created in Oracle HCM. Can someone share a sample data … -
Connect to HCM Database through MiddlewareSummary: Just curious if I can connect to the HCM database through anything other than the cloud url Content (required): Hello, I am creating an integration using middle… -
Risk/Impact columns pulls in one value and one blank value causing duplicate rows in OTBI?Summary: Subject Area: Workforce Profiles - Person Profile Real Time Columns: "- Risk of Loss"."Impact of Loss", "- Risk of Loss"."Risk of Loss" Content (required): Hi A…
-
SQL Query issue - Query not returning data for a particular column(attribute)Summary: Hi Everyone, We have a SQL query issue, there is a query which is not returning any value for a particular column(attribute) only for a single user in productio…
-
Is there a way to enter a prompt date and show this date in a column within the report?Summary: Enter an effective date of 01/05/2023 in a prompt Display this date within a column in the output of the report Content (required): If I user enters a prompt ef…
-
Copy and Modify the Seeded Recruit to Hire DashboardSummary: We want to make modifications to the analysis tied seeded Recruit To Hire Dashboard. I've read various posts and documentation on how to achieve this, but none …
-
BIP report queriesSummary: Hi Team, Can we have 2 filters in the BIP report : 1 that selects the legal entity or BU then 2 - only show the departments which is in that BU for selection. K… -
Pulling Comments from Resignation/Termination ActionSummary: Content (required): We are implementing employee self-service and manager self-service on submitting resignation/termination. There is an Comments and Attachmen…
-
Dynamic Regular Date Earned Formula RequiredSummary: Need a formula to get the last two regular dates earned to update each month. Content (required): I have a Payroll Net Pay Variance report which compares the Ne…
-
Annual Leave Buy / Sell - ReportSummary: A Report to identify those Employees who Bought / Sold Annual Leaves Content (required): Hi, Can you please help me to develop a report which will give details … -
HR self-service reporting in Oracle HCMSummary: Content (required): Hello everyone, I wanted to ask about the possibility to have HR self-service reporting in Oracle HCM, i.e. the possibility for HR users to … -
Deeplinks in OTBI and BI ReportsContent Is there a way we can use the Deeplinks in the OTBI and BI reports dynamically. Suppose I have a column for 'Person Number' and I click on a particular person nu… -
Properties Attribute "Read Only" - what does it do?Summary: Properties dialog box -> Attributes section -> Read Only Content (required): Hi All, If I adjust the attributes section to "read only" in the properties dialog …
-
Is there a way to join these 2 subject areas?Summary: Is there a way to join these 2 subject areas: Human Capital Management – Approval Notification and Archive Real Time & Workforce Management – Person Real Time. …
-
Is there a standard report for Balance Adjustments?Summary: Specifically, we are looking for a way to report on failed Balance Adjustments. At year end, we frequently mass load Balance Adjustments. And always a few fail …
-
Bursting Report outputSummary: Bursting Email Contains the Sql Query output in the Message Body. How to Remove the Sql Query Output line from the Message Body Content (required): Version (inc… -
Team Time Card BIP Query for Team information and approval status and Overtime Information.Summary: Need SQL Query for the Manager can view his team information of time and overtime information. Content (required): Version (include the version you are using, i…
-
Parameter not working when embedding OTBI AnalysisSummary: Embedded an analysis on HCM page but it seems that the binding variable is not being received by the analysis because the report is not being filtered Content (…
-
Fusion Global HR: BICC PVO Details Needed for HR DataSummary: Fusion Global HR: BICC PVO Details needed for below information. what is the PVO to get seniority dates (Table per_seniority_dates_f) ? column ****_ATRRIBUTE_NU…
-
1How to upload BICC extract files to UCM custom foldersSummary: We have a requirement to upload BICC extracts to UCM custom folder. By default, the files are getting uploaded to OBIAImport security group. Please help us in s…
-
Query to extract employee Salary SourceSystemId and SourceSystemOwnerSummary: Content (required): Hello experts, please could you share the SQL query to extract employee Salary SourceSystemId and SourceSystemOwner? Thanks in advance for y… -
Why OTBI Analysis not giving correct manager details in output ?Summary: OTBI analysis not giving correct output in one environment but working on other environment Subject Area : Workforce Management - Worker Assignment Real Time Co… -
Unable to create a new Application Page Entry for a BI ReportSummary: Unable to create a new Application Page Entry for a BI Report Content (required): We are trying to create a page entry to open a BI Report. Used the Application…
-
Table name which stores start date and end date in individual compensation planSummary: Hi Everyone! I am looking for the table name which stores start date and end date in the individual compensation plan. I tried - cmp_plans_vl, cmp_components_vl…
-
Seeing Data Across Different EnvironmentsSummary: Viewing data across different environments inconsistent. Content (required): When I run a report, we created in Dev11, there some data that I don't see in our U… -
Seeded line manager dashboards for executive leadershipSummary Dashboards for executive leadershipContent We have made a copy the of seeded line manager dashboard and modified it to work with our system configuration and req… -
How to get Home email and business email addresses in OTBI reportingSummary: How to get Home email and business email addresses in OTBI reporting? Content (required): We are trying to get employees home email and business email addresses…
-
COUNT IF in a columnSummary: Replicate the COUNT IF condition in a column Content (required): Hi All, I need to replicate this KPI in a column of analysis: In details, I don't find the corr…
-
Transaction Detail - TerminationSummary: Terminations used to pick up in our transaction detail report but it seem to had stopped working from 22D. Content (required): Is there another way to create a …