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
-
SQL to retrieve employee name,person number,department name and department DFF detailsSummary: SQL to retrieve employee name,person number,department name and department DFF details Content (required): Hi All, Please share SQL to retrieve employee name,pe… -
How to create User defined table (UDT)Summary: How to create User defined table (UDT) with screen shorts. Requirement: i want to store the below data in User defined table & which table can store this inform… -
How post a copy of the burst output to the UCM/content server so a web service can get the fileSummary: We have a burst report which goes to workers when they terminate that we would like to archive to our doc management system. In order to do so we need to post a… -
Issue with Logical SQLSummary: Hi, I was working with a Report which will provide various employee emails like home email and business email addresses along with few other assignment details.… -
How to customize BICC to control data that can be accessed by BI teamSummary: Hi All, We plan to use BICC for pulling data out of HCM but our HR team is concerned on the data access front. We feel like the BI team will have access to sens…
-
Enhanced Analysis with parameters changesSummary: Created a Reports and Analytics Analysis which others users can run. Then I made modifications to the Analysis, saved it and now the others can still only run t…
-
HCM Subject Area QueryHello Experts, Just need a quick suggestion from you - We have a requirement from business where we have to create a custom roles for Auditor - I have created a custom d… -
How to FTP file upload to UCM content server via ODISummary: Hi Folks, Content (please ensure you mask any confidential information): How to upload FTP files to the UCM content server via the ODI tool Version (include the…
-
How to return Geographies using OTBISummary: We want to return Geographies (State, County and City) using OTBI. But the data should not return the geocodes but should return the actual name. Ex: State: LA …
-
How to display the recruiting candidate's department name in OTBISummary: Content (required): I have a candidate who's department in the job offer is different from the one in the requisition. Using OTBI, is it possible to display the… -
Offers Report not pulling dataSummary: Content (required): Anyone experiencing data not pulling through on OTBI analysis reports created using subject area: Recruiting - Recruiting Real Time? Anyone …
-
How do I remove unwanted commas in OTBI report outputSummary: Custom address field column contains extra columns when source column is null Content (please ensure you mask any confidential information): I have created an O… -
Is there any oracle delivered tool or app to signature on the pay checks in FusionIs there any oracle delivered tool or app to sign on the pay checks in Fusion
-
HCM native datamodels/bipSummary: are there another schema.table wich sample reports delivered in HCM Cloud are stored to extract a list of them ?? Content (please ensure you mask any confidenti…
-
csv output giving multiple date format while using etext templateSummary: I have built a report to display a date column in dd-mm-yyyy format using etext template. the report output is displayed in text or csv. In both the cases when … -
SQL instruction to join data from 2 or more BI tablesSummary: Content (please ensure you mask any confidential information): Hello experts, which instruction when building queries in data models allows me to join two or mo… -
Connections BIP report - how to remove HTML tags?Summary: Hello, I've created a BIP report for Connections. Could you please advise how to remove HTML tags? Please find SQL query attached. Kind regards, Marta Content (… -
How to remove the duplicates in rtf templateSummary: Currently using the three Data sets in the report First DS will contain the employee details,legal employer name ,Dept id and element amount Second DS contains …
-
How to filter the column values by another column?Summary: I'm currently creating an OTBI report under this Subject Area: Workforce Management - Checklist Real Time I want to filter employees which have these Response A…
-
Facing issue with top manager type in OTBIWe have created otbi report using top manager type. Multiple managers are visible in OTBI, but in system only 1 manager is tagged. Is there any way we can pick the activ…
-
Coding Conditional Formatting into LSQL?Summary: Logical SQL Conditional Formatting OTBI Content (please ensure you mask any confidential information): Hi All, When building a report in LSQL - I apply the SQL …
-
OTBI Learning course detailsSummary Need help to find attributes in subject areaContent Hello everyone, I am having trouble to locate the attributes for the following fields in learning subject are…
-
Release 13 - Annoyingly hidden folders menuContent Hello, Since R13 the Reports and Analytics page has changed, and annoyingly the folders are hidden and have to click an icon to view them, when they load they do… -
Why there is no error message if same allowance is added with overlapping dates for pending workerSummary: Why there is no error message if same allowance is added with overlapping dates for pending worker but only for Employee using ICP.User is expecting such error …
-
How to create a record in the position flexible field from postman with Oracle Rest API?Hi, I want to send a record to the flexible field opened on the position with the help of Oracle standard rest APIs. But when I examine the oracle document, I cannot see… -
Setup table to pull Approval rulesSummary: Setup table to pull Approval rules Content (please ensure you mask any confidential information): Hi, Could you please advise setup table to pull out Approval r…
-
Add parameters to BIP report URLHello, Is it possible to add parameters to a BIP report URL? My report BIP URL: https://***/analytics/saw.dll?bipublisherEntry&Action=open&itemType=.xdo&bipPath=****%2FF…
-
How to capture employee working as a manager in Employee details oracle BIP reportSummary: What is the table and column to capture working as a manager column, to write a employee details BIP report. Content (please ensure you mask any confidential in…
-
To pull Open Enrollment Benefit data if life event closed and Employee Enrollment not yet submittedSummary: To pull Open Enrollment Benefit data if life event closed and Employee enrollment not yet submitted Content (required): We are looking SQL query/OTBI report to …
-
Display multiple emails/phones on one row when there ae multiple records of the same typeSummary Multiple emails/phones with multiple recordsContent Hi All, I have built my query for displaying employee information with their different emails and different p…