Category 81
Discussion List
-
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 35 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 112 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 23 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 24 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 32 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 84 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…
-
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…Ankita Mohanty 21 views 0 comments 0 points Started by Ankita Mohanty Reporting and Analytics for HCM
-
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… -
Employee time card punch in, punch out details SQL query in OTL fusion HCMSummary: Hi Team, We have a requirement to send notification to employees who has missed their time card punch in, punch out. Can anyone please help me with the sql quer…Prasad Singamaneni-Oracle 111 views 1 comment 0 points Most recent by Srikanth Mandapati Panduranga-Support-Oracle Workforce Management
-
How to Extract More Details from Oracle Access Logs (Failed Logins)Hello, We are currently trying to understand if there is a way to extract more detailed information from the Oracle access logs. At the moment, we are only able to extra…Rebecca Bortone 24 views 5 comments 0 points Most recent by Jun Ye-Support-Oracle Applications Security
-
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…Boopathy Laxmipathi 23 views 2 comments 1 point Most recent by Konda Reddy A Reporting and Analytics for HCM
-
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…
-
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…LTalbott2 22 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM