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
-
How can we add Rehire column status in OTBI report? Is there any filed is there ?Summary: In a report we need to add rehire column status but there is no field to add this in OTBI report Content (please ensure you mask any confidential information): … -
How to include a pdf attachment in a custom NotificationSummary: How to include a pdf attachment in a custom Notification Content (please ensure you mask any confidential information): Hi, we created a BI custom notification.…
-
How to ignore/remove broken image in the results for OTBI Analysis?Summary: There is a report we've created that has a column which pulls out from UI text and images pasted by the Users. Whenever the OTBI Analysis pulls them out, it alw…
-
SQL query to retrieve employee business titleSummary: Content (please ensure you mask any confidential information): Hello experts, I need to retrieve the employee Business Title. Do you have a query to share to re… -
BIP Bursting - Linked OTBI Reports HelpHi all, I'm wondering if anyone has a solution to a challenge I've encountered recently. I have two OTBI reports, a feed and a report where the report links to the feed.…
-
Fields are missing in the new table PER_SENIORITY_DATES_F that were present in the PER_PERIODS_OF_SEAfter migrating from Seniority Date Version 1 to Version 3, I noticed that some fields from the PER_PERIODS_OF_SERVICE table are no longer present in the new PER_SENIORI…
-
SQL query to fetch the list of values for each value setSummary: Business requirement is to fetch the list of active values for each value set code in excel. Need to develop SQL query to fetch Each segment Value set code valu…
-
Employee displays in analysis for indirect leader they no longer report up toSummary: We've kicked off our workforce compensation cycle. I have an employee who changed managers earlier this year. The indirect manager they previously reported to i… -
When I add a specific filter that I need, my report errorsI have an analysis in Workforce Learning - Learning Records Real Time Here is my SQL: SET VARIABLE PREFERRED_CURRENCY='User Preferred Currency 1',PREFERRED_CURRENCY='Use…
-
Loading Job Requisitions via HDL - What table is collaborators held in?Summary: I'm loading Job Requisition from one Oracle environment to another and I'm having trouble finding the table where Collaborators sit. Please advise. Thanks! Cont…
-
add date conditionSummary: Hi Everyone, I need your assistance in regards to add a date condition in analysis. I have to add a condition in the where clause and want out those positions. …
-
Future Dated Hires and Assignments not showing on reportSummary: I have created a report that picks up future actions. I am using the effective date from the Assignment Events Subject area and it picks up some of the future a… -
How can i get absences in BIP Report that where approved and then withdrawn/deleted .Summary: Hi, Please suggest tables that stores absences that where approved and then withdrawn , are there any transaction table that stores the data or absence events t…
-
Detail of oracle delivered standard reportsSummary: Need details of Oracle delivered standard reports Content (please ensure you mask any confidential information): We have a list of oracle provided standard repo…
-
Aggregate (sum) balance amounts by group in an RTF template (such as a Payslip)I've been asked to update a BI Publisher RTF template to consolidate a list of Payroll Balances by Reporting Name and Hourly Rate. The data in the XML extract appears in… -
Issue with the candidates merged record getting pulled into the OTBI reportSummary: We have built an OTBI candidate report to pull candidates in certain phases and states, we are excluding rejected by employer and withdrawn by candidate. We hav… -
Fetch the latest Completion record on the course level in Oracle Learning Cloud OTBI reportsSummary: Fetch the latest Completion record on the course level in Oracle Learning Cloud OTBI reports Content (please ensure you mask any confidential information): I am… -
How to exclude null values in eText output using RTF templateSummary: Example: My output file is comma separated .txt file generated using RTF template for HCM extract. I have 25 columns, out of which first 5 columns are fixed i.e… -
Primary key PVO legal entity / legal entity registration numberHi, Can I join these 2 tables using the 2 primary keys ? Will my legal entities match the registration number in a report ? Regards, Lauriane
-
Scheduled Report randomly times out.Summary: Hi, We have a data model report that pulls related Personal, Assignment, Comp and Payroll data for all Active employees based on an effective date parameter, th… -
BIP Query Job Roles and the roles assigned to themSummary: I'm trying to create a BIP query that shows me Job Roles and the roles assigned to them. I tried to create the report, but I can only get it to this point: sele…
-
OTBI filter show no dataSummary: Hello experts, we have a report for recruiting requisitions, but when trying to search in the values we get no data.. the list of values: SELECT DISTINCT IRB.RE…
-
Performance OTBI to extract Task Status, Section Names, Rating LevelsDears, we have a requirement to build an Analysis to extract performance document task status and ratings given to each document section. To do so we are crossing "Workf…
-
Date format in OTBI PromptSummary: How to change prompt values from datetime to date. Instead of "11/12/2024 00:00:00" I want "11/12/2024" Content (please ensure you mask any confidential informa…
-
Is it possible to combine one Finance subject area and also HCM subject area in a single OTBI reportSummary: Is it possible to combine one Finance related subject area and one HCM related subject area in a single OTBI report. Content (please ensure you mask any confide…
-
I would like a way to report that includes the following information in one report:Approval Status: Details of the goals. Pending approvals indicating whether they are with the HR manager or department. Goal details before HR approval: To allow review …
-
What can be the sql query to determine the person address subject to LDG address configuration?What can be the sql query to determine the person address which satisfies the condition of having all the mandatory address field by the person LDG address configuration…
-
Cancel scheduled reports in oracle fusionSummary: Cancel scheduled reports in oracle fusion Content (please ensure you mask any confidential information): Version (include the version you are using, if applicab…
-
How to get Month name as abbrevation concat with year in OTBIHi Experts, Can someone please help me how can we get Month name Concat with year in the same column in OTBI. We have a requirement to show the date's in the below scree…
-
SQL query to retrieve Division Name and Manager division display nameSummary: Content (please ensure you mask any confidential information): Hello experts, I need to extract the Manager Division full name field and the Division name as we…