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
-
Using SUM function in Table Type Value set using FFSummary: Unable to get the sum function in table value set and how we need to get these values in query? Content (required): Here i am facing multiple rows for each diff… -
Edit in Oracle standard absence approval notificationsHi, I want to make edits to the standard notifications in Oracle, such as changing the mail's to and cc information or the title of the mail.and I don't know how and whe… -
"Preview Offer" feature in HTML does not show correctlySummary: The "Preview Offer" task shows the Offer Letter in different formatting on different parts of the page when previewed in HTML. However, when downloaded in PDF f…
-
How to show parameter in exacel template in fusion bi reportSummary How to show parameter in exacel template in fusion bi reportContent In BI report datamodel, I have taken parameters and build report also. Now in bi excel templa… -
Formula for NOT Current Year ("Worker"."Employee Hire Date")Summary: OTBI report - Filtering on YEAR for field name "Worker"."Employee Hire Date" Content (required): I have an OTBI report where the data returned should be for emp…
-
Extracting data using BIP Publisher Report for REST API Load (Creating Timecard)Team, We have a requirement to create bulk time entries for employees (Copying previous timecard and creating the same timecard for current week - Dates differs) and we …
-
Need to pass real time binding parameter dynamically to OTBI Reports.Summary: I have created OTBI Analysis report based on the Compensation -Workforce Compensation Real Time subject area. I have attached my OTBI report to View report sect…
-
Is there any way to fetch all the scheduled (Reports, Extracts and OTBI) as a report.Is there any way to fetch all the scheduled (Reports, Extracts and OTBI) as a report.
-
Need table and field names in ORC Requisition Page->Progress SectionSummary: Need table and field names in ORC Requisition Page->Progress Section. Kindly help, below is the screen shot of the page and highlighted the fields. Progress Sec…
-
Count number of employees submitted response in PERSON EFF (OTBI Count)Hi All, We have developed a Person EFF, and we require an OTBI report that can count the number of employees who submitted their response in the Person EFF (Self Identif…
-
Choosing Position PVO from BICC - PositionPVO vs PositionPVOViewAllSummary: We are implementing a data warehouse and establishing BICC data extraction pipelines. In reviewing the available PVOs for HCM Position data, there are two relev… -
Is there a report/subject area/table/view that pulls all role/data access auto-provisioning rules?Summary: I am in search of a way to pull in all of the active auto-provisioning role/data access rules (rule name, conditions, assignments (associated roles, associated …
-
Candidate Report with Sensitive DataSummary: Can we get a Candidate Report (Recruiting - Recruiting Real Time) that provides the DOB & last 4 of the National Identifier/Social Security Number for those tha… -
OTBI Data.Summary: Hi Team, We are not getting any data in worker assignments realtime. Do we need to run any process? In front-end I can see all employees. and this happens our i…
-
Can we restrict otbi reports such that only manager can be able to see direct reportees?Summary: Manager should be able to see complete details of an employee who is reportee to him/her? Can we use any restrictions in otbi reports such that only manager can…
-
New Hired employee details with Requisition Details (Req Number, Hiring Manager, Recruiter Name etc)Summary: Sql Query to get New Hired employee details with Requisition Details (Req Number, Hiring Manager, Recruiter Name etc) Content (required): Version (include the v…
-
How to find the difference between two date attributes in eText templateSummary: We need to find out the difference between two dates and add 1 to the result in eText template. Content (required): We need to find out the difference between t…
-
Folder permission in OTBI "Resetting?" - "Enterprise Scheduler Job Application Identity for HCM"Summary: Good Day, We have a number of Custom Folders within Shared Folders - Custom where for some reason the "Accounts" "Permission" on specific user on each folder ke… -
Query bursting combined with Union AllI prepared a report using more than one UNION ALL and I want to send it as a notification, for this I prepared bursting and used it from the FROM condition of the first …
-
Calculating Past Experience of employees in HCM BISummary Calculating Past Experience of employees in HCM BIContent Hi; I was trying to calculate the total past experience of the employee in BI with the below formula bu… -
Reporting on approval transaction commentsSummary Reporting on approval transaction commentsContent Is it possible to report on the comments submitted under Attachments and Comments section for approvals not yet…
-
BIP - Organization HierarchySummary: Hello, Does anyone tried creating report in BIP with organization hierarchy details? For example: Enterprise Division Business Unit Department Level 1 Departmen…
-
Query to get time card approver name and approved dateSummary: I need query to get time card approver name. Content (required): I need query to get time card approver name. Version (include the version you are using, if app…
-
Can we restrict learning course details from backend for reporting ?Summary: We would like to give restricted access to the technical person to on the basis of specific course or offering details in oracle learning cloud . We would like …
-
New hires are not showing in SQL reportSummary: New hires are not showing in SQL report. We created report by using Data model. When we export the report, there are not some new hires in it. Content (required…
-
OTBI AgentsWe have OTBI reports with more than 25000 rows (Approx 250000). To transfer data, we need to split them up into 10 to 15 agents by employee's name character or Person nu…
-
produce cost centres from 2 area onto one reportSummary: extracting table tables onto one report Content (required): I'd like to be able to validate the date between cost centres show in "Departments" in HCM vs " Cost…
-
Custom report to see who is listed as Read Only AccessSummary: Hi, Our Audit team would like a security report that lists everyone we have setup for READ ONLY access under Manage Administrator Profile Options Content (requi…
-
The scheduled BIP report is not received to gmail accountsSummary: Content (required): We've scheduled the report to be received by the users with specific roles. It is successfully delivered for some of the accounts but we hav… -
Reporting on rejection commentsSummary What is the name of the BI database table that stores the tracking of rejection comments for transactions?Content I was easily able to find / report on the comme…