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
-
How to fetch the direct and indirect report details in OTBI based on manager details parameterSummary How to fetch the direct and indirect report details in OTBI based on manager details parameterContent Hi, We are in REL 13 20D. I am working on the Performance r… -
Compensation Details (Top of Stack) when End DatedSummary: Hi - We are looking to create a report where we are able to audit active employees where their salary was incorrectly end dated. The problem is that when the sa…
-
Need help on arrears balance ReportSummary: Content (required): Hello, We are trying build a custom arrears balance for both active and terminated employees. We do not have anything available for terminat… -
Offering Details report: Booked SeatsIs there any tables which shows the booked seats and location details for ILT, Blended type learning item (offering)? Tried to find in WLF_LI_CLASSES_F but I can't get t…
-
table to pull the error details from transaction console.Summary: Hi All, I'm trying to build a report and looking to pull the error details from transaction console. I tried searching tables but I'm not getting the info, can …
-
How can I get an interaction to filter on 2 columns at once?Summary: I have created a graph to show male/female by Grade level. I created an interaction to drill down to a report, however the interaction is only filtering on eith…
-
Report to get the list of employees with multiple active relationshipsSummary: Report to get the list of employees with multiple active relationships Content (required): Hi Team, Greetings! With Global Transfer- there are some cases observ… -
Is there a way to encrypt the scheduled reports?Summary: Is there a way to encrypt the scheduled reports Content (required): We are looking into scheduling reports but we need to make sure there is an encryption in pl… -
SQL query to fetch element status processing rule of a element.Summary: We need a SQL query to fetch the element status processing rule of an element. Version (include the version you are using, if applicable): 23A
-
BI Publisher - RTF template - write a numeric value in lettersSummary Need to write in letters a numeric value from a BIP fieldContent Hello, I am creating a RTF template that I want to display as a report in BI Publisher. In this …
-
Payroll Element and Related Elements InformationSummary: Payroll Element and Related Elements Information Content (required): In the Payroll Element screen we have Related Elements. We need to know in which table/subj…
-
OTBI report run for some users onlyDear , we have custom otbi report which is showing absences and working fine for all users but suddenly it is works for some users and not working for some users can any… -
SQL for Element Status Processing RulesSummary SQL for Element Status Processing RulesContent We are looking for a SQL to display element status processing rules where we attach the element to a fast formula … -
Bursting Query table from the reportsSummary: Bursting Query table from the reports Content (required): Hi Team, Greetings! Is there any table(s) which holds the queries included in the bursting query in th…
-
Best practice for reporting on incomplete allocated checklists?Summary: Hi All, Does anyone have any "best practices" for reporting on incomplete allocated checklists? We have a business case to report on number of incomplete checkl…
-
Extract information about the Job Board eQuest in ORCSummary: Content (required): Hello everyone, We are having problems extracting information regarding the publication of a job requisition. In particular, in addition to …
-
Report on Training Hours for each learnerSummary: Hi all, We are trying to report on each learner's hours during one year - has anybody been successful in building this in OTBI? Thank you in advance for your re…
-
CAGR(Compound Annual Growth Rate) Calculation in OTBISummary: Creating an OTBI analysis to calculate CAGR of the joiners in my org in last 3 years. Content (required): I am trying to calculate CAGR of the joiners in my org…
-
ORA-01722 Invalid NumberSummary: Content (required): A report that used to work is now giving us an error ORA-01722: invalid number. Version (include the version you are using, if applicable): …
-
BI Tables for compensation planSummary: Content (required): Hello experts, do you know which BI tables allows me to extract workforce compensation plan data? Thanks in advance for your time! Kind Rega… -
Is it possible to retrieve compensation component amounts entered in closed compensation campaigns?Summary: Content (required): Hello experts, our customer wants to add in compensation plan some columns retrieving compensation amounts entered in past campaigns. Is it …
-
How to generate employee listing report in Oracle fusion?Summary: Content (required): Employee Listing report Version (include the version you are using, if applicable): Oracle Fusion Cloud Applications 23A (11.13.23.01.0) Cod…
-
Function to convert accented characters to their plain ascii equivalents in BI reportSummary: Function to convert accented characters to their plain ascii equivalents in BI report Content (required): Function to convert accented characters to their plain…
-
OTBI->Cloud Benefits Sample for 401k, 403B, etc. Enrollments by Gender, Ethnicity, Participant CostsSummary: This is part of a series of sample reports created by Oracle BI and HCM Product Management. You can copy the setup for this report and add it to your Oracle HCM… -
Can the parameter affect both the row and the column in the Matrix report prepared from the analysisI have a matrix report that I use on the Dashboard screen, and the column information consists of job name information. The row information is also from the locations. a… -
Error Code U9KP7Q94Summary: Path not found - Check input path entered Error Codes: U9KP7Q94 Content (required): Hi All, Has anyone run into this problem before? We archived and unarchived …
-
Best practices for Journeys reporting in Workforce Management - Checklist Real Time subject area?Summary: Subject Area: Workforce Management - Checklist Real Time Need: Leverage best reporting practices to drive adoption rates and system monitoring for allocated jou…
-
Subject Area for Override LocationSummary: We have a requirement to query 4 different types of address for employees. HOME, US Resident Tax, Work Location and Override Location addresses. I am able to qu… -
OTBI Analysis - No results using subject area "Workforce Management - Worker Assignment Real Time"Summary: No results when creating simple analysis in OTBI using the subject area "Workforce Management - Worker Assignment Real Time" Content (required): Hello, I tried …
-
can we create report on the missing candidates (unconfirmed candidates).There are some candidates who were not able to submit there job applications because of issues with being able to access the assessment. I need to check if we can create…