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
-
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 …
-
How should I calculate the employee's seniority?Hi, I have a query where I calculate the seniority of the employee and I want to sort by the highest seniority. The query works like this if the 'Seniority Reference Dat… -
How to sort by timestamp in BIP TemplateSummary: Is it possible to sort all the four tiles (Initiated By, Assigned To, Approved By and FYI) by timestamp? Attached is the screenshot (Workflow transaction detail…
-
how do I define datesSummary: I am trying to fun an agent weekly and want to have it select a date range Content (required): the job will run every Friday morning and needs to include employ…
-
Open/filled position management reportingSummary Delivered Position Incumbents report returns terminated employeesContent Hello - There's a requirement to create a report of all current filled/open positions wi…
-
Any Suggestions of how to improve Web Clock Custom Dashboard data reflection earlier.Summary: We are facing a time-lapse on Custom Dashboard which has reflected the data in delay some time especially in web clock in and out table records. we need a worka…
-
Show timestamp in human readable format while respecting time zoneSummary: Display the date and time from the last_connect column in the fnd_sessions table in a human readable format. The time should also respect British Summer Time / …
-
OTBI:Market Data: No data in report when columns from Global HR dimensions are usedSummary: Guidance to ensure that Market Data reports return data when Global HR dimensions are used. Content (required): 1- Subject Area: "Compensation - Market Data Rea… -
Combining fields into one field or cell in OTBIIs it possible to combine all the columns and rows (per person) under Question Text, Response Answer and Response Text in one field? From this To this
-
Need to know Progress Summary Reason Table/Subject area nameSummary: Need to know Progress Summary Reason Table/Subject area name Content (required): We are unable to find Progress Summary Reason field either in the Recruiting - …
-
Need help - Need a payroll report for Element vs BalancesSummary: We need to create a report to include Element names which are feeding a particular Payroll Balance. We tried to do it using Payroll Subject Areas but it did not… -
SQL query to see the dependents for an employee who have pending action items in benefitsHi Experts, Can anyone please share an SQL that can show me the list of all dependents for an employee who have a pending action in the benefit plans? Say for a dependen… -
Infolet Report Failing / Erroring with Direct and Indirect Reporting LineHi all, I'm hoping someone can tell me if what I'm trying to achieve here is possible. The report itself should look at anyone who has learning that's due and then apply…
-
I want to restrict the values for prompt in OTBI reports.Summary: I had applied a prompt for customer contract name in OTBI report, it is fetching all the values present in that column but I need to fetch only those values tha…
-
how to change columns as rows in below requireimentSummary: Hi Team, In OTBI how change annual accrual and carry over coulmn into row we need . Any one help me on ? Content (required): Version (include the version you ar… -
How to change the date format in OTBI analysisSummary: I need to change the date format of OTBI analysis into mm/dd/yyyy format. I tried to do it using the column properties following below post. But it's showing 00…
-
We need Work Schedule Name, Work schedule start date, Work schedule End date on OTBISummary: Hi Team, we looking below columns in OTBI subject areas May i know which subject area available? Thanks, Ajay Content (required): UI: Version (include the versi…
-
Phase Sequence Number doesn't match CSPSummary: Phase Sequence Number doesn't align with the CSP we've defined. Content (required): We have defined candidate selection phases for our job application progressi… -
OTBI Dashboard ErrorSummary: Error Codes: OAMP2OPY:U9KP7Q94 Path not found - Check the input path entered. Content (required): When running the dashboard, error appears. This only happens t…