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
-
Reflect one row when there are duplicate rows of dataSummary: Request received to have report with multiple rows of data for workers to reflect one row for each worker, but still include all data. Hopefully the screenshot … -
Why bursting from BI Publisher sends emails to 1 domain and not the other?Summary: Why bursting from BI Publisher sends emails to one domain and not the other? Content (required): I created a BI Publisher report having bursting object on it. I… -
Table name where department set is storedSummary: Table name where department set is stored Content (required): Was looking to build a query based on Department set, which table department set is stored. Versio…
-
How to format thousands with a space in an rtf template for HCM compensation change statements?Summary: How to format thousands with a space in an rtf template for HCM compensation change statements? Content (required): Hello, We are customizing compensation lette…
-
How to query email of a user account which is not linked to any person record?How to query email of a user account which is not linked to any person record? In this case person id can be null in per_users table and we can't join it with per_email_… -
Need an help for SQL queryHello Experts, I need some quick help in for my BI Report which is for Payroll module. I have a report which should return all personal payment method details irrespecti…
-
Oracle functions to calculate third quartileSummary: Content (required): Hello experts, we need to calculate THIRD QUARTILE for a set of employee salary amounts. The calculation should work in this way: For employ… -
How to get Projected End Date?Summary: How to get Projected End Date? Content (required): Hello, we wrote the follow piece of SQL select pc.* --to_char(PC.CONTRACT_END_DATE,'MM-DD-YYYY') from PER_ALL…
-
Help -> Audit/field Change Reports (Old Value -> New Value) - OTBI or BIPSummary Help -> Audit/field Change Reports (Old Value -> New Value) - OTBI or BIPContent Hello, Looking for a quick help, please. Searched the archives but could not fin… -
Case Statement Length of ServiceSummary: I would like some assistance on a case statement calculating length of service. Content (required): I am creating a case statement that looks at the assignment …
-
Question related to Knowledge base ArticleSummary: We have a subject area "Article Summary Historical Subject Area" in that we are looking at a attribute "Article View" where it related to the number of times us…
-
how can we go with below requirement in OTBI between 2022-23 data of absenceSummary: Hi Team, we have requirement in between 2022-23 data for absence accural balance for annual leave , enchased and lapsed. by using accural real time subject area… -
New tab on the home page of Oracle HCM (Me | My team | My client Group | My reporting) - languageSummary: New tab on the home page of Oracle HCM (Me | My team | My client Group | My reporting) - text depending on language Content (required): Hello, I am creating a n…
-
Assignment Changes including Effective SequenceSummary: Hi - I have a logical SQL built that is looking for changes in a DFF field that do not take place on a Sunday. It is supposed to capture the changes between row…
-
Pivot table column blankSummary: Content (required): Hi, I've created an OTBI report using the Workforce Performance - Performance Rating Real Time subject area, with a Pivot for the Manager Ra… -
Identify all actions/pages that contain Business TitleSummary: I need to identify all actions/pages that contain the Business Title in order to hide them, because client doesn't have them updated. Content (required): Versio…
-
Grade step start date per employeeSummary: Content (required): Hi, would anyone be able to point me in the right direction for creating a report that tells me how long each employee has been at their cur…
-
what metadata I should use to transfer Goals and performance doc while global transferring employeeSummary: I am looking to load transfer Goals and performance doc for person though HDL. Content (required): Metadata to transfer Goals and performance doc while global t…
-
Is it possible to build custom reports retrieving data in more active workforce plans?Summary: Content (required): Hello experts, we need to build custom reports retrieving compensation components values and making analysis based on data loaded in several…
-
Security views for disciplinary and grievances reportSummary: Security views for disciplinary and grievances report Content (required): Hi All, Is there any secured views available for disciplinary and grievances report? I…
-
Need list of user entities, DBI's, Routes and contexts from Fusion HCM R13 - 23B/23CHello All, We need the list of user entities, DBI's, Routes and contexts from Fusion HCM R13 - 23B/23C and this list can be used for both HCM Extracts & Fast Formulas. T…
-
unable to create new jobSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
Application Composer tableHow to query custom objects in database - currently hitting HZ_REF_ENTITIES table which seems to store some of the record data, however not finding what table to join to…
-
Mid Year Check In ReportSummary: Hi All, We have a requirement to fetch both the employee's & manager's responses to the questions for the 2022 Mid-Year Check In. Looking for a report which cov… -
How can I pull all reports and their permissions available /shared folder/custom/ pathSummary: How can I pull all the reports available in "/Shared folder/Custom/" path with their permissions through backend(sql) or any other alternate, with environment h… -
Need information of HCM table which store multiple choice answers for any questioners?Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
historical person EITSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
Assignment EFF Rest APII am trying to query from postman with the relevant platform_id information using Assignment eff rest api,(/hcmRestApi/resources/11.13.18.05/emps/{empsUniqID}/child/assi… -
calculate the past experience in HCM BI ReportSummary: calculate the past experience in HCM BI Report Content (required): My client requirement is to calculate the past experience and current organization experience…
-
Measurement to sum Actua Effort for yeach years starting from Current_DateDears, i've been trying to create performance tiles based on following measurements so to have sum of actual effort for the last 3 years splitted by years: Sum of Actual…