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
-
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 … -
Emergency contact detail access via BIP reportSummary: Emergency contact detail access via BIP report Content (please ensure you mask any confidential information): Hi, We've built a BIP report to give emegency cont… -
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…
-
Performance Document Acknowledgement Task Status and Completion DateSummary: We're using the Oracle Cloud HCM Talent Management > Performance Management performance document to manage and document performance improvement plans (PIPs) and… -
In which table can I find the Proposed Worker Type field in Workrelationship?Hi, I want to add the Proposed Worker Type field on the person screen to my report as in the screenshot below, but this information returns an id in the per_all_assignme… -
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…
-
How to change the date format in OTBI promptSummary: How to change the date format in OTBI prompt. currently we are trying to change the accounting date column to mm-dd-yyyy format but we are getting syntax issue.…
-
where to add parameter effective date conditions to OTBIHi All, Requirement: Added Effective date as a parameter in prompt and report should fetch all active employees as of that date which is given in the effective date para… -
Need query to get scheduled process details such as process name, scheduled time, parameters.Summary: Need query to get scheduled process details such as process name, scheduled time, parameters. Content (required): I need query where I can get count of active s…
-
Multiple pdf outputs to be sent to single emailSummary: Hi We are looking for sending multiple pdf's from a report, to a single email using bursting query or to be zipped and sent to a single email Content (please en…
-
Can we set the absence accrual repeating period to daily?Summary: Can we set the absence accrual repeating period to daily? I tried searching for the delivered Daily Calculation repeating period in the absence accrual plan, bu…