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
-
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 limit values in OTBI prompt when using SQL Results in choice list values.Summary how to limit values in OTBI prompt when using SQL Results in choice list values.Content Hi All, We have a requirement to show values in prompt as per AOR/securit…
-
How do I return vacation request data in the transaction console, which tables can I use?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Absence Balance Report Based on Balance Calculation DateSummary How to get the absence balance to include future dated absencesContent In the existing report, balances are reflected as of today; however, would like it to refl… -
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…
-
Fast Formula for getting balance avail date in Oracle Absence Management?Summary: fast formula for getting balance avail date in Oracle Absence Management Content (please ensure you mask any confidential information): I need a fast formula fo…
-
HCM Extract and BI Publisher - GC overhead limit exceededTeam, We have a HCM Extract which is invoking the BI Publisher to generate PDF output. But we are getting an error and HCM Extract is not generating any PDF output. Erro…
-
How to provide the gap between the 2 bars in bar graphSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Which table contains data for Candidate's Job Application Id. I need SQL for BIP report .Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Extra blank line in Excel output from BI Publisher RTF template due to using page break to get multiSummary Extra blank line in Excel output from BI Publisher RTF template due to using page break to get multiple tabsContent Hi Experts, I have a problem. There is a BI R… -
BI Report access issueSummary: Hi, One of the users is unable to access the BI report. When he tries to access it, he getting the error shown below. But, he is able to access the report from …
-
if else condition in rtf template is not workingi tried using these conditions in rtf but its not working
-
OTBI output is different for 2 different usersSummary: Hi, We have a custom OTBI report which is scheduled to send report to the Business Users. This report shows that 100 employees have missing family contact infor… -
Issue: Unable to expand Calculation Components Detail folder in Payroll - Calculation Cards Real TimSummary Users building reports on Calculation Cards Subject Area when try to expand Calculation Components Detail folder, the folder doesn't expand. Solution is provided…
-
View Reports and AnalysisSummary: View Reporting and Analysis on the Cloud Help Center Content (please ensure you mask any confidential information): There used to be a link for Reporting and An… -
Redwood: Can we make attachment mandatory in Refer Candidate PageSummary: Redwood: Can we make attachment mandatory in Refer Candidate Page Content (please ensure you mask any confidential information): We are unable to make Attachmen…
-
Is there a way to set a section to collapsed state by default on OTBI dashboard page?Summary: Need solution to set section collapsed on load of dashboard page. I understand there is an option to save the customization for each user but it is not viable t…
-
Query to pull error details of failed terminations from transaction consoleSummary: Query to pull error details of failed terminations from transaction console Content (required): We need a query to pull error details of failed terminations fro…
-
newly hired managersSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
How to report on details held in Past Incumbents section of Position DetailsSummary: We need to add some of the fields held in 'Position Details' into an existing report but cannot find within any tables columns that correspond to the fields vis…
-
query for exit and entry dates of positions occupied by each employe that applied for a requisitionSummary: Hi all , I came across a requirement : to pull the position entry and exit dates in the date range of application submission date of all the persons who applied…
-
Report to say if employee has any direct reportsContent Hi, have a simple report that says something like PERSON NUMBER | Name | Department. I need to add an additional column that returns yes/no for if that employee …
-
How to make the email confidential through bursting in BIPSummary: We have a requirement to make the email confidential in BIP , we are sending the email to recipients through bursting . Content (please ensure you mask any conf…
-
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…
-
Email Address FormulaHi Everyone, I am building a report for one of our HR partners. She is using the report as a file loader to put employee data in an external employee recognition platfor…
-
Is it possible to add a time zone prefix to an OTBI report?Summary: If I want my OTBI report's data to only display one specific time zone no matter the user's preferences, how would I do that for just one report? Could the pref… -
Unable to report on Guided Journey QuestionnaireSummary: We've created a guided journey questionnaire as part of the requisition process for hiring managers, however we are unable to report on the data. We've had an S…
-
Facing " There is no data to process" in BIP reportSummary: Facing the error " [INSTANCE_ID=bip.bi_server2] oracle.xdo.servlet.scheduler.ProcessingException: There is no data to process" in BIP report and there is bursti…
-
Difference between Oracle Delivered OTBI Report-Budgets Wrksheet & Budgets Wrksheet Worksheet MgnrWhat is the difference between these two out of the box OTBI reports? Budgets Worksheet and Budgets Worksheet for Worksheet Manager Path: /Human Capital Management/Compe…
-
Overtime status is not showing data in workrelation subject areaSummary: Hi Team, We had defined overtime status at job level. like below. but the information is not showing workrelationship subject area. Request you to help on to fi…