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
-
Get rid of white space at the top of a tabular reportSummary: Has anyone experienced a large white space at the top of a tabular report. Please see attached screenshot. Content (required): Has anyone experienced a large wh… -
Consolidated List of OTBI and BI Publisher Reports Posted (10 February 2015)Content The following is the list of published OTBI and BI Publisher reports between 10 December 2014 and 10 February 2015: * Bradford Factor * Extract Manager Hierarchy… -
Need to calculate Age in BI AnalysisSummary What is the formula needed to calculate age within a BI Analysis?Content I am trying to complete a report to calculate the age levels of employees. I pulled in h… -
Need SQL Query to fetch the Advanced Mode Absence Duration in Absence RecordsHi Experts, Could you please help me on SQL Query to fetch the Advanced Mode Absence Duration in Absence Records. Thanks, Nagaraju. -
Is there a way to pull comments section off Requisitions and Offers into reports?Summary: Pull the Comments field from Job Requisitions and Offers into reports Content (required): Looking to be able to pull the Comments field from Job Requisitions an… -
Export entire dashboard from a custom pageContent Hi Guys, I see that is possible export the entire dashboard from the OTBI by clicking on the Option export to excel. But, my question is: Is it possible export t… -
BI Publisher Bursting Email from Company Domain IDSummary: Hello Experts, We have a requirement to trigger emails from our company domain ID (@companyname.com) while triggering emails from BI Bursting. We don't want the… -
Primary Email in Oracle TablesSummary: Hello. Could you please advise which table contains Primary Email? I'm building a BIP data model using query below. There are email type and email address inclu… -
Reporting the Career Development screenHi, I want to generate the data sql report on the My Team>>>Career Development screen. But I can't find the table where this information is kept. Can you help and share?… -
Schedule Report to Run Prior Month/QuarterSummary: Currently, only a few HR members can run reports, no one outside of HR can. If they need a headcount roster or turnover, I would run the report for them. There … -
Compensation Approval Chain in OTBI ReportSummary: How to view all managers who approved a compensation change? Content (required): On the front end I can see for each compensation change, a list of managers who… -
Passing parameters from a UI page to html opening BIP Report doesn't work anymoreSummary: Passing parameters from a UI page to html opening BIP Report doesn't work anymore Content (required): Hello Experts, I'm facing an issue when passing a paramete… -
Dashboard screen customizationI have a dashboard report that I have prepared with parameters and I want the parameters to look like the screenshot. I couldn't find how to make the background visually… -
Email-Bursting Without Split-ByWe have a requirement to send an email with details. The email body should have the details with table format. The query has more than one record and it should be printe… -
Is there a User Activity Report?Summary Is there a User Activity Report?Content Looking for a report or way to see how often user(s) login to Core HR system. Any reporting or functionality capable of t… -
Need table name to fetch 'Plan Period Start Date' in the 'Accrual Plan Balance' Screen.Summary: Dear Experts, Which table stores the 'Plan Period Start Date' in the 'Accrual Plan Balance' Screen. Please find the attached Screenshot for your reference. Than… -
How to determine timing delay how long does it take for data to be committed to the audit tables?Summary: We receive ad hoc tasks from business every time there's a compensation refresh happening. This process contains updates in the Assignment and Salary Section of… -
Oracle Cloud IP'sSummary: We need to SFTP a file to our vendor using BIP report. Vendor needs us to provide the IP's to whitelist on their end. Can you please advise where to find Oracle… -
Can we build a single report for BIP or OTBI and then restrict columns for different users.Summary: We have a requirement to build one report and then send it to multiple users with different combination of columns. Content (required): Hi Team, We have a requi… -
Regular Temporary column from Workforce Management - Worker Assignment Event Real TimeSummary: There is no "Regular Temporary" column in the "Assignment Event Details" folder from the Subject Area "Workforce Management - Worker Assignment Event Real Time"… -
Duplicate Departments when using Goal Status Overview Real Time Subject AreaSummary Duplicate Departments when using Goal Status Overview Real Time Subject AreaContent Hi Experts! Good day! We are having issues with duplicate departments. Is the… -
What can we do so that OIC applications do not use license limits?Hi, What should be done to prevent the versions created for the live and test environment from using license limits in the applications we develop in the OIC environment… -
Position hierarchy report prepared from Oracle AnalysisHi, I am preparing a position hierarchy report using an analysis report. How can I find the person in the next position of a position? Regards -
OTBI Agent - would like to see why it failed to runSummary: Is there a way to see the reason for an Agent's failure? Content (required): When an Agent fails to run and deliver an Analysis, we can see that it Failed (unde… -
Interview Feedback Report - BIPSummary: I need to create a feedback report , where we need to fetch responses Content (required): These are some of the fields that I am trying to fetch in the report. … -
Control Infolet visibility on HCM Home page based on person GenderSummary: Control Infolet visibility on HCM Home page based on person Gender Content (required): how to control Infolet visibility on HCM Home page based on logged in per… -
Way to restrict the options in Output Tab during BI Report SchedulingSummary: Content (required): Hi All, Is there a way to restrict the options in Output tab not to be modified during BIP Scheduling? Example - if bursting is enabled in r… -
Valid Grade Report-Multiple Grades on jobs auditSummary: We are trying to run a report on all the active valid grades associated with a job, to audit and clean up any that may have multiple grades associated with the … -
Restrict Security Groups available under Content Server DestinationsSummary: When running an HCM report through BIPublisher, you can send the output to the Content Server. We would like to remove the ability to pick these options from th… -
Requisition creation "use", which subject area is this data housed in?Summary: Trying to report on the requisition "use" field; see screenshot below, but unsure of which subject area this may be housed in? Content (required): Using the sub…