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
-
OTBI: Need to create a OTBI with 3 different compound layout and download it in excel (3 different sSummary OTBI: Need to create a OTBI with 3 different compound layout and download it in excel (3 different sheets in the excel: one tab for each compound layout)Content … -
Need Report for Number of times hire-date changed and all hired dates changed(in one field)Content Hello , We need the report of, Number of times hire-date changed and all hired dates changed(in one field). Is it possible in BIP? If yes, pls share me the sampl… -
No results after adding a column in subject area Workforce Management-Documents of Record Real TimeSummary: Content (required): Hi there We are trying to create OTBI report for a type of Document that we have. Actually, there are 6 specific custom made types, but when… -
BIP Report to pull only terminated employeeContent how can we pull only terminated employees who does not have any active record as of sysdate -30 Example: Employee terminated as of yesterday and rehired as of to… -
Time Stamp Diff based on User Entered Date ValueSummary: Time Stamp Difference function calculating with user prompted date value Content (required): I am using the following function to calculate years of service. I'…
-
Report of Delta for Old and New ManagersSummary: Hi, I need to create a report / analysis that would pull the results for the employees who have a new manager value. I have taken first steps by creating an ana… -
Hi, need to pull the Last Update date field by yesterdaySummary: I am building a report to automatically pull the old and new manager data by "Worker Assignment Details"."Assignment Last Update Date" which should be by yester…
-
1095cSummary: How to modify or update 1095c form? Content (required): Version (include the version you are using, if applicable): 21D Code Snippet (add any code snippets that…
-
Extract should have two Parameters 1. Expense End Date 2. Payroll NameSummary: Need input on how to add parameters in HCM extract. Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code s… -
Consolidated List of OTBI and BI Publisher Reports Posted (15 June 2015)Content The following is the list of published OTBI and BI Publisher reports for Fusion HCM between 14 April and 15 June 2015: * New Pack of Sample OTBI Dashboards and R… -
BI Publisher - conditional region reference other fields with formulaContent (required): Hi all, I am seeking some assistance using the BI Publisher word tool and am not that experienced. Is it possible to include formula within condition… -
Document Of records- Headcount - Document Count inconsistent resultSummary: I am trying to create a report with employees who have updated their 2nd covid vaccine on the DOR. I am able to get the count correctly. Then I am trying to get…
-
Issues Reporting on Development Goals after a Global TransferSummary: We are facing an issue in reporting (both OTBI and BIP) where an employee adds development goals and shows on our reports as expected, but after they have a glo… -
Enforce 2 decimal places after a column result in s query.Summary: The table column can have values like 2,3,56.78,34,8 etc. We need something on the query such that 2 must show up in query result as 2.00, 67 as 67.00,45.6 as 4… -
Filter to bring back the greatest Response Attempt NumberSummary: Content (required): We have an OTBI report using looking at employees Performance Review Rating (workforce performance - Performance Rating Real Time), for most… -
Promotions and Transfers Reports and Data ModelsSummary: Business need for two reports: promotions and transfers showing From and To information Content (required): Hi, everyone. We are looking for an example of a rep…
-
Non-Hired ApplicantsSummary: I need a report that lists all non-hired applicants in the past year. Content (required): Looking for a way to list all candidates that applied for open positio…
-
Documentation or Use Cases for putting reports on pages that use parametersSummary: Displaying reports on various pages that require page filters Content (required): We have successfully been able to add OTBI analysis to pages and filter on the… -
End user unable to schedule OTBI reportSummary After clicking on the more button of an OTBI analysis, the 'Schedule' option is not availableContent Hi, I've had a quick look, but couldn't find anything linked…
-
Tax rates vs Tax codes SQL from HMRCSummary: How to query how much percentage of deduction is associated for each tax code based on HMRC definitions? in which tables this data avilable? for example for BR …
-
Last Run in OTBIHi, I would like to history and last run date and time stamp of the OTBI report. (as when it was lastly executed) Is there any way to find. Thanks -
Table for Names details in Usernames page for External usersWe have a requirement to pull all External user's usernames (users without person record) with other details like FirstName, LastName and Email displayed in "User Inform… -
Resource Alert: Waitlist Exit AlertSummary: Hi All, I am working on a resource alert(alert composer) to achieve those learner details whose offering status change from waitlist status to some other learn …
-
Why I am getting no results after using Workforce Management - Documents Of Record Real TimeSummary: Why I am getting no results after using Workforce Management - Documents Of Record Real Time . When I am using column Person Number and Document Type there is n…
-
Job offer letters issuei am working on recruiting module in HCM Cloud i wanted to create Job offer letters. we have mulcible templates for same requisitions using some conditions in main templ…
-
Using Greater Than condition in RTF templateSummary: Content (required): Hi, I'm trying to use the following in an RTF template to select between two blocks of text. The value of…
-
Loss of benefit eligibilitySummary: Content (required): I am trying to report on employees who are losing eligibility to benefits based on recent life events processing. Can anyone help me with th…
-
Is there a way to track the 'Recommended Candidates' from the AI database tables back to the req?Summary: The aim is to develop a report to analyse how many 'Recommended Candidates' are actually being hired. Hence, looking for a way to report this using the AI table… -
Learning bi publisher report How to display learner activity's status and grade?Hello , How can we implement BI publisher report ,which displays the status and grade of activity of learners in a course. A course can have few offerings - and we would… -
Does JWT token Authentication supported in Generic Soap WebserviceSummary:Does Generic soap webservice for BIP Report scheduling support JWT Token Authentication Content (required):Does Generic soap webservice for BIP Report scheduling…