Category 81
Discussion List
-
What is the specific report template to which 'Edit Work Relationship' transaction points ?Could someone please confirm which seeded report template and data model (DM) are being automatically utilized for the 'Edit Work Relationship' transaction? There are tw…Aseem Bhawalkar 1 view 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Human Capital Management -
Participant Feedback Report RequestSummary: Does anyone have a good way to report on 360 participant feedback within a performance document? We've tried to use the Workforce Performance - Performance Rati…Anton Rzhanov 14 views 3 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM
-
BIP Report Query to Fetch Participant (Matrix Manager ) as Reviewer in Perfofmance DocumentSummary: Can anybody Please share the query to Fetch details of Participant Name as Matrix Manager as Reviewer along with Review Period and Performance Documents in Perf…MilanMohanty 102 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Query to fetch overall rating from Performance documentSummary: Hi All, Can you help me in sql query to fetch overall rating from the performance document? TIA Version (include the version you are using, if applicable): Code…ShawShankk 1.9K views 5 comments 0 points Most recent by Vikas.puppala Reporting and Analytics for HCM
-
Learning Records Real Time - Reporting on RecommendationsSummary: Trying to report on recommendations using the Learning Records Real Time subject area. It appears that a recommendation is an event which doesn't appear in the …Rob F 1 view 3 comments 0 points Most recent by Tomasz 'TJ' Jublewski Reporting and Analytics for HCM -
I embedded a BIP report in front end. But refresh button is causing problem.I embedded a BIP report in front end. But refresh button is causing problem. First I have to click apply and then refresh button (green higlighted) then only report is a…
-
How to generate the BIP report with the user time zone rather than the server time zone?Summary: Our reports are generated in UTC time zone, especially when it comes to Exit reports the LWD & the submitted dates are not matching because of time zone differe…Elavarasan S 16 views 2 comments 0 points Most recent by Elavarasan S Reporting and Analytics for HCM -
SQL Query to get HRBP assigned to an employee (when AOR uses organization hierarchy)Summary: We need a query to find HRBP assigned to an employee when Organization hierarchy has been used to assign the AOR(area of responsibility). It doesn't include any…Aloka Bhattacharya 1.5K views 6 comments 1 point Most recent by User_6I7ZA Reporting and Analytics for HCM -
How to get the USER_NAME or USERID into default value of a data model parameterSummary: How to get the USER_NAME or USERID (or exquivalent) into default value of a data model free form string parameter Content (required): In a data model I would li…
-
SQL query to retrieve the approval history dataSummary: I wanted to create an SQL query to retrieve the approval history data which is in Transaction Console for process name 'Journal Approval' Content (please ensure…Sonia V 34 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
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. …AjayKumar Maddipati 31 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
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 …Emily Cox 111 views 8 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
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…Lucas B Maciel 22 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
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…Keith Dunlop 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
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…Gali Sujana 12 views 2 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
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…ANNU10 13 views 4 comments 0 points Most recent by Carl Bequilla-Oracle Reporting and Analytics for HCM
-
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…Opkey PA 21 views 3 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
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…MYassikaya 31 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
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 -
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…User_2025-03-07-05-34-02-150 1.4K views 9 comments 0 points Most recent by User_YG5HR Reporting and Analytics for HCM
-
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…Parag Hiremath 24 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
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…
-
hwm_timecard_report.timecard_totals - Specification (Oracle Fusion)An Oracle Fusion seeded report for displaying bulk timecard approvals is executing the TimecardApprovalNotificationBulkReport which displays a PDF on screen. The data mo…Scotty C 81 views 1 comment 0 points Most recent by Srikanth Mandapati Panduranga-Support-Oracle Workforce Management
-
Is there a log or audit report available that tracks the changes made to the existing schedules?Summary: Can we access logs for changes in the report schedule? Is it possible to generate a historical report of those changes? Content (please ensure you mask any conf…mmgascon 11 views 1 comment 0 points Most recent by Srikanth Mandapati Panduranga-Support-Oracle Workforce Management
-
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…Henry Imgrund 23 views 2 comments 0 points Most recent by Henry Imgrund Reporting and Analytics for HCM
-
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 …
-
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…