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 changes by1 day while formattingSummary: Hi, I am using Oracle template builder for one of my reports which has date column, when I apply date formatting date changes by one day (example: 4712-12-31 ch… -
Anytime Feedback Report template - need helpSummary: Need help on this: When I use the Subject Are: Work Profiles - Feedback Notes by Recipient Real Time, the report is fetching all data from feedback and meeting …
-
Redirection link to a report using environment variableSummary: #{header["host"]} variable in page entry Static URL no longer valid Content (please ensure you mask any confidential information): Hello, I used to use #{header…
-
Are there User Entity for Individual Compensation Plan In HCM ExtractSummary: Are there User Entity for Individual Compensation Plan In HCM Extract Content (please ensure you mask any confidential information): Version (include the versio… -
How to report on the due date for Journey tasks in OTBI?Summary: We are looking to create an analysis in OTBI to pull a list of individuals who have overdue tasks from their onboarding journey. We are using the Workforce Mana… -
BIP report to get the approval status with history and attachments for Leave encashment, salary trasSummary: Hi Experts Could you please help me with the BIP report sql query on how to get the approval status for DOR requests like Leave encashment, salary transfer lett…
-
Need table information to get below fields from journey template pageSummary: we need table information to get below fields. Restrict assigning journey if its in progress Use assignment identifier associated with assigned journey Navigati…
-
Retrieve User ListSummary: I would like to create a BIP report to retrieve a list of user information. Content (please ensure you mask any confidential information): Please let me know wh…
-
Enterable Calculation Values on Calculation Cards 'value' Field DBI for Fast Formula or TablesSummary: Hi There, looking for Enterable Calculation Values on Calculation Cards 'value' Field DBI for Fast Formula or Tables Content (please ensure you mask any confide…
-
OTBI report is generating single row output when language preference is changedSummary: OTBI report is generating single row output when language preference is changed and when language preference is set to English, then output looks good and otbi …
-
OTBI – Workforce Profiles: Person Profile Real Time pulling deleted competenciesSummary: I have a reporting requirement to identify the competencies workers have entered on their Person Profile, including workers who have not entered any competencie…
-
missing national identifierSummary: Technical user cannot extract National Identifier (Codice Fiscale) from PER_NATIONAL_IDENTIFIERS despite ORA_FND_INTEGRATION_SPECIALIST_JOB + custom role duties…
-
Regarding - Alerts Failure during Bulk LoadSummary: We have implemented multiple custom BI Publisher–based alerts that are triggered on specific business scenarios and scoped to particular Business Units. During …
-
I need to build an analysis that shows the headcount for the logged-in manager for the last 5 years.Summary: I need to build an analysis that shows the headcount for the logged-in manager for the last 5 years. I created the analysis using the Workforce Management – Wor…
-
ORA-01427: single-row subquery returns more than one row ERRORSummary: Have a Payroll Config workbook and returning error. We can't seem to identify the issue. it exists in one of the 3 attached data sets. Version (include the vers…
-
Discrepancy in Actual Effort Displayed on Screen vs. CertificateHello, I noticed an inconsistency in the Oracle Fusion Cloud Learning system regarding the “Actual Effort” metric after completing training. On the learning screen, the …
-
Query to fetch "Issue Description" and "Resolution" for failed transactions.We had a requirement to display issue description and resolution for failed transaction. When we use table hrc_console_fault_details_vl hcfdv(for description and resolut…
-
Is there any way to track Tile clicks by Users in HCM ?Hello Experts, Has anyone implemented or come across a supported method in Oracle Fusion HCM to track how often Home page tiles (e.g. Team Activity center) are accessed …
-
Error while copying the Payment HCM extract.Summary: We have a requirement to add some additional information under standard Paycheque report.For this purpose,I am trying to customize the "Payment" HCM extract def…
-
HCM Position HierarchySummary: Hi Team, We have a requirement to develop a new report as like "HCM Position Hierarchy" standard report, so please share code file or file path and report name …
-
BPM: Is there a way to trigger the escalation notification at a certain time of the day (eg. 9 am) ?Summary: BPM: Is there a way to trigger the escalation notification at a certain time of the day (eg. 9 am) irrespective of the time of submission of the request Content…
-
Looking for report that shows state from tax jurisdictions cardSummary: We have run our first payrolls with USOPTE and are running into a case with tax jurisdiction cards having the wrong state in a particular circumstance. We want …
-
I am getting this error in bursting code ORA-01489: result of string concatenation is too long".Summary: I am getting this error in bursting code ORA-01489: result of string concatenation is too long". Content (please ensure you mask any confidential information): …
-
BIP Tables for Calendar/Calendar Events linkage with EmployeeSummary: BIP Tables for Calendar/Calendar Events linkage with Employee Content (please ensure you mask any confidential information): Hello, from My Client Groups > Orga…
-
Report to get the User login and logout time in oracle fusion HCM instance.We are searching for any kind of report that will show the information or details about the users login and logout time to the Oracle fusion HCM instance. Could you plea…
-
Table to identify password updateSummary: Is there a table that tracks the password updates? We have a scenario where the password of a service account stopped working all of a sudden. I have run the pa… -
What's wrong in this bursting?Summary: Content (please ensure you mask any confidential information): I have this template and this bursting query: Report works fine: Why do I get an empty output whe… -
Issue Accessing Manage Users in Oracle Fusion Data Intelligence – MFA Redirect to OCI ConsoleSummary: We need to access Manage Users in Oracle Fusion Data Intelligence in order to add users to groups. However, when attempting to access Manage Users, the system r…
-
sql to fetch payroll process having ui_task_status = 'COR_FLOWS'Summary: Parameter having p_start_date , p_end_date, p_payroll_name based on this parameter will identify period name and start_date and end_date from pay_period table. … -
Query to fetch Cost Center Details which are not mapped at Department LevelSummary: i need a query to fetch all cost center which are not mapped to the department. If anyone have SQL query please help me. Version (include the version you are us…