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
-
Common Question: How to Ask for HelpSummary: How to ask for help in Reporting and Analytics for HCM Content: 1-Start by naming your subject area. If you don't know that, see: Common Question: In what parti… -
Common Question: How to Create a Table Style PromptSummary: The attached video shows how you can create a table style prompt. This is useful when you can't have a dashboard, but table prompts don't offer multi-select. Co…
-
Common Question: How to paste or copy an XMLSummaryExplains how to paste an XML ContentOften you may see sample reports in this forum, and this how you copy and paste the XML. 1-select new analysis 2-select a subj…
-
Common Question: How to Edit an Analysis in a DashboardSummary: Explains how to edit an existing analysis in a delivered dashboard. Content: In the relevant section on the xyz properties button, select Edit Analysis. Use Sav…
-
Common Question: In what particular subject area can I find these columns?https://community.oracle.com/customerconnect/discussion/40249/hcm-otbi-subject-areas-to-database-lineage-mapping-spreadsheet Typical Symptoms: you see columns on an appl…
-
OTBI Logical SQL complex query assembler - NOW 10 subject Areashttps://us.v-cdn.net/6034893/uploads/IRBUUHV044EZ/logical-sql-assembler-v5.xlsx Summary Now updated - Combine analyses from up to 10 different subject areas (V4) Content… -
OTBI Workforce Trend: For better performance, use equi-filter on Calendar Month End Date columnSummary: This is an announcement to provide guidance to improve response time of Workforce Trend reports and dashboards. Content (required): 1- Response time of reports … -
Common Question: I didn't get any rows in the subject area, what's wrong?Typical Symptoms: you selected columns and didn't see any results, or once you added certain column/s, then you didn't see any results. Content: Q: "I didn't get any row…
-
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… -
How to Link Payroll Details to Time Entry Data?Summary: Hii team, In the time entry details we are able to see the payroll linked data, like from frontend I can see this details I need to fetch this Earned date, valu… -
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…
-
How to hide Schedule option from BI Reports for ManagersSummary: We created a one of the report and provided folder read access to manager role, however - customer wanted to restrict the managers to stop schedule this report.…
-
Hide Schedule and Job option from reportSummary: Hide Schedule and Job option from report Content (please ensure you mask any confidential information): Hello experts, does anyone know how to hide the followin… -
Assignment Category was Limbo (PRN) for entire yearSummary: I have a requirement to identify employees with an Assignment Category of Limbo (PRN) throughout the entire year 2025 or until their termination date in 2025. I…
-
Changes to the Seeded BIP Template for ManageDORReport are not reflecting in the notificaitonSummary: I made copy of the default template for the ManageDORReport and uploaded as a new DEFAULT template for the report in the custom folder. But the changes are not …
-
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…
-
Address Change Notification Not Reflecting the Changes in the NotificationSummary: New fields have been added to the Address Change Report (Report Name: PersonalInformation_AddressReport). While the changes are being pulled into the report cor…
-
Job Offer DFF values not appearing in OTBISummary: We are trying to pull a Job Offer Descriptive Flexfields (DFFs) OTBI report for India, the values are appearing blank. Interestingly, we can see the correct val…
-
OTBI Analysis Error: Subquery contains too many values for the IN predicate.Summary State: HY000. Code: 42029. [nQSError: 42029] Subquery contains too many values for the IN predicate. (HY000)Content Hi, I have a OTBI report which needs to pull … -
How to get ESS job schedule end date for all scheduled ESS JobsSummary: How to get ESS job schedule end date for all scheduled ESS Jobs Content (please ensure you mask any confidential information): Hi Team, Greetings! We have multi… -
Syntax Error in OTBI AnalysisSummary: Syntax Error in OTBI Analysis Content (please ensure you mask any confidential information): Hi, I'm trying to create a new OTBI Analysis. I selected "Workforce…
-
Learning Records Real Time Subject AreaHi everyone, I am using the OTBI – Learning Records Real Time Subject Area to build an OTBI report and I am experiencing an unexpected behavior after updating the title …
-
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…
-
Link between OTL time Entries with Element Entries or Calculation cardsContent Hi All, We enter data in OTL and transfer batch. Then calculation cards and Element entries will be created. We need SQL Query/OTBI link between OTL time entries…
-
Analysis - subject area : “Compensation - Workforce compensation Real Time” -Summary:I’ve created a analysis with the subject area : “Compensation - Workforce compensation Real Time” to retrieve compensation worksheet information. The amount disp…
-
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…
-
Derived Standard Working Hours - SQLHi all, we're looking to add the following field to a SQL built report using BIP. 'Derived Standard Working Hours' (we can see this in Work Relationship - Assignment Det…
-
Call a bi publisher report from redwood pageSummary: Hello, Recently we have transformed absence standard page in fusion to redwood, can I call a custom BI Publisher report from this page and pass specific paramet…
-
Error while downloading BIP Report in Excel FormatSummary: We are getting error while run a BIP report and try to export in Excel and other formats. When we do the same in Interactive mode no error is coming IO Exceptio…
-
Catalog object privilege validation failed for userSummary: Catalog object privilege validation failed for user Content (please ensure you mask any confidential information): Have downloaded a seeded report for HCM. When…
-
"Workforce Profiles - Person Profile Real Time" no Legal employer dataSummary: Hello, Why is there no legal employer data in the "Workforce Profiles - Person Profile Real Time" subject area? All the other usual data are there (business uni…
-
Modify New Hire State Report Template for USSummary: We have a requirement to include few extra columns in the delivered New Hire State Report for US. I would like to understand if we are allowed to that? Previous…
-
Changes made to a record are not reflected in custom report immediatelyHello Team, We created a custom RTF report that shows employee contract information for a client. When we update a DFF value in an employee’s contract, the change doesn’…
-
report on pending life eventsSummary: Hi Team, We are looking for report that contains all employees pending life events. Please share inputs Thanks, Pranay Content (please ensure you mask any confi…
-
BICC PVOs with Offer DFFsSummary: We're looking to extract the Offer DFFs from HCM into Incorta, but are not able to find them within any of the PVOs. Has anyone successfully done this? If so, p…
-
How do I link fa_fusion_soainfra.wftask with HRA_EVAL_STEPS?We have evaluation steps where users go through workflow tasks. I have the evaluation steps and the comments from the workflow tasks. I am unable to find suitable column…
-
Sql query or Table to fetch Compensation Worksheet data in BIP report based on securitySummary: Sql query or Table to fetch Compensation Worksheet data in BIP report based on the roles assigned to the user. Content (please ensure you mask any confidential …