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
-
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… -
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…
-
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 …
-
Unable to pull E-Signature details from RequisitionSummary: I am looking to extract E-signature information, specifically the flow name, signature date and time, and the signer’s identity. My current approach joins IRC_A…
-
Unable to find field "What Influenced You to Apply" in HCM reportingRecruitment (ORC) Reporting Question: We need to include the field “What Influenced You to Apply” in an analysis (along with Candidate Identifier, Candidate Name, and Re…
-
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 …
-
Report shows no results for certain usersHello, We are facing an issue regarding the ability to view a report of the subject Area of Workforce Management - Checklist Real Time. Here is the report that we have c…
-
BICC PVO HcmApprovalsTaskP1 Missing Pending Approval Tasks (Learning Requests / HCM Approvals)Hello Team, We have a query from Oracle to retrieve approval details for a Learning Request. We are working in OBICC (Oracle Business Intelligence Cloud Connector Consol… -
Additional Information from Accrual Plan BalanceSummary Require Table and column name for additional information fieldContent Hi Team, I need to extract the additional information field description for the Absence Pla… -
What Caused the seeded Payroll Activity report to be updated on 11/27/2025?Summary: Want to understand why the seeded Payroll Activity Report has a Last Modified Date of 11/27/2025? and Owwner is System Account Content (please ensure you mask a…
-
Talent Review Meeting Real Time - In Holding Area (Yes/No) and Box Assignment Valuehttps://us.v-cdn.net/6034893/uploads/DTQXBK9OTENZ/talent-review-xml.txt Trying to recreate the Table view of the 9 Box in OTBI (My Client Groups > Talent Review > 3 Dots…
-
Unable to open the DM after UnachiveSummary: We successfully Unarchive Data model but unable to Open the Data Model Content (required): We Archive the Data Model from one instance and successfully Unarchiv…
-
sql query to get job level in oracle fusionSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Agents used to Schedule Analyses not working since 25DSince the 25D update, we can no longer edit or create new Agents for our Analyses. Everything was working normally before 25D. It looks like the update disabled the “Ena… -
Sql query or Table for Worksheet Display and Default Worksheet Display assigned to compensation planHi team, Sql query or Table where the information stored for Worksheet Display and Default Worksheet Display assigned to workforce compensation plan in HCM compensation …
-
Creating Multi sheet in Excel template based on Assignment action codeSummary: We are in need of generating multi sheets in which HIRE/REHIRE records are in one sheet and Assignment changes and Termination records are in different sheet(Wh…
-
Audit Report - On Folder Permissions ChangesSummary: Content (required): We have a requirement on Auditing folder Permissions Changes on any OTBI folders This report in theory needs to show us When and Who and Wha… -
Query to get Deleted users and rolesSummary Need query to get deleted users and role data from FusionContent Is there any table that will provide us the list of deleted users and roles from Fusion. We were…