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: 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… -
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 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… -
How to Merge row cells if having same data in RTF templateSummary: I want to merge same row cells in excel data in RTF template. Person Number ,Person Name and License Number should come as single row like merge. Can anyone hel… -
OTBI Report - need to fetch the Worker Historic informationSummary: we have a requirement to fetch Worker Historic information like Current Job Title Previous Job Title Previous Department New Department Previous Manager New Man… -
How to get a data secured Job Requisition report in ORC?Summary: We need an Oracle Recruiting Job Requisition report with Job Offer status/progressing information if the Requisition started the offer process, which will publi… -
Candidate Address and Other - IRC_JobOffer_Accepted_External - Alert/NotificationContent Hi, Using Alert: IRC_JobOffer_Accepted_External, added template. Whereas Procurement Department need to be informed that Candidate accepted offer. Procurement ne… -
SQL Query to get Absence Qualified Entitlements for an EmployeeSummary Need an SQL query to build a BIP report similar to what is available on the Absence Records UI which provides details of qualified entitlementsContent I'm not ge… -
Is there a way to pull out job offer comments in OTBI?Summary: Is there a way to pull out job offer comments in OTBI? Content (please ensure you mask any confidential information): Hello Experts, We are challenged to pull o… -
Re-hire employee HDL templateSummary: Hi Expert, We are looking for an HDL template to rehire terminated employees. The requirement is to rehire employees with the same assignment information they h… -
BICC Deprecated PVOs for 26CCould you please provide an update on when the 26C Deprecated BI View Objects document will be available? As Oracle Cloud 26C is scheduled to roll out soon, with test en… -
Performance Issue - per_availability_details.Get_availability_detailsWe've developed a BI Publisher Report, but it's experiencing performance issues. When run ad-hoc, the report times out (Timeout Error), and when scheduled, it takes over… -
Performance Document Period Questionnaire Responses ReportSummary: Using Workforce Performance - Performance Rating Real Time to build a detailed report based on the Questionnaire Responses. Content (please ensure you mask any … -
How can I get the original column header in the CSV output of a BI report without underscoreSummary: How can I get the original column header in the CSV output of a BI report without underscore Content (please ensure you mask any confidential information): How … -
How to pre-pond the benefit plan enrollment date for any employee.Summary: How to pre-pond the benefit plan enrollment date for any employee. Content (please ensure you mask any confidential information): I have a requirement where few… -
HRC_TXN_CONSOLE_ENTRY table is not returning any values for the TASK_APPROVER fieldSummary: HRC_TXN_CONSOLE_ENTRY table is not returning any values for the TASK_APPROVER field. When I export the transactions from the transaction console, it exports the… -
Can anyone share if there is a table that tracks the UI activity for the given user.Summary: We have request to build a report that extracts the UI activity of the given user Content (please ensure you mask any confidential information): We have request…Besta Narayana Swamy Prasanth Kumar 22 views 4 comments 0 points Most recent by Abhishek Premchandra -
Notify Project Admin when Project manager is terminatedSummary: Hi I have received a request from Project Administration if it is possible to create an alert to notify the registered Project Admin if the currently active Pro… -
How to enable dynamic password while generating the payslipSummary: Hi All, Requirement: I need to make payslip dynamic password protected. For Example - Date of birth of the employee. Thanks. Content (required): I followed the … -
Virus Scanner Not Reachable - Unable to Archive Files in My Folders / Shared FoldersSummary: Content (please ensure you mask any confidential information): Hi, We are encountering an issue when trying to archive files in My Folders and Shared Folders. E… -
OTBI report - functional managersSummary: I would like to create a report that could give me a list of functional managers by employee - OTBI reports. Content (please ensure you mask any confidential in… -
Can we remove or hide the destination from Scheduling BIP ReportsSummary: We have users who run scheduled reports in BIP but we do not wish for them to be able reports using the email selector or send anywhere else. Is there a way to … -
Oracle hcm cloud seeded reports what is the list of reports and their locationHello, I would like to know please, what is the list of Oracle hcm cloud seeded reports ? and where they are located ? for example : employee contact ,employee address ,… -
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… -
Annual salaries for current and terminated employees in one reportIs it possible to create a report with just a list current and terminated employees and their annual salaries? -
Retrieve “Processed People” count for Generate Total Compensation Statements ESS process in BIPFor the ESS process Generate Total Compensation Statements, the Scheduled Processes log displays values such as: Selected people: 1921 Processed people: 636 Ineligible p… -
Adding prompt with manager for get the entire hierarchyContent Hi, any suggestion on how to insert a prompt in a OTBI to filter the result on manager and display the direct and indirect reports. Thanks Nicola -
Does the person with delegated role get access to the additional data via reportingContent (please ensure you mask any confidential information): If a Manager has delegated (say) their Line Manager role to their Exec. Assistant (EA), then does the EA s… -
Generate .ZIP file from BI Publisher ReportSummary Need to create a BI publisher Report that can output .zip file to be run in HDLContent Hello, We want to create a BI publisher report that can provide us a .zip … -
Need sql Query to fetch the Job Applicants in Draft StatusSummary: We have a Requirement to build a BIP Report for fetching the Job Applicants in Draft Status. Can anybody please share the sql query for this requirement. Conten… -
Query to pull the failed transactions from transaction consoleSummary Query to pull the failed transactions from Transaction ConsoleContent Hi Experts, Good Day!! We have the requirement to pull the failed transactions from transac… -
OTBI - analysis runs perfectly until I try to add in Manager Name and Person Number from Manager (inSummary OTBI - analysis runs perfectly until I try to add in Manager Name and Person Number from Manager (in Workforce Management - Worker Assignment Real Time)Content B… -
Competency Rating in PerformanceSummary I need to pull item ratings and item comments a manager entered in the Competency section in a performance documentContent HELP!!!! I need to pull item ratings a…