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
-
Does anyone knows how to query current task in Performance Document?Summary: I need the select statement to fetch this value Content (please ensure you mask any confidential information): I'm trying to write a query that selects this fie… -
Query to get Latest offer extended by details in ORCHi Folks, We are trying to fetch the latest offer extended details in our report, we tried latest updated by column from irc_offers, but It didn't work. Scenario: Hiring… -
BIP publisher email unable to send to icloud candidate emailSummary: Hi, we are using BIP jobs to trigger emails to new hires based on task completion in journeys and recently BIP email is getting failed to deliver to icloud doma…
-
How to show an icon based on company?Summary: How to show an icon based on company? Content (please ensure you mask any confidential information): An icon of a report can be shown only if user has specific …
-
Is it possible to access the audit logs of selects placed on certain tables via Oracle cloud?Hi, I need the logs of some tables that are important for confidentiality. Is there a table on BI Publisher that contains the details of who ran it and when it was run i… -
Default View Reports and AnalyticsHello all - We're currently looking for a way to default the displayed folders application and user wide when navigating to Reports and Analytics from the home page. Doe… -
How can we download the uploaded document File from/via BI Publisher using SQL queryHi , Is it feasible for an employee to download the uploaded document file from/via BI Publisher using an SQL query? Thanks, Ravi Chaitanya
-
Manager information regarding the last active assignment of inactive employeesHello, In Oracle HCM system, the manager information of the employees who left the job is emptied, therefore the managers of the inactive employees are empty in my repor…
-
Report that identifies when an employee becomes a manager of peopleSummary: Is there a way to build an report that will identify when an employee (non-manager) becomes a manager (people leader). We utilize the "Working as a Manager" fie…
-
Tables for Archive Transaction detailsSummary Need tables for extracting details from transaction consoleContent Hi Team, There's a report requirement to extract previous years transaction details from trans… -
Employee Length of service (LOS) sql query based on Hire Date/Rehire Date in fusion hcmHello Team, I need a sample Employee Length of Service (LOS) SQL query based on hire date/rehire date in Fusion HCM to use outbound integration for one of my customers. … -
How to get completion record for learning activities under course and offering?Summary: Hello, I'm trying to create a report for completion of activities. Can anyone point me where to find from the Workforce Learning - Learning Records Real Time su…
-
What privilege or configuration is needed to ensure the user could view Demographic Info it in OTBI?Summary: Content (please ensure you mask any confidential information): One user can see PER_PERSON_LEGISLATIVE_DFF on the screen but not in OTBI, while another user can… -
SQL to extract location mailing addressSummary: Please could you let me know the SQL to extract mailing address that is stored in Manage Locations task. I have checked in the HR_LOCATIONS table but I cannot f…
-
How to have the report names show when embedded on the left side bar?Summary: Hi there, We are embedding reports as pages/tabs to the left side of certain pages I'm not sure how to get the name of the tab to show. Is there a setting that …
-
Run Payroll Costing Results - load column into FDI?Hello, Is there a way to take a column from the seeded Run Payroll Costing Results report and move that into FDI for reporting use? The need for it is stemming from payr…
-
BIP | SFTP filenames with .XLS or .XLSX extensions are not readable in SFTPSummary: Hi Experts, My requirement is to place the SFTP file in .XLSX format. SFTP filename with .XLS or .XLSX extensions are not readable in SFTP, but filenames with .…
-
Reporting on withdrawn absencesSummary Is it possible to report approved and withdrawn absence bookings in OTBI?Content We have a requirement to start reporting on absences which have been withdrawn b… -
Learning Users Showing Different Output in OTBI ReportGood Day, We have 2 learning users running the report in OTBI but they don't have the same report output. Example, user1 showing 10K rows while user2 only retrieving 8K …
-
ANC_PER_ABS_DAILY_DTLS - Issues with Overnight Shifts / Absence BreakdownSummary: We want to report on absences related to a shift, however the table seems to store the hourly breakdown per day rather than per shift start date. Example; 25/06…
-
How to get same data in two data sets in the same data model without any data model link.We have 2 different data sets in the same data model, and we have a common column in both the data sets but without a link. Can we get same data based on the common colu…
-
How to call a query or data of one particular data model to another data model.We have a requirement to get gross salary details in many BI Reports. We need to know that is there any feasibility to call one data model related data in another data m…
-
Numbering Adjustment in RTF TemplatesCustomer have multiple paragraphs in a report built using RTF template which are numbered and some of them have conditions so if the condition is met the paragraph is di…
-
Can I download bi publisher to mac?Summary: Hi team, I want to switch to mac , I saw that is problem to download BI publisher, someone tried? and there any other problem with mac?
-
Rolling Average Wage ReportHi Does anyone have a sql query or a report that provides the average weekly wage over a 52-week period based on a specific date? We are trying to provide our Workers Co… -
How to return specified run result values on one row in Payroll Run ResultsSummary: Without using a pivot table, how can I get payroll run results to show input value names as the column headers, then the relevant run result values horizontally…
-
Impact in the reports/dashboards after enabling RedwoodHave you encountered any issues with Reports/Dashboards after enabling Redwood across the HCM modules? Is there any documentation or impact analysis available for this? -
What table stores the extended lookup code name for Visas and Permits?Summary: I am trying to build a DM for Visa and Permit notifications. What table stores the extended lookup code name for visas and permits? I would assume there is a ta… -
How to get the Job offer Approval history in a BIP report?Summary: Hello, We have a requirement to fetch the approvers, their approval comments and the date of approval in a report. How do we get this via BIP report? Version (i…
-
I want more than 2 prompt input lines in OTBI.Summary: I want more than 2 prompt input lines in OTBI. Content (please ensure you mask any confidential information): When a graph is created in OTBI, the value list is…