Get Started with Redwood for Oracle Cloud HCM Begin Now
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
-
In Talent if you have a probation goal that crosses two review periods / goal plans how do you managSummary In Talent if you have a probation goal that crosses two review periods/ goal plans how do you manage this ?Content In Talent if you have a probation goal that cr… -
How to join/merge/combine two sql queries.Dear Experts, Thanks For Looking into this post. Could you please help out me. I have two queries as shown below, we need to join one together. Query1: UDT_LKP query. Qu…
-
Formula to prevent deletion of annual absences with Approved status in the system.I prepared a validation formula so that absences with "Approved "status cannot be updated or deleted in the system. The formula for updating is running and an error mess… -
Value set retrieving lookup meaningSummary: Content (please ensure you mask any confidential information): Hello experts, I should retrieve by value set the CMP_CWB_CUST_COL_46_LIST lookup meaning entered… -
"Absence Calendar Direct Reports Current Month" - How does it work 'normally' (but with custom SQL)?Summary: I was editing the logical SQL of a seeded analysis and noticed that while it appears to have custom logical SQL, it still works just like a normal subject area … -
What is mean by Translation information in the data tables?Summary: What is mean by Translation information in the data tables? Content (please ensure you mask any confidential information): Hi Team, I have a query. What is mean…
-
How to extract Questionnaires and Employee Response?Summary: How to extract Questionnaires and Employee Response?
-
Compensation Components amount, date and plan name BI TablesSummary: Content (please ensure you mask any confidential information): Hello experts, we cannot find Compensation Plan Components amounts, effective dates and plan name…
-
RTF Excel Output Merging CellsTeam, We have developed BI Report with RTF template. When user exporting the output in Excel output the cells are getting merged. Example B & C columns are merged. We ha…
-
Which column in OTBI will display if employee is also a manager, We need this in Learning ManagementWhich coloumn in OTBI will display if employee is also a manager, We need this in Learning Managment OTBI reports
-
How to know from front end which field is available in which back end table in oracle fusion cloudSummary: Creating a Report on Apprenticeship. Content (please ensure you mask any confidential information): Need to find data in the Oracle tables for Apprenticeship. H…
-
Bi Publisher - Scheduled Job Failure DetailsSummary Additional detail to ess_request_historyContent Hello, Is it possible to access the log message details for a failed job? I'm familiar with the ess_request_histo…
-
how to get Expected date of joining in orc from which tableIn orc how to get Expected date of joining of candidates. -
Salary with Currency Euros and not local currencySummary Is there a salary with two currency example local currency and salary in euroContent Hello, I want to view a salary of employee in OTBI in 2 currency. By default… -
Apprenticeship ReportingSummary Can we report on Apprenticeships?Content Hi all - we have been asked to report on Apprenticeships that are listed within the Talent Profile. I cannot find anywhe… -
Employee Counts by Location OTBI REPORTSummary: 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 do I convert salaries currency to euro in BI Publisher report?Summary: How do I convert salaries currency to euro in BI Publisher report? Content (required): Hello, My client requires that the salaries in a custom BI Publisher repo…
-
Documentation on Scheduling OTBI ReportsSummary: Hi! My company is currently implementing Oracle HCM. Is there an oracle manual/guide which goes over all aspects (tabs) of scheduling reports through OTBI sched… -
Why Application Composer is not available for HCMSummary Why Application Composer is not available for HCMContent Why Application Composer is not available for HCM and it is only available for Sales
-
Which table I can find the value of "Origin of the evaluation"Hello! I would like to know if anyone can tell me which table I can find the value of "Origin of the evaluation" , in the Performance and Talent Review-Results section
-
identifying OTBI reports based on keyword along with the usage historySummary: identifying OTBI reports based on keyword along with the usage history Content (please ensure you mask any confidential information): Hi Team, Greetings! We are… -
How to put filter on Phone Line Type and also include employees without the type in OTBI?Summary: Hi All, I am fetching employee's data through OTBI where I also want to fetch the employee's Home Mobile Phone data only. After I apply the filter to Phone Line…
-
Busting OTBI Myths - Using different security in OTBI to HCM CloudContent Myth: OTBI doesn't allow me to access different data to HCM Cloud Occasionally you need to allow a user to report on more or less data than they have access to i… -
Is there a way to pull Executive Manager Name on a Terminated employee record?Summary: Trying to run a report by our executive manager's to see how much turnover each manager has had. Appears that Manager details are dropped from an employees reco…
-
Average Salary per HourSummary: We have an OTBI analysis with each department headcount and I need to get the average salary rate per hour in another column. Content (please ensure you mask an…
-
OTBI Analysis multiplying fields ‘FTE & Salary’ – How to resolve?Summary: I am writing an analysis from three subject areas were multiple columns have expressions, when I add an expression which is including the Manager Flag from Work… -
change sql query timeoutSummary: Content (required): Hi team, we need to increase sql query timeout. We saw from some service requests (https://support.oracle.com/epmos/faces/DocumentDisplay?_a… -
date presentation variableSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Oracle Compatible Tamil FontSummary: I have a Letter development which need to compile with Tamil Font. For that I have using Using NirmalUI font and it works fine with word format and rtf format. …
-
How to get BIP Scheduled Report To Update 'As of Date' When RunSummary: Hello, I'm having issues with a BIP scheduled report not updating the 'As Of Date' prompt when it's scheduled to run/send to the user. I have the report schedul…