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
-
Query to find the representative of an employeeSummary Query to find the representative of an employee through AORContent Hi Experts, Is there any generic query available to get the representative of an employee thro… -
How to fetch current incumbent name for a Position_code/position idSummary: Please Help! Please share your insights ASAP! I need help in fetching current incumbent name tagged to a position code. I wrote the query like this : SELECT DIS…
-
In My report have two views is Pivot table view and Table view how can we schedule both to emailSummary: Hi Team, In My report have two views that is Pivot table view and Table view how can we schedule both to email. when i tried it goes to only table view report. … -
Ability to Report on Person Profile Competency Rating vs. Model ProfileSummary: Hello, I need guidance on whether it's possible to generate a single analysis that compares an employee's rated competency with the competency level associated …
-
Reporting employee access to dataHello Experts, It was rise as a demand the possibility to have a report on what employee has access of country data, i was trying to use per_person_secured_list_v and pe… -
DV Export To CSV export format- Date columns corrupted eg FIXE2LENGT02ATESummary: OACS - DV When exporting Table data from DV, Date Column are corrupted with text values similar to FIXE2LENGT02ATE value. When exporting Table data from DV as E…
-
While loading worker dat file, getting error the error for PersonLegislativeDataSummary: While loading the worker dat file getting the below error for PersonLegislativeData component You can't update this record because the SourceSystemId {SRC_SYSTE…
-
how can i fetch in bip report parent position name and parent position code for a position codePlease Help Me! Need to write a sql query for all the position details, in which i need to fetch parent position name and parent position code, how can i fetch that in b…
-
Need SQL query to get Set General PreferencesSummary: We need a query for the setup Set General Preferences as shown in the UI. We are unable to get Date format, Time format and Time zone as shown in UI page. For e…
-
OTBI dashboards using 2 fields prompts based on oneSummary: Dashboard with two prompts fields based on one field, and currency prompt Content (please ensure you mask any confidential information): I'm creating a dashboar…
-
Dependents not displaying on reportSummary: I had a detailed Benefits Enrollment report that had the employee's information and dependent information displaying on the same report. I started with Benefits…
-
Position Hierarchy queryHi, I need a small query that returns parent position name and code of positions. Is it possible for you to share the query about it? Regards -
What is the Subject area for Career Statement?Summary I want to know which subject area give "Career Statement" in OTBI -
Query to get the Job Requisition Approver details in BIP ReportSummary: we are trying to get the details of Job Requisition approval flow. precisely we wanted to get the details:::: with whom the Requisition is pending with? Content…
-
Trace the processing details of scheduled BIP ReportSummary: Trace the processing details of scheduled BIP Report Content (please ensure you mask any confidential information): Hi Team, Greetings! What are the best option… -
N/ASummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
HCM Quick Link Usage StatisticsSummary: Looking for statistics for individual pages access by role, user, etc… for a specific timeframe Content (please ensure you mask any confidential information): A…
-
Custom Payslip Prints Wrong AmountsHello experts! We use a custom format for our payslips. When the payslips are generated, if an employee has money going to different banks, and one prenotes and the othe…
-
Filter Talent Review 9-Box to Most Recent RatingSummary: Measures calculating percentage of employees by 9-box rating are including old ratings that have been filtered out of the analysis. Content (required): We have …
-
How to Track and Report Individual Positions in a Multi-Opening RequisitionIs there a way to report on individual position openings (e.g., number of openings, filled status, etc.) when using a single requisition for high-volume hiring in Oracle…
-
Is there any way to calculate day difference excluding weekends for Term date - Action date?Hi, We have a requirement to pull late/retro termination counts. The logic is if Action date - Actual Term date > 1 then it is marked as Late term. Is there any way to e…
-
Segregating the success and error report to different email id through SOAP UI Request PayloadSummary: I did a POC , using the SOAP UI Payload request i'm able to get the email notification to multiple emails. but the expectation was like for success report we wi…
-
Oracle HCM BI Table to retrieve employees Eligible for eligibility profileHi team, the client ask for creating a report to track Eligibility Profiles and Employees eligible for them. Is it possible to create a report like this "dynamically", s… -
Ability to pull criteria used in OTBI reports using Bi Data ModelHi, Do we have possibility to pull the Criteria used in OTBI reports using bi data model? Example: We have 100+ OTBI reports created for Module Enrolment under Learn Fol…
-
Oracle HCM Cheque Report any issues in customizing a template for itSummary: Have been asked to create a customized template for the seeded report and check printing into a tri-fold check printout. I have not dealt with this report befor…
-
Unable to Find "Placement Match Date" Field in OTBI - Workforce Management: Absence Real TimeWe're encountering an issue in Oracle Fusion HCM when reporting on Adoption Leave (Event Type: Placement) using the Workforce Management - Absence Real Time subject area…
-
I need to get a link to see a dashboard without settings pannel.Summary I need to get a link to see a dashboard without settings pannel.Content Hi, I have a dashboard that I have to link in the employees profile. Our customer needs t…Pablo Martinez de Villa De las Heras 122 views 16 comments 0 points Most recent by Tomasz 'TJ' Jublewski -
FTE and salary doubling on union querySummary: Complex union query. Reports work find individually but union is doubling up FTE and salaries for some records (not all). Content (please ensure you mask any co… -
which table having the United States Job Information under the Manage Job setupSummary: Hi Team, We could not find the right table for "United States Job Information under" the "Manage Job setup" We have gone through multiple table but we are unabl…
-
assignments rows are not end dating properly in bi publisherI am attempting to create a report on assignment data that will show all promotions for all employees. I have a functioning query that is pulling the correct data but us…