Category 81
Discussion List
-
Personal Payment Method Processing OrderSummary: Hi all So I've seen this asked before on another post but there wasn't a solution. The processing order for Personal Payment Methods doesn't appear to match up …SimonG 49 views 6 comments 0 points Most recent by Gopikrishna Nerella Reporting and Analytics for HCM -
Drill down in OTBI Dashboard does not work correctlySummary: Drill down in OTBI Dashboard does not work correctly Content (please ensure you mask any confidential information): Hi, we created a Dashboard based on a OTBI R…Barile Alberto 17 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to fetch attachment report from document of recordsSummary: Hi Team, How to fetch report for attachments of each employee. Content (required): Documents of records - Documents type- COVID 19 Version (include the version …AjayKumar Maddipati 151 views 10 comments 0 points Most recent by sayeed_ahmed Reporting and Analytics for HCM -
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 21 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 32 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 2 views 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 3 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 4 views 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 698 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 11 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 85 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 2 views 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 …