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
-
Scheduled Report randomly times out.Summary: Hi, We have a data model report that pulls related Personal, Assignment, Comp and Payroll data for all Active employees based on an effective date parameter, th… -
BIP Query Job Roles and the roles assigned to themSummary: I'm trying to create a BIP query that shows me Job Roles and the roles assigned to them. I tried to create the report, but I can only get it to this point: sele… -
OTBI filter show no dataSummary: Hello experts, we have a report for recruiting requisitions, but when trying to search in the values we get no data.. the list of values: SELECT DISTINCT IRB.RE… -
Performance OTBI to extract Task Status, Section Names, Rating LevelsDears, we have a requirement to build an Analysis to extract performance document task status and ratings given to each document section. To do so we are crossing "Workf…
-
Date format in OTBI PromptSummary: How to change prompt values from datetime to date. Instead of "11/12/2024 00:00:00" I want "11/12/2024" Content (please ensure you mask any confidential informa…
-
Is it possible to combine one Finance subject area and also HCM subject area in a single OTBI reportSummary: Is it possible to combine one Finance related subject area and one HCM related subject area in a single OTBI report. Content (please ensure you mask any confide…
-
I would like a way to report that includes the following information in one report:Approval Status: Details of the goals. Pending approvals indicating whether they are with the HR manager or department. Goal details before HR approval: To allow review …
-
What can be the sql query to determine the person address subject to LDG address configuration?What can be the sql query to determine the person address which satisfies the condition of having all the mandatory address field by the person LDG address configuration…
-
Cancel scheduled reports in oracle fusionSummary: Cancel scheduled reports in oracle fusion Content (please ensure you mask any confidential information): Version (include the version you are using, if applicab…
-
How to get Month name as abbrevation concat with year in OTBIHi Experts, Can someone please help me how can we get Month name Concat with year in the same column in OTBI. We have a requirement to show the date's in the below scree…
-
SQL query to retrieve Division Name and Manager division display nameSummary: Content (please ensure you mask any confidential information): Hello experts, I need to extract the Manager Division full name field and the Division name as we… -
How do I join PersonAM_PersonAddressPVO with PersonPVO in BICC extracts?How do I join PersonAM_PersonAddressPVO with PersonPVO in BICC extracts? There is no column with matching values.
-
Accrual balance report/ how to use months in column and years in rowsI'm building an OTBI report to based on Accrual Real time subject area, with the goal of displaying accrual balances. To have a report that makes sense I used Pivot Tabl… -
Is it possible to get 'Last Update By' from Recruiting Subject Area in OTBISummary: We have a OTBI Reporting Requirement to display 'Last Update By' for a job application. I can see that 'Job Application Last Update Date' is available under Rec…
-
Oracle fusion hcm OTBI Subject area for person extra infoSummary: I am looking for subject area in oracle fusion HCM that store person extra information. (i.e. Region (PEI_INFORMATION1), Capability (PEI_INFORMATION2), Service …
-
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 …
-
Termination Headcount from Trend real Time not giving correct headcountSummary: I'm working on an OTBI analysis to calculate and display the turnover percentage for leavers over the last two years as a line graph. The objective is to show t…
-
Certification: Retrive attachments information with OTBI or BI PublisherHello, our customer asks to retrive the information associated to the attachments section of certifications (URL and PDF), is it possible? if so, how? Any advice? Thank … -
How to adjust the alignment of the bar graph for charts function in RTF Template of BIPSummary: Hi Team, The goal is to display a bar graph in RTF Template with question vs ratings. How to adjust the alignment of the bar graph for charts function in RTF Te…
-
SQL query to find the Users that has role provisioned by an role mappingI'm trying to create a query that return the MAPPING_NAME from the PER_ROLE_MAPPINGS table and the USER_ID from the PER_USER_ROLES table to know which USER_ID is associa… -
'Ethnicity - All' Headcount for US legislation to include 'Two or more Races'Summary: Based on the current functionality the only way to report on employee headcount by ethnicity is to use 'Ethnicity' which selects a primary ethnicity for each em… -
Table to get the Time Card Required field in Payroll Relationship page.Summary: We have a requirement to pull the "Time Card Required" field on the Payroll Relationship page. But we are unable to get the table. Please help me with the table…
-
user email ID associated with the user name listed in the licenses usage reportsSummary: Hi, Anyone can help me to get the table and column name for the below screenshot im attaching. actually im working on active user role report, i need this colum…
-
CertificationSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Some of reports when we try to download the report we are getting processing errorSummary: HI Team, Some of reports when we try to download the report we are getting processing error . Export>Data>CSV or Excel Content (please ensure you mask any confi… -
Query to get Position History along with Changed Attributes.Summary : I have a requirement to find out Position History details along with the changed attributes as shown in screenshot below. If anyone have query for this kindly …
-
Is it possible for Oracle Tables for all HCM transactions including archived transactionsSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
I assigned the cost center code at the Person Costing level to an Assignment.Summary: I assigned the cost center code at the Person Costing level to an Assignment. I need to pull the OTBI report with the effective start date and End date. Can I k…
-
Adding a Common Sequence to Filename in Bursting Report Triggered via ESS JobHi everyone, I'm working on a bursting report in Oracle that generates filenames with a date and timestamp, like Grade_01012024_928282.csv. I have two different reports …
-
Need to add Adjustments and Absences in two different columns. Please hep me with the querySummary: Hi Folks, I need to add Adjustments in one column and Absences in one column in the report in Absence Management. Please help me with the query. Content (please…