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
-
HCM Embedded BIP ReportsSummary: How to show BIP report with parameter in Comp landing page Content (please ensure you mask any confidential information): I'd like to show Embedded BIP Reports … -
How to create a custom report in BIP with calendar .ics as attachmentSummary: If we need to create a BIP report which has calendar invite .ics as attachment along with other content in email, how can we do that? The requirement is the ema… -
Using the Termination Date value for counts between Calendar Month Start Date & Calendar Month EndSummary: I have read a lot of posts where individuals have been looking to get counts of employees who have a termination date between X & Y. However, if an employee has…
-
Assignment Manager (Unsecured) significantly slower in Workforce Performance Subject AreasSummary: Material / significant slowness that appear to be driven by [Assignment Manager (Unsecured)] folder within Workforce Performance Subject Areas, relative to othe…
-
Position DurationSummary Provides the duration of the workers in a specific positionContent This analysis provides the duration(in days) of the workers in all the positions that they hav… -
OTBI Dashboard only shows Indirect on promptSummary: OTBI dashboard is only showing Indirect in drop down prompt. Need to be able to choose between Direct and Indirect reports. Content (please ensure you mask any … -
OTBI - Calculate age in years and monthsSummary How to calculate the age in years and months?Content Hi, In OTBI I want to create a column which present the full age of the employee, for example 43.12 (means 4…
-
custom report in Thrive that relates to competency assessments within an individual’s profileHi, I am looking to build a custom report in Thrive that relates to competency assessments within an individual’s profile. There doesn’t seem to be a suitable native rep…
-
Need to know the table that contains bonus amount in Individual compensation.Summary: I'm looking for the table that stores Bonus amounts entered through the Individual Compensation module. I need the table that stores the person_id, assignment_i…
-
How to fetch the time period for fetching the salary details of the employeesSummary: I am working on a query to fetch the period name as per the payroll name selected from the LOV as parameter to fetch the salary details of the employees . I am …
-
How long applicant is staying in Each PhaseSummary: I want to create OTBI analysis to find out how long an applicant is staying in each phase of a requisition. I tried to use "Phase or State Duration" column from… -
Some Requisitions Dropped from OTBI Reports after Adding any Data Column that is not HyperlinkedSummary: Some requisitions were dropped from OTBI report after adding a data column that is not hyperlinked. Content (please ensure you mask any confidential information…
-
How to enable Report Job History to BI Consumer in Home page of BI Catalog?Summary: Please refer to the BI Catalog Home page of BI Author and BI Consumer. How to enable also Report Job History link in Home page of BI catalog to BI Consumer? Wha…
-
Error Installing BI Publisher - Set Word2007 flg failedSummary: Receiving an error when trying to install BI Publisher Content (please ensure you mask any confidential information): I am currently trying to install BI Publis…
-
SQL query to retrieve employee country (work relationship level)Summary: Content (please ensure you mask any confidential information): Hello experts, is there a way to retrieve Country field at the employee level by SQL query? If so… -
Matrix Manager Missing in BICC ExtractWe are using BIACM Extract (PVOs) to expose HCM data to PowerBI. Based on the document Rel13_21.x_BICC_HCM_Database_Mapping_with_ViewObjects, we understand that the PVO … -
"Test Notification Email Address" TableHi, Is it possible to query the BPM Worklist "Test Notification Email Address" from a table? Thanks, Derrin
-
The XML which we have pulled for the Job History doesn't hold the Job statusThe XML which we have pulled for the Job History doesn't hold the Job status if it is success or failed the against individual employee if the job is success of failure …
-
What are the options to have read only capabilities to BICC (BI Cloud Connector) in OracleWhat are the options to have read only capabilities to BICC (BI Cloud Connector) in Oracle
-
how to convert blob type to actual text in oracleSummary: the underlying tables store the xml data of employees in blob format, the customer wanted to see the exact content of this File_data column in output results.. …
-
Can we display the count in the graph while creating dashboard?Hi Team, I was trying to create a dashboard so what happening is if u out the cursor in the graph the counts are coming. So is it possible to display the counts in the t…
-
Capture in OTBI the Attachment field in a Person Profile Real Time subject areaSummary: Content (please ensure you mask any confidential information): hi there, There is a field "Attachment" out of the box field at the bottom of the Talent Profile … -
Time Change Request reportSummary: Hi All, Has anyone Developed a BI/OTBI Report on Capturing Details of Time Change Requests? We have a requirement and working on this. Appreciate if anyone can … -
Getting an Error in BIP Report: ORA-01427: single-row subquery returns more than one rowSummary: Currently, we are using the attached data model to generate a BIP report for Employee leave Details which is working perfectly. We got a requirement to get the … -
How to get one time data in audit tables after enabling auditing for HCM processes.Summary: How to get one time data in audit tables after enabling auditing for HCM processes. Content (please ensure you mask any confidential information): We have enabl… -
Generate a count of employee self service requests for certain employee data fieldsSummary: Is there a way in OTBI to generate a count of the number of times an employee changed personal information data in self-service over a period of time? My unders…
-
Need help in getting the query to fetch Candidate Extra Info from ORCSummary: I have been trying to look for tables that stores the Extra Info section details on the Candidate profile in ORC. If anybody has worked on it, can you share the… -
Absence Management - Leave Donation RecipientsSummary: We unable to find new subject area in 24D released version in S1 and S2. Subject Area Name — Absence Management - Leave Donation Recipients Could you please pro…
-
Steps to get BI Server LogsSummary: Steps to get BI Server Logs Content (please ensure you mask any confidential information): Hi Team, Greetings! For troubleshooting a report failure related issu… -
MMM-YY date format, grouping dates and showing same value in promptWhen doing the custom data format for a date field as MMM-YY, how can that be achieved in the prompt so that they're only having to select a single value for the month a…