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
-
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…
-
Oracle BI Cloud Connector (BICC) to Flexfields data from HCMSummary: We are using Oracle BI Cloud Connector (BICC) to extract data from HCM using a third party tool (FIvetran). However, we have a need for a couple columns of data… -
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 to call dbms_crypto package from Oracle BI publisherWe have a requirement to call dbms_crypto.encrypt package from BI publisher to encrypt sensitive data at the column level. So i have 2 questions: When we select Data Sou…
-
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…
-
Query optimization for HCM audit report with UNION ALL + UNPIVOT - need hints/index strategySummary: My audit trail query (HCM objects with UNION ALL for 30+ audit tables) was taking 12 minutes with left join on tables per_all_assignments_m and per_all_people_f…
-
Which database table to use for 'Privileges required for Work Area Access' in Simulate NavigatorSummary: We have a business requirement to create a report that should show privileges required to access each work area along with task panel item names which are visib…
-
Changes to ManagerDORReport not reflected in notification.I am having an issue customising the ManageDORReport template. I have saved a copy of both the report and data model into the custom folder, removed the fields I don't w… -
OTBI - Minimum Proficiency LevelHello, Please note, in our configuration, each competency in job profile has a minimum proficiency level. In OTBI Analysis, under the "Workforce Profiles - Model Profile…
-
Explain Differences in Payroll Balance Core Assignment and Core Relationship RunsSummary: When reporting using Subject Area Payroll - Payroll Balances Real Time, could an expert please explain the differences in the following Base Dimensions: Core As…
-
What role is required to get read and execute access of BIP?Summary: What role is required to get read and execute access of BIP? Below tables are being used in BIP pay_dir_cards_f pdc ,pay_dir_card_definitions_vl ,pay_dir_card_c…
-
Unable to get data in HCM group value sets when passing username of user by using fnd_globalSummary: I am not getting any data when adding the following line to the query but I can get the data when I hard code the username. U.username=FND_GLOBAL.USER_NAME Cont…