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
-
Is it possible to display contents of CLOB column in OTBI analysis?Content Is it possible to display contents of CLOB column in OTBI analysis? I am adding a CLOB column to an OTBI analysis but it comes up with blank. When I query the sa…
-
Custom Recruiting Report Using Message TemplateGood Day Experts, Is it possible to create a custom recruiting report using OTBI or BI Publisher to extract 'Start Date Change Request' message template in Oracle fusion…
-
How to Include the Weekends and Public Holidays in the OTBI dashboardSummary: How to Include the Weekends and Public Holidays in the OTBI dashboard to the below code snippet. Content (please ensure you mask any confidential information): …
-
Schedule a BI report with incremental dataSummary: Schedule a BI report with incremental data Content (please ensure you mask any confidential information): Hi Experts, I have a requirment, I need to scheduled a…
-
Database Table name for Approval DelegationsSummary: We have a requirement to build a report for approval delegations, thus need the database table name for Approval Delegations. Navigation: Person Management > Se…
-
Table for Payroll Transfer Status and Payroll Processing StatusWe need to get Payroll Transfer Status and Payroll Processing Status. Where are these information gets stored? Please share if you have any inputs. We have tried using p…
-
What is the functional difference b/w fusion_ora_ess.request_history and fusion.ess_request_historySummary: What is the functional difference between fusion_ora_ess.request_history and fusion.ess_request_history and please explain ErrorType codes present in fusion.ess…
-
We Need a table for the Configure Worksheet Display -Detail Table in Workforce compensation planSummary: Hi, We Need a table for the below highlighted fields under the Configure Worksheet Display -Detail Table in Workforce compensation plan Content (please ensure y…
-
Talents Comments Field ReportingHello experts, We have at 10 talents reports that using the comments fields, but it are stored as "CLOB" but is a mess to work with it. i try a lot of diferent forms to …
-
sql query to get job level in oracle fusionSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Feedback center manager email and BPM notification content mismatchHad an issue in Notifications content display - We have enabled and customized the template - /Shared Folders/Human Capital Management/Workflow Notifications/NoteSentToM…
-
What is the recommended tool to feed Data Warehouse from HCM CloudSummary: I would like to understand what the recommended tool is to feed Data warehouse from HCM Cloud. The BI Cloud Connector seems to me the best tool for this purpose…
-
How to freeze dashboard filter prompt in OTBIHi Experts, We have a requirement to freeze dashboard prompt in OTBI report like we did in Excel header if we are scrolling the dashboard we are unable to see the prompt…
-
Add Learning Incident Comment into ReportSummary: I had created a Learning Incident report so that we can see who had reported the incident. Learning Admins receive notifications when incidents are reported but…
-
Sample report (preferably OTBI) of candidates that have applied using multiple emailsSummary: Does anyone have a report (preferably OTBI) of candidates that have applied using that one email. In essence, same candidate name and address applying with mult…
-
Where is the submission date stored on the team time cards?Summary: I'm writing a query to check for time that hasn't been transferred to payroll and I would like to include the submission date field. Which table contains this f…
-
Looking for Employee Salary and STIP report either OTBI or BIP report sql.Summary: I am looking for a report that would capture every salary and STIP eligibility percentage an employee had during the course of a year. For some employees, that …
-
Unable to enable the ORA_OARS_VB_NAVIGATION_ENABLED profile option.Summary: We had previously raised an SR with Oracle regarding a REST action error on the My Team Activity Center (Redwood) page. The solution provided was to set the ORA…
-
Unable to deliver the file to SFTP serverHi Team, We have created SFTP server and while clicking on "Test Connection" the connection is showing as successful. But while we are scheduling the extract to the resp…
-
Create infolets with the use of FDI reportsHello, We have been implementing the new reporting tool of FDI and we have been asked if it is possible to create Infolets for the FDI reports in the home page of Oracle…
-
Adding additional column to get headcount for each month in OTBISummary: How to add additional column or calculated item to get the head count for every month? Content (required): I am using 'Workforce Trend Real time Subject Area' a…
-
Is there any way to get back the archived transactions related workflow transactionsSummary: I want to get the information on archived transactions details. Content (please ensure you mask any confidential information): Recently we have click on archive…
-
From which tables can I get the Workflow details of transactions archived in transaction console.Summary: Tables to get the Workflow task details of transactions archived in the transaction console. Content (please ensure you mask any confidential information): Vers…
-
Table for proposed Projected end dateSummary: Hi All, We have a requirement to create a report in which we want to capture Current Projected End Date and Proposed Projected End Date. We are unable to find i…
-
Which PVOs in the BICC console we need to pull to access the below tablesHi Team, Which PVOs in the BICC console we need to pull to access the below tables: HZ_ROLE_RESPONSIBILITY 2. HR_OPERATING_UNITS 3. FND_SETID_ASSIGNMENTS 4. FND_TREE_VER…
-
Is there a table which stores Absence balance for future date of and incremental planSummary: We are looking for a table or sql query which gives Absence balance as on future date. Absence plan is incremental, and accrual process will run for every bi we…
-
Report on Messages sent to Candidates using a message templateSummary: Content (required): I'm looking to report on Email messages sent to candidates who've submitted a job application. Any thoughts on which subject area/dimension …
-
Incorrect values are appearing in OTBI report for leave durationSummary: We have created OTBI report where we are fetching absence details based on year and month (monthly absence report). If employee has taken leave for single month…
-
Unable to send bcc in bursting.In the bursting query i have added parameter 8 for BCC mails. However, 'to' mails are going and the employees are receiving the mails. BCC is not being received. Can any…
-
Tables for Worker Time Processing profiles in HCMSummary Tables for Worker Time Processing profiles in HCMContent Hi Team, I am looking for a query to find Worker time processing profiles(HCM Groups) based on assignmen…