Category 81
Discussion List
-
How to enable dynamic password while generating the payslipSummary: Hi All, Requirement: I need to make payslip dynamic password protected. For Example - Date of birth of the employee. Thanks. Content (required): I followed the … -
Learning Management replaced by the Learning Record subject areaSummary: Can't find mappings for the new Subject Area Content (required): Goodmorning, in reference to "APRIL MAINTENANCE PACK FOR 21A" document which states: "Be aware … -
HR own position data not appearing for HR rolesSummary: Position Report is showing positions to the HR teams but its not showing their data Content (please ensure you mask any confidential information): I have a posi… -
Report to trace the elements costed from Journal entries along with transaction numberSummary: Report to trace the elements costed from Journal entries along with transaction number Content (required): Hi Team, Greetings! Once the entire payroll cycle is …Parag Hiremath 22 views 3 comments 0 points Most recent by Fazal Subhan Reporting and Analytics for ERP -
How can we add Date Prompt to DB prompt without using column from Subject areasSummary: We need to add a Dashboard prompt for Start Date and End Date. These two fields are just a Date parameter. We dont want to use any OTBI analysis column. How can…Abhishek Jois 33 views 6 comments 0 points Most recent by Abhishek Jois Reporting and Analytics for HCM -
Query to get Goal Approval StatusHello, For our report, we already have performance goals being listed in each row for every person. For each goals, we would require their approval status. However, when… -
Will the process Import User Login History affect performance?Summary: Client is asking if the process Import User Login History will negatively affect performance of the system or will it be negligible? Kindly let us know before w… -
what does below hint mean?Summary: SET VARIABLE OBIS_ORACLEDB_HINTS_FOR_TOP_SELECT='OPT_PARAM(''_push_join_predicate'',''false'') OPT_PARAM(''_complex_view_merging'',''false'') GATHER_PLAN_STATIS…Pritha 1 view 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Ability to submit Multiple Custom Bi reports(HCM) based on a single schedule (dynamic date param)Summary: We have multiple BI reports that take similar date parameters as input and produce different txt files as output. Since there around 60 unique scenarios we are …SarthakRohilla 2 views 0 comments 0 points Started by SarthakRohilla Reporting and Analytics for HCM -
How to add manager’s manager in OTBIWorking on a requirement to setup a report for any managers with incomplete performance documents. Eventually this will be sent as an alert to the manager and the 2nd le… -
Absence Balance MismatchHi All, Several employees have a balance discrepancy between the plan level and the accrual level. Is there a query available to retrieve this information and identify t… -
Employee Active Payroll balance reportSummary: Employee Active Payroll Balance Report Content: We have a requirement to include New Mexico Workers' Compensation for both Employee and Employer in the Employee… -
BI Report in payroll flowSummary: I’m trying to add a BI report in a payroll flow. I’ve done everything, and when I run the flow, the payroll gets calculated successfully. But when it reaches th… -
Attempted to use REPLACE (name, chr(38)||amp;, '&') function to remove 'amp;' after & in DM SQLSummary: Hello Forum: We have & showing up in place of 'Apples & Oranges' i..e. 'Apples & Oranges whether in a Report or a native HCM Extract XML output (View En… -
Is it still available to use the ORA_ASSN_REC_COMPLETE_PENDING - LOOKUP CODE from HR_LOOKUPS table?Summary: Content (please ensure you mask any confidential information): I am working one report and i need to know all sub status for one learner. I used the following q…ClaudiaManea 1 view 2 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM -
To streamline the alert notification process by ensuring line managers receive a single notificationSummary: To streamline the alert notification process by ensuring line managers receive a single, consolidated email containing all the training due alerts for their dir… -
Request Feedback for Performance EvaluationSummary: We have two performance evaluation in the year. In the middle of the year (CheckPoint) and the end of the year (Final). We start with feedback through Request F… -
SQL/OTBI query to get the Organization Payment Method and Payment sourcesSummary: SQL/OTBI query to get the Organization Payment Method and Payment sources Content (please ensure you mask any confidential information): We are looking a report…Visu 748 views 5 comments 0 points Most recent by GajavalliKoteswararao Reporting and Analytics for HCM -
vacation plan accrual balanceHi Team, Please find the attached screenshot below. I’m looking for the balance days of the Accrual Plan Balance in the Vacation Plan. Could anyone please let me know th…Karthikeyan s-Oracle 13 views 5 comments 0 points Most recent by Karthikeyan s-Oracle Reporting and Analytics for HCM -
How to enable horizontal scroll while creating/editing a xpt reportSummary: How to enable horizontal scroll while creating/editing a xpt report Content (required): Create a xpt report using data model having many columns, while trying t…Bhavna-Civeo 11 views 2 comments 0 points Most recent by PadmanabhamP Reporting and Analytics for HCM -
Need Table name to pull Time Entry Layout Component in Time and LaborSummary: Need Table name to pull Time Entry Layout Component in Time and Labor Content (please ensure you mask any confidential information): Hi, Need Table name to pull…Sujeeth Chinta 98 views 7 comments 1 point Most recent by Nathan CCC Reporting and Analytics for HCM
-
How to Group Payment Transactions Based on Running Total in Oracle BI Publisher E-Text Template?Hi everyone, I’m working on an E-Text Template in Oracle BI Publisher for a payment file, and I’m trying to group transactions based on a running total. The goal is to b…Karthik Adiga-Oracle 1 view 1 comment 1 point Most recent by Sivasekar Narayanan-Oracle Reporting and Analytics for HCM -
Understanding of columns in PER_SENIORITY_DATES_SETUP for the setup Configure Seniority Date RulesSummary: Hi Team, We need to understand the purpose and use of these TRIGGERING_FIELD_TYPE, SOURCE_FIELD, OBJECT columns under the table PER_SENIORITY_DATES_SETUP for th… -
need Sql Query of the balances with the below shown fieldsneed the SQl query which as fields like FIT Reduced subject witholdable FEDERAL TAX MARITAL STATUS FEDERAL NUMBER OF EXEMPTIONS STATE JURISDICTION INDICATOR YTD STATE TA…Kande_Likhitha 43 views 5 comments 0 points Most recent by Kande Likhitha Reporting and Analytics for HCM -
Sql query or Table to fetch Compensation Worksheet data in BIP report based on securitySummary: Sql query or Table to fetch Compensation Worksheet data in BIP report based on the roles assigned to the user. Content (please ensure you mask any confidential … -
"Last Logged on" Audit clarificationContent (please ensure you mask any confidential information): Summary: Wanting to understand where the "last logged on" value is derived from in the audit tables. For e…Emma Long 2 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
What is the minimum information necessary to update contractsSummary: Trying to create a data model and report to fix contracts that are missing PERIOD_OF_SERVICE_ID.I can run an SQL query on any of the tables, filter by PER_CONTR…Kameron Withak 21 views 3 comments 0 points Most recent by Ram_S06789 Reporting and Analytics for HCM -
Name of the table that stores the 'Location Based Access' infoSummary: Hi, I'm trying to figure out the table name that stores the 'Location Based Access' info. Navigation: FA → Tools → Security Console → Administration → Location …ganapathysundaramd-Oracle 22 views 3 comments 0 points Most recent by Jun Ye-Support-Oracle Applications Security