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
-
Output File Names | BI Reports and Payroll FlowsContent Hi, We've had a requirement where the users wanted to generate the file output via Payroll Flows rather than accessing it via a link / BI catalog path. We've man… -
Run Employee Active Payroll Balance report for All Balance levelsSummary Way to run Employee Active Payroll Balance report for All Balance levelsContent Is there any way to run the Employee Active Payroll Balance report for All Balanc… -
RTF Template: Achieve Distinct Values in RTF TemplateSummary: RTF Template: Achieve Distinct Values in RTF Template Content (please ensure you mask any confidential information): Hi Team, I have an extract where location a…
-
Required table for "Direct Apply" section under the task "Recruiting Category Enablement"Summary: Hi Team, We are unable to find the table for the field "Direct Apply" under the setup task Recruiting Category Enablement. The main table are IRC_TP_PARTNERS, I…
-
How to fetch Audit reports under tools or how to schedule the audit report and get data on a dailySummary: Hi Team, I need to fetch audit data, I am able to export the data from the audit report under the tools, how to schedule this report on a daily basis or help me…
-
OTBI column formula help - change days to working daysIn my report I need the following column formula to calculate 5 working days (not 5 days as it does now) and leave out Saturdays and Sundays. Any help would be great. CA…
-
Percentage of Employee With and Without Goals not showing properly in columnsSummary: Hello again, I need help to check my case statements. The % of employees with and without goals are not reflecting properly. CASE WHEN "Workforce Goals - Goal S…
-
How can we display different Infolet tiles based on each page?Summary: Is it possible to display difference Infolet tiles based on page (e.g., Me, My Team, My Client Info)? Can EL expressions solve this problem? If so, please provi…
-
Grade Validation During Offer CreationSummary: Recruiters should only be able to select the same or a lower grade than the Job Requisition grade. An error should be triggered if a higher grade is selected. W…
-
Query/table information to obtain issue description from transactions that end in errorSummary: need a way to report on Issue description, Resolution and Number from transactions that end in error. Content (required): When a transaction ends in error there… -
Database Table name for Approval DelegationsSummary: We have a requirement to build a report for approval delegations, thus need the database table name for Approval Delegations. Navigation: Person Management > Se…
-
Is it possible to add a field to an OTBI analysis that uses sql to query the underlying oracle tableSummary: We have an existing OBTI Analysis that reports on candidate from ORC. We need to add that a field from the Extra Info section of the candidates profile, the Des… -
Help Needed: Retrieving Current Address for a Legal EntityHi Everyone, I'm trying to retrieve the current address for a Legal Entity, but I'm facing challenges in identifying the correct tables and joins. Context: I understand …
-
Reporting on Payroll Balances with a Time Definition DimensionSummary: Hi, we have a number of payroll balances defined which utilise element allocation functionality and have a 'time definition' dimension i.e. _REL_BD_TDPTD. The t…
-
Mass Download of Document Records errorsSummary: Can you get details on the skipped downloads or those with errors? Content (please ensure you mask any confidential information): This is in the log file: Total…
-
Could not find the lookup HRC_TRANSACTION_STATUSSummary Could not find the lookup HRC_TRANSACTION_STATUSContent Hi Experts, As a part of pulling the Approval Transaction Details, I have used the table HRC_TXN_DATA. Th…
-
Week Number calculation for OTL Overtime report if week starts from saturday and end on fridaySummary: Hi Team, We need to calculate the weeknumber for a overtime card report. Week will start from saturday and end on friday We need to pass "from week" and "to wee…
-
How to report Job Details > Action reason in OTBISummary: We use the 'Action Reason' field in Workforce Structures - Job Details to record why we created or updated a job. We would like to be able to report on this fie… -
User unable to run OTBI report but could in the pastSummary: All of a sudden this user is not able to run reports specific to ORC. I cleared the server cache but it's still not working. Any ideas prior to logging an SR? C… -
Base table - Email Notifications Workflow approvalsContent Hi, I am looking for a table that holds emails sent out of the workflow mailer. I am specifically looking for details such as Transaction/Task id along with an e… -
OTBI Subject area for Candidate Extra Internal InfoSummary OTBI Subject area for Candidate Extra Internal InfoContent Hello team, I'm looking for OTBI subject area for Candidate job application extra internal info. Thank… -
How to retrieve timestamp when candidate submits RMI applicationSummary: Content (please ensure you mask any confidential information): Working to troubleshoot CSP automation and I am looking for a timestamp for when candidates submi… -
Custom PVO creation and other data extraction approaches like HCM Extracts, etc. Need inputs on thisWe are trying to explore the options for Data Extraction methods using PVOs (Public View Objects). As part of that, we are looking whether we can create Custom PVOs with…
-
Job Requisition Audit report neededHi Team, We have a requirement to create a report to bring Requisition Audit report, The client is trying to fetch each transaction that occurs with a requisition , any …
-
📄 OTBI Report to Generate HDL File for Deleting Feedback RequestsSummary: This provides a custom OTBI report built on the Workforce Performance – Requested Feedback subject area. It helps companies generate HDL-formatted data to delet… -
Does exist an official/unofficial presentation for OTBI reporting training?Summary: Looking for OTBI reporting training presentations. Content (please ensure you mask any confidential information): I need to teach the customer how to use OTBI r… -
Looking for the Checklist Task Sequence in the Workforce management Checklist Real TimeSummary: Looking for the Checklist Task Sequence field in the Subject Area Workforce Management - Checklist Real Time Content (required): We are looking to add the Check…
-
BIP HCM Payroll - Is there any alternative to pull the Payroll process statusBIP HCM Payroll - Is there any alternative to pull the Payroll process status apart from below Query /* ( SELECT meaning FROM hcm_lookups WHERE lookup_type = 'ORA_HWM_PA…
-
Help Desk Data only role for access to reporting for HR Service Requests and Knowledge ManagementSummary: I am trying to provide access to a Help Desk and Knowledge dashboard for users that cannot access the Help Desk and Knowledge modules. The subject areas that th…
-
Processing Bar Not Visible During Report Generation – Needs Left Alignment or Fixed PositionSummary: When running a wide report, the Processing bar appears centered on the report, making it not visible unless the user scrolls horizontally. This causes confusion…