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
-
BIP query for Public Holiday assigned based on asg work location and showing in Calendar eventSummary: BIP query for Public Holiday assigned based on assignment work location and showing in View Calendar event in work Schedual. Content (required): -- AND PCEC.TRE… -
Help with Query optimization - Sum of Payroll Balance DimensionSummary: Only months into our post-implementation and our pension report query is consistently timing out. I believe I have narrowed down the offending portion of the da… -
Secured List Views: For any information related to SLVs please raise a Service RequestSummary: I raised an SR some days ago asking for some additional information on Secured List Views (as instructed by Doc ID 2708546.1). I got this response: Your questio… -
Pull birthdays in the next 90 days in OTBI.Summary: Hello all, How to pull birthdays in the next 90 days in OTBI. The logic I currently use is to pull birthdays that fall between WEEK OF YEAR ( CURRENT_DATE) and …
-
List of Seeded Reports for Oracle HCM CloudSummary: Hello, Is there a place where Oracle list out all of the seeded reports they provide? Content (required): Version (include the version you are using, if applica…
-
How to calculate Age with Person Date of Birth and Effective Date variableSummary: Calculating Age using Person Date of Birth and the Effective Date variable based on a date entered in the prompt. Content (required): I need to calculate Age us…
-
Remove Year from Date in OTBI ReportSummary: I need to set up a scheduled report to go out and not reflect the year of the birth dates. I know how to change the format in the Column Format, but once the re…
-
Scheduled report to pull employees with birthdays per monthSummary: I need a scheduled report to pull the employees with birthdays per month. For example on Feb 10, It should pull the list of employees who have the birthdays in … -
how to read webcenter files using python script and extract informationcan we read the files which we uploaded through bi reports bursting into webcenter servers. while i'm the downloading the files in the webcenters they are not readable. -
How to customize change personal information workflow notification?Summary: How to customize change personal information workflow notification? Content (required): Hi All, Need to customize the change personal information WF notificatio…
-
is there a way to get data from tables?Apologies for the basic question but is there a way to get data from the Geog Trees, calendar events, work patterns and work schedules please? This is from the backgroun… -
there is a way to check access for the report who have ?Summary: Hi Team, we have placed the BI reports in shared folder and some of have given the access the reports based on request but now we need to track the report who h… -
BIP report to fetch employees that are included in Automated Grade Step ProgressionSummary: Other than GSP_ELIGIBILITY_FLAG from PER_ALL_ASSIGNMENTS_M, is there any tables which can identify employees that are included in Automated Grade Step Progressi… -
excel output, splitd linesSummary: Content (please ensure you mask any confidential information): HI team, I have a report that one of the field is HTML with new lines, the problm starts where I …
-
Where are the assignment values stored in system in compensation change statements?Summary: ASG_SEG_NUMBER_VALUE,ASG_SEG_TEXT_VALUE1 stored in system? Are they DFF? Content (please ensure you mask any confidential information): Version (include the ver…
-
Import Oracle Taleo Recruiting to HCM Fusion.Summary: Hi Team, Could you please let us know, Candidate Imported form Taleo to fusion through "Import Oracle Taleo Recruiting Cloud Service Data" process, in which tab…
-
-
Mass upload comments for Formal Bonus Payouts in Compensation Change StatementsSummary: Our system does not currently have the ability to mass upload comments/memo on the parent row or child row for cases of overrides to the payouts/exceptions to t…
-
PDF output with color background other than whiteDear Experts we have a requirement to print a RTF report - PDF output with black background. We have made the required changes. 1. On the Design tab, select Page color b…
-
Date Paid is Current Date (the date the report runs)Summary: I have an OTBI report using the Payroll Balances Real Time subject area. The report is scheduled to run every 14 days which is also the Date Paid. How can I set…
-
Oracle OLM - Business wants to track a user and his assigned course progress by date wise break-up.For ex: ******* 1. Maria John did a course on "Sexual_Harassment". She started the course on 1st Jan and stopped after an hour, again continued on 2nd Jan for an hour an…
-
Requirement to have a report that provides details of changes made to UDTSummary: We have a requirement to have a report that provides details of changes made to User defined tables. can anyone please help us on this requirement? Content (ple…
-
Actual Goal Names are not reflecting in the Analysis ReportSummary: We are trying to build OTBI Analysis Report with the following attributes from Two Subject areas: Person Number, Name, Position Name, Unit, Department Name, Man… -
Bringing the latest record of the person instead of all records in the OTBI reportHi, I have an Analysis report that contains employee background information, and an employee may log in and leave work more than once, and all records of this person com… -
Why Oracle did not create Per_All_Assignments_D View In HCM CloudSummary: Dear All, Since we can't create any objects in the Cloud Database like Views, why oracle did not bring one of the most useful HR Assignment view used on the EBS… -
How to get all Active and Inactive Records Regardless of Assignment Type Except for Inactive PendingSummary: Hi All, I have a report that get all Active and Inactive Records but I want to Exclude Inactive Pending Worker only. Any one have already tried this? Trying to …
-
SQL to get current and proposed assignment DFF values for notifiationSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Payroll run exclusion GroupSummary Identifies employees who are in an exclusion group and will not be included in the payroll run.Content Hi, Can you please suggest if Payroll exclusion group is a… -
Calculations with Sum Distinct for Pivot TableSummary: Hi! I am hoping for some guidance regarding a report I am making to predict retirement in my company. I built a formula to estimate the likelihood of retirement…
-
"Periodicity Prime" data not found in subjects areaHello, I'm creating a report about contractual compensation, in this report i have many columns about Primes (bonus) (type of prime, amount, etc). I need a column that w…