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
-
OTBI Report Shared to Supervisor does not show parameterContent Hello Everyone, I have added a tab to 'My Team' to show reports to Line Managers. I have added an OTBI report to this tab using personalization. However, when ru… -
how to send the Salary Slip email PDFSummary we need to send the Salary Slip email PDFContent is there any option to send the Salary slip PDF with password protected. -
Default Cost Center in Expense AccountSummary Default Cost Center in Expense Account when entering Department information on Employee AssignmentContent Hi, we are storing Cost Center information on the Depar… -
Employees who had their job changed?Summary OTBI report for all employees who had their job changeContent Hi Experts, Is it possible to create a report in OTBI which gives me a list of all employees who ha… -
OTBI reports not working in 20ASummary All OTBI reports are erroring out in 20AContent We recently got our test instances upgraded to 20A over the weekend and all our OTBI reports are not working. We … -
Track hours for ACA requirementsSummary Looking to find details to track hourly employees to see if they meet hours for ACA eligibilityContent Hi all, Client is outsourcing ACA administration, however,…
-
Has anyone seen custom reports timing out after 20A upgradeSummary BIP Reports timing outContent We have a custom BIP report built off a SQL data model. It used to run about 15 minutes. After upgrading to 20A in all our developm…
-
Returning data based on two columnsSummary Data must be returned if either of the criteria satisfiedContent HI all Any ideas how to do the above. I am working in Absence Calendar and have the start and en… -
HR Help DeskSummary Subject area details/mappingContent Good afternoon, i was wondering if we have any supporting documents for the "New" help desk subject areas like "Service - CRM…
-
Workforce Map - ReportSummary Looking to see if the Workforce Map we use can be replicated in OTBI or BIPContent Hello We are soon to move from a partial cloud installation to a full cloud of… -
Pull Question Library with SQLSummary Questionnaires:- My Workforce > performance > Setup and maintenance > Manage Questionnaires > Select “HR Checklists” in Subscriber > Select “Questionnaire Librar…
-
BIP Report: Converting multiple row & multiple column values into single row and multiple column valSummary BIP Report: Converting multiple row & multiple column values into single row and multiple column valueContent Dear Experts I am working on a BIP report (SQL quer… -
Changing Security on A BIP Report so that it displays whole organization data instead of just the daContent Hi All, Does anyone know the best way to modify a BIP report that's built to show manager's hierarchy view only so that the report shows full organization data? …
-
Concatenate a case statement with fieldsSummary I want to concatenate a case statement with a field in OTBI. How would i do so?Content "Worker"."Person Type", CASE WHEN ( "Assignment Manager List Unsecured"."M…
-
Connect OTBI to SQL DeveloperSummary ReportingContent Is there a way to connect OTBI to SQL developer? I want to run queries and create reports through SQL developer.
-
ORA-01489Summary error when running a reportContent Hello. I built a report in BIP where I had to concatenate columns into rows and it runs as expected. However when I try to for…
-
RetirementSummary Eligible to RetireContent To be eligible for the pension plan an employee has be to be aged 65 or meet the “magic 80” rule which is the employees’ start date + a…
-
How to provide the secure access to folder using custom role to employeeSummary How to provide the secure access to folder using custom role to employeeContent Hi Expert, Want to provide the report folder access to the set of employee who is…
-
Which table stores the Manage Set Assignments detailsSummary Which table stores the Manage Set Assignments detailsContent Hi Team, Can some one point me to the table which stores the Manage Set Assignments details. Go to M…
-
Issue with Annualized Salary in OTBISummary Anunaluzed Salary not showing up in OTBI analysisContent Hi - We are in the process of building/moving our BIP reports to analysis but have been encountering iss…
-
I can't see any secured reportsContent Hello Guys,The technical department has secured the reports in BI. My users cannot view the reports anymore, it seems as if they no longer exist. Is there any ro… -
Can I report on System Entry Date?Summary How can I report on the system entry date of an action? Not the creation date or last update date.Content Hi all, Has anyone found a way to report on the actual …User_2025-01-31-22-36-07-589 91 views 5 comments 0 points Most recent by User_2025-01-31-00-25-12-234
-
Improvement Ideas for BI Catalog UI / NavigationSummary BI Catalog UI ImprovementsContent Hi All, We at DHL are using HCM for few years already and we are looking to further exploit our data to provide intelligence an… -
Create a report for Areas of ResponsabilitiesContent Hi Guys, I need to realize a Report in order to extract: Person ID, Employee Name, Area Of Responsibility Name , Responsibility Type and Scope Of Responsibility.…
-
how do i pass HR assignement no to balance feed querySummary how do i pass HR assignement no to balance feed queryContent Hi Members, I need a help. There is an employee having two assignment no at the same legal entity. I…
-
Adding metadata to PDF output generated through BIP burstingSummary Can we add metadata/Properties such as author, tags to a PDF output file through BI PublisherContent Can anyone tell me if I can add metadata to pdf output gener… -
Using Multi-threading in BI Publisher Data ModelSummary Using Multi-threading in BI Publisher Data ModelContent Hi Experts, In order to improve performance , I see that BI publisher has option in Data Model Properties… -
Using WITH in SQL versus sub-query-which is better?Summary Using WITH in SQL versus sub-query-which is better?Content Hi Experts, Can someone help me understand if using WITH in SQL query really improve performance versu…
-
HCM Subject Areas - Field ListSummary List of fields within HCM Subject Areas - and DescriptionContent Hi, I am new to reporting within HCM OTBI so this may be a silly question and may or may not hav…
-
Error on Technical Summary Report under /Shared Folder/HCM/Setup and Maintenance/ConfigurationSummary Getting data model error while running Technical Summary Report under /Shared Folder/HCM/Setup and Maintenance/ConfigurationContent Hi All, Does anyone know what…