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
-
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. https://us.v-cdn.net/6034…
-
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…
-
Table to query access groupSummary: Hi the team, In Oracle learning cloud we can link Global Access Group at Course and Offering level. We would like to run an analysis to see which learning conte…
-
Missing PII Candidate Report (OTBI)Summary: We are trying to create a candidate level report based the current phase, current state, and the DoB and/NID is null. The purpose is for the recruiters to be ab…
-
Job Offer Facts in OTBI Not VisibleIn OTBI, Recruiting - Recruiting Real Time subject area, the Number of Job Offers measure in Facts - Job Offer is returning 0, with no other fields or filters selected. …
-
Why is per_person_secured_list_v secure view not working on AORs in custom BI Report?Summary: Why is per_person_secured_list_v secure view not working on AORs in custom BI Report? I am running my custom report (containing the per_person_secured_list_v) b… -
We have a requirement to audit changes to folder permissions for custom folders in Reports and AnalySummary: We have a requirement to audit changes to folder permissions for custom folders in Reports and Analytics. Is there a way to get these details? Content (please e…
-
Bursting Report for Line Managers - Future Hire Notifications (No Data Returned)Summary: Hi Community, I'm developing a bursting report in BI Publisher that will notify line managers about employees starting on their hire date. The report should run… -
Getting error when trying to save OTBI reportI added an additional Legal Employer to our filter on a OTBI report and wanted to Save it, but I keep getting the following error. I even tried to do a Save As and I get… -
Oracle BI Report bursting throwing errorHi Team, I created 5 reports and all 5 are scheduled in Prod. Only 1 report is getting failed while bursting. Getting below error. Detail Message: ::JOB_WAIT_TIME_SECOND…
-
How do I know which employees run a custom report?Summary: Content (please ensure you mask any confidential information): I'd like to know if Oracle logs BIP report executions that are not scheduled Version (include the…
-
The Vietnamese Translation is not working on the customized BI ReportSummary: Hi, We are in 25D. When we try to Customize the seeded BIP Report, all the translations are working expect Vietnamese language. When I try the Vietnamese langua…