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
-
We need BICC PVO's.Summary: Hi, We need BICC PVO's for for following items: People Group Data (Base Table: per_people_groups) Person Extra Information data (Base Table: per_people_extra_in… -
Populating the manager hierarchies for OTBI reportingSummary Provides the steps the populate the various manager hierarchies available in HCM OTBI Content This document provides details on the process that allows the custo… -
BI Publisher or OTBI Reporting on field used for ADP Workforce Now integrationHi, we do payroll in ADP Workforce Now and run a daily integration from Oracle. We want to know if it possible to report on this field used for the ADP integration only.… -
Sample SQL Query for IBANHi, we have to develop a report with the Employee's Personal Payment method Details like IBAN and bank account info etc. Please share if any sample SQL query to capture … -
OTBI - Static PDF attachment in email notificationSummary Is there any option to attach PDF in email notificationsContent Hello, We have a requirement to send email notification to new joiners along with user guides att… -
OTBI Report for Gross EarningSummary: Hi Can you please suggest if it is possible to create a report in OTBI that will provide gross earnings per element for a specific period? If it is possible, ca…
-
Periodic Accrual in OTBI giving wrong valueSummary: Requirement is to create a OTBI report that has accrual plan balance and accrual value from last period. Plan is incremental so every period, employees accrue a…
-
Oracle Report Rendering IssueHi All, When I try to run a report post mapping the fields using BI, the excel output is not generating. Getting the below issue.. But when I try to download the same in… -
How to get ESS job schedule end date for all scheduled ESS JobsSummary: How to get ESS job schedule end date for all scheduled ESS Jobs Content (please ensure you mask any confidential information): Hi Team, Greetings! We have multi… -
How to calculate Holidays and Weekends using groovy in Fusion Sales Cloud ObjectsSummary: The requirement is to calculate calculate age of the record which is (today()-creation date). But the age should exclude weekends and public holidays. Is this p…
-
OTBI - Retrieve Manager of indirect reportsSummary: OTBI - Retrieve Manager of indirect reports Content (please ensure you mask any confidential information): Hi experts, we would like to create a report for all … -
Custom LOV for OTBI PromptSummary: Custom LOV for OTBI Prompt Content (please ensure you mask any confidential information): Hello experts, we have created a report for all the managers within th…
-
Showing month name in graph in OTBI AnalysisHi, I've developed an OTBI Analysis which has a Graph view where I'm printing the Month in the X axis. The issue I'm getting is month is coming as numeric value but our …
-
Dashboard error.Summary: Hi Expert, I am getting below error while running the dashboard. If I provide the some Active LE and LDG and location still getting same error. Waiting for prom…
-
OTBI Map exampleSummary: OTBI Map example Content (please ensure you mask any confidential information): Hello experts, does anyone have an example of an OTBI report with a Map view? Th…
-
Query to get costing and Element linkSummary SQL Query to get costing segment columns and element link name columnContent Hi All, I want to pull the costing segments along with credit, debit amounts and ele…
-
How to Add Documents of Record from HCM Employment Flow to Approval BIP NotificationSummary: Has anyone had success adding the DoR added during an HCM employment flow to the approval BIP workflow notification? If so, what needs to be added? Thanks! -
Find Missing Registered Nurse LicenseSummary: Does anyone have a report to share that identifies active persons who are missing an RN License. Details: A person can have multiple different licenses. Using a…
-
Oracle Delivered ReportHi Team, I noticed that there's a delivered analysis for Leaver details categorized by Grade, Age, and Gender as separate analyses. However, is there a standard delivere…
-
How to increase the specific BIP report's runtime or timeout limit?The Query Time Out that has been configured within the Data Model>Properties was set to 36000. However, during running the report, I'm still getting this kind of error: …
-
emergency contacts reportsSummary: Hello, I've created report to get emergency contacts for employee below this only part of it. I'm getting error message that subquery return more then one row. …
-
SQL query or Table for Manage Knowledge User Groups in HelpdeskSummary: Hi we need a table where the Manage Knowledge User Groups information stored Need a columns "user group name, reference key, department under the setup Manage K…
-
Query to fetch the CURRENT and PROPOSED manager for failed transactions in BIP 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…
-
Dashboard for PerformanceSummary: Can someone please share any performance dashboard they have built? The standard dashboard available in system is very basic and not at a level suitable for pre… -
How To Update the Position Effective Start Date in HCM?Summary: We have HCM integration with our legacy payroll system (Chris21). Position data was loaded via Oracle HDL format at implementation time. The position effective …
-
Can anyone tell which table has USER_PERSON_TYPE column?Summary: I need to access data under USER_PERSON_TYPE column for a report query, the same information we can see from Person Management screen, can anyone tel me which t…
-
Pending worker conversion date in OTBISummary: Pending worker conversion date in OTBI Content (required): Hi, we would like to know where (Subject Area - Folder - Field) we can have the possibility to extrac…
-
OTBI Report not showing all the data thats in HCMSummary: Customised report not showing data for all employees but its in HCM Content (required): Hi We have a customised configuration for our DBS details. Up until last… -
I am transposing the columns into rows in Excel templateI am transposing the columns into rows in Excel template and also splitting each Employee into separate sheet, but values against rows are not coming up correctly and al…
-
OTBI report for Average allocation by Rating is giving 'No Result; however working for managerSummary: We have created custom OTBI report to display the Rating v/s Average Allocation %. The OTBI dashboard is created and the report is added to the dashboard sectio…