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
-
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…
-
In OTBI analysis, how can I gather the periodic accrual value for the accrual balance column?23C (11.13.23.07.0) Hi all, We are unable to find the periodic accrual value in our monthly PL report. I'm attaching one screenshot, where the periodic value and absence…
-
Need an help for SQL queryHello Experts, I need some quick help in for my Bi Report which is for Payroll module - The report shows data for some departments without any issue and for some months …
-
Total Salary by Division for the first of each month - OTBISummary: I feel like maybe this is very obvious and I'm overlooking it. But here it goes: We want a report that total salary for a given division on the first of each mo…
-
Cannot Modify Chart Properties on BI Publisher for WordSummary: I am trying to edit an rtf document using BI Publisher for Word to increase the size of the chart and the font. When double clicking on the graph/chart to displ…
-
In which subject area can I find 'Business Title'Summary: I need to create a report/analysis, showing all assignments, where job is not equal to Business Title. Content (required): I have started on an analysis with su…
-
BI Publisher Emergency Contact ReportSummary Building Emergency Contact Report in BI PublisherContent Hi Everyone, I am currently struggling in producing a BI Publisher report for emergency contacts, i know… -
Custom Error message on OTBI Reports / Dashboard Reports DisplaySummary: We need to display the custom error message on OTBI reports. Please provide the workaround for this. Content (required): OTBI Reports / Dashboard Reports - Disp…
-
"Selected Performance Goals Report" does not display the correct goal plan end dateSummary: I believe there may be a bug with this report, where the SQL is selecting the wrong Goal Plan End Date. While the OTBI subject areas (i.e. Workforce Goals - Goa… -
Is there any OTBI Subject area to generate the Delegation Details - Delegate Role,Delegate and ProxySummary How to create one OTBI report for Delegate and Proxy User and the Delegation DetailsContent Hi All, Could you please let me know if there is any way to create OT…