Get Started with Redwood for Oracle Cloud HCM Begin Now
Reporting and Analytics for HCM
Discussion List
-
How to return the max value based on a column?Summary: Content (please ensure you mask any confidential information): I've created a report using Workforce Learning - Learning Records Real Time subject area. The fol… -
Transaction table is not storing the details of all offer approvalsSummary: Hi Team, We have a requirement to get the offer approval history from transaction table. The issue we are facing is the table we are using does not have the det… -
Error message: ORA-01898: too many precision specifiersSummary: Error message: ORA-01898: too many precision specifiers Content (please ensure you mask any confidential information): Hi, we have run the SQL query I attached,… -
Query to extract attachment URL (i.e. Document of Records; Skill and Qualifications)Summary: Content (required): Hello experts, do you have a query to retrieve the attachment URL? In other words, I need to retrieve the URL for some Document of Records a… -
Reported Time Card Real Time Performance Very SlowSummary: Reported Time Card Real Time Performance Very Slow Content (please ensure you mask any confidential information): Good Day, Is there a way to improve the perfor…
-
Ability to report out who joins talent community but does not apply to a job postingWe went live a few months ago with ORC, and in our setup we enabled the talent community and have it showing on the job search results page with a general application be…
-
Issue with Report Changes Not Reflecting After Clicking SaveWe encountered an unexpected behavior with one of our reports. We made some updates to the bursting, clicked the save button, but when we checked the bursting again, the…
-
Learner evaluation reportSummary: Content (please ensure you mask any confidential information): Hi Team, I have created learner evaluation report where in I want each question text to be a colu…
-
How to Reporting through OTBI answer to a scoring questionnaires in learningSummary: I'm not able to extract answers to a scoring questionnaires which has a subscriber "Learning assessment". The users access the questionnaires through a learning…
-
Derived Standard Working Hours - SQLHi all, we're looking to add the following field to a SQL built report using BIP. 'Derived Standard Working Hours' (we can see this in Work Relationship - Assignment Det…
-
OTBI for Model Profile vs Person Profile Competency Gap AnalysisSummary: Content (please ensure you mask any confidential information): Hello Experts, We have a requirement to pull Person Talent Profile Competencies ratings and Model…
-
Query to fetch overall rating from Performance documentSummary: Hi All, Can you help me in sql query to fetch overall rating from the performance document? TIA Version (include the version you are using, if applicable): Code…
-
How to disable Export -> Data in selected OTBI reports?Summary: Hello, Do you know how to disable Export -> Data in selected OTBI reports? When user clicks Export -> Formatted -> Excel, the report contains only columns that … -
Model Profile vs Person Profile Competency Gap AnalysisContent Hi All, Wondering if anyone had a great analysis comparing the competency minimum proficiency level identified in a model profile to the assessed competency prof…
-
BIP Data Model Error: ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actualSummary BIP Data Model Error: ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual: 4445, maximum: 4000)Content Hi, Can anyone please suggest a…
-
Table to get fixed accrual of an employeeSummary: We have a customer requirement to create custom report which displays the fixed accrual for a person and the accrual as of period. We are looking to get the fix…
-
Absence update history not availableSummary: Currently when the employee update the existing absence record and submit it, the back end does not hold both the data on the absence entry table. Unfortunately…
-
OTBI Report does not show Person Legislative information DetailsSummary: Our business has created few reports where they are capturing personal details of users and it includes person legislative info but in OTBI the data is coming b…
-
Data isn't retrived due to special character in Business Unit promptSummary: Hey, We have an issue with our Performance dashboard. The dashboard is based on OTBI analysis reports and the Performance subject area. One of our BU was create…
-
Query to fetch approvers listWe are trying to customize performance seeded report and trying to fetch the list of approvers/managers who has approved the document. We are trying to get the details f…
-
How to identify C-Suite leader in headcount reportI'm trying to add a column that will identify our C-Suite leaders for each employee in headcount report. C-Suite leader would be the CEO - 1 or whomever is the top-most …
-
What is a variable formula that uses the standard working hours converting our analysis to days?Summary: What is the formula that we can use for our Absence Analysis that will use "standard hours" (which isn't always 8 for us, sometimes it's 24, sometimes 7.25 etc)…
-
Absence Report CalendarSummary: Hello Experts I have been tasked to develop a Calendar Report that looks like the attached as the screenshot system will be replaced soon. I am uncertain how at… -
Subject Area for Question in Question LibrarySummary: Hi Experts, I am trying to look for OTBI subjects areas for reporting on question which are present in Question Library. Main focus of reporting would be time o… -
Link between OTL time Entries with Element Entries or Calculation cardsContent Hi All, We enter data in OTL and transfer batch. Then calculation cards and Element entries will be created. We need SQL Query/OTBI link between OTL time entries…
-
SQL How to get point information for questions at manage activities -> (i) information -> ViewSQL How to get point information for questions at manage activities -> (i) information -> View Content (please ensure you mask any confidential information): Version (in…
-
Query to get department from PAY_COSTS tableSummary: Need to link the department to the PAY_COSTS table. How can I link the department (organization_id) to the PAY_COSTS table through other tables? Content (please…
-
url enrollement link otbiSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
BIP Report Query to Fetch Participant (Matrix Manager ) as Reviewer in Perfofmance DocumentSummary: Can anybody Please share the query to Fetch details of Participant Name as Matrix Manager as Reviewer along with Review Period and Performance Documents in Perf… -
How to retrieve data from excel dataset into Fast formula?Summary: How to retrieve data from excel dataset into Fast formula? Content (please ensure you mask any confidential information): I have this data model with excel base…