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
-
Employee Names in Local LanguageSummary Employee Names in Local LanguageContent Hi All I need to display the Employee Names (Example: First, Middle and Last) in local Language (i.e. Arabic) I entered t… -
Need assistance for bursting paramter4Summary: Hi Everyone, I need your assistance regarding the bursting report. I want to add a data source in my subject email but when I try to add it gives me an error. c… -
ACA Eligibility Process caused duplicate Action Codes to appear with differing datesWe found that the ACA Eligibility Process is duplicating action codes on employees' assignment histories and it's not clear how we would easily query assignment records …
-
Does anyone know which tables I need to use to retrieve the Bonus Amount from the Compensation ModueSummary: I have a requirement to show last years performance bonus amount in a report and I have built most of the information using SQL but I am unsure what tables I ne… -
How to get one object from a string in OTBI ReportsHi Team, We have a requirement where would like to get a particular object from a string which has _ in it. Example: This the string we have in one column Evaluation_OLC…
-
Changes reportSummary All changes for specified fields in date rangeContent Hi, Is there a report that shows all changes in period: ID Name Effective Date Old Department New Departmen…
-
Department Changes - BI ReportSummary Shows department changes for an associate for the current yearContent Hello, We are looking for a BI Report that shows department changes for the current year. I… -
HTML Markup values are not working after 23B updateSummary: Good afternoon, I am having issues while trying to save an edit of code within the sandbox > HTML Markup. When making the replacement, the system only saves par…
-
How to find the OTBI report last run history?Summary: Hi All, Need to find the history of the OTBI report last run, user-wise. Content (please ensure you mask any confidential information): Version (include the ver… -
SQL Query to get HRBP assigned to an employee (when AOR uses organization hierarchy)Summary: We need a query to find HRBP assigned to an employee when Organization hierarchy has been used to assign the AOR(area of responsibility). It doesn't include any… -
Subject Area for Organization AttributesSummary Subject Area to display attributes from hr_all_organization_unitsContent We deployed few attributes at PER_ORGANIZATION_UNIT_DFF under Manage Organization Struct…
-
Dynamically logos of the different legal employer dynamically in BIPSummary: I am trying to display the logos of the different legal employers dynamically on my BI report. I created a SubTemplate folder where I store the logos The Sub Te… -
Need table name to pull "payroll processing status" field from time and laborSummary Need table name to pull "payroll processing status" field from time and laborContent Hi Team, Need table name to pull "payroll processing status"(Like Processed …
-
Authorization error with REST API to move candidate between phases / statesSummary: Content (required): Hello everybody, We are trying to use the rest api made available by Oracle to move a cadidate present in the system in the ORC module betwe…
-
Employee advance settlementSummary: 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 can I have a nested for-each group inside rtf report?Summary: How can I have a nested for-each group inside rtf report? Content (please ensure you mask any confidential information): If I add a for-each group outside anoth… -
adfdi-excel-addin-installer-current-user needSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Are infolets unsupported with 24A?Summary: I heard that starting with release 24A, that the support for infolets is discontinued. Is that correct and if so, is there similar functionality that can be use… -
Order by phase in Recuiting OTBI ReportSummary: Hi everyone, I tried to sort the phase in recruiting but it doesn't work can anyone tell me why? and what is the solution to sort the phase?
-
Embedded content for dashboardSummary: Embedded content for dashboard Content (please ensure you mask any confidential information): Hello experts, we would like to have a page in oracle that allows … -
Add Pay Group using data augmentation.We are trying to bring the field of Pay Group through data augmentation. Can you guide me to select the source tables (see attached screenshot)? which PVO contains Pay G…
-
How to deep link for employment info page for specific assignment?Summary Looking for a way to create a deep link to individual assignments on the employment info pageContent Hi! I've created an OTBI analysis that shows terminations sp… -
For FAW/OAC HCM - Learning subject area how do I get the actual score and actual hours?Summary: I'm new to Oracle and FAW/OAC but not new to data or analytics. We're trying to adopt FAW and OAC. We have the area turned on and are getting data on the learni… -
Query to retrieve employees with Termination Date nullSummary: Content (please ensure you mask any confidential information): Hello experts, please, could you share a query to retrieve employees without past and future actu… -
Query to get a data dump for a Benefit planSummary: We have a requirement to identify last updated by name and time stamp for Beneficiary related information on Life insurance plans. This is for legal reason we w…
-
OTBI Report created using AS OF DATE presentation variable gives multiple records.Hi, OTBI Report created using AS OF DATE presentation variable gives multiple records when we use the "Veteran Self-Identification status" value from the person real-tim…
-
Which table stores bip reports scheduled history data.Summary: Which table stores bip reports scheduled history data. Content (please ensure you mask any confidential information): Hi Team, Can some one will help me to find…
-
OTBI - Locating 5th occurrence of character using substring and locateSummary Several fields have been migrated into one field and need to split into separate columns into OTBIContent Several fields have been migrated across as one field s…
-
pending worker record not fetching in OTBISummary: Content (please ensure you mask any confidential information): Hello, We are creating a report to fetch the checklist task values from the configurable form fil… -
Is there any possibility to extract the emp image in JPG or PNG format from oracle through Report.If not from reports what is the possibility of extracting the image from Oracle Fusion HCM?