Error : RMAN-03002: failure of Duplicate Db command at 09/03/2021 03:44:34 RMAN-05501: aborting duplication of target database RMAN-03015: error occurred in stored script Memory Script ORA-19845: error in backupControlFile while…
Read MoreError : Cause : Missing a mandatory RPM and symbolic links to the generated lib file. Solution: Install the rpm : libdb-5.3.21-25.el7.i686 create the below symbolic links as root :…
Read MoreIf not using the pre-install rpm, the following packages (or versions of packages) are not part of the OS distribution media and must be downloaded separately (from http://oss.oracle.com/projects/compat-oracle/files/Enterprise_Linux/) for both Oracle Linux…
Read MoreSELECT papf.payroll_name, papf.period_type, pcs.consolidation_set_name, ptp.period_name, to_char(ptp.start_date, ‘YYYY/MM/DD’) start_date, to_char(ptp.end_date, ‘YYYY/MM/DD’) end_date, to_char(ptp.cut_off_date, ‘YYYY/MM/DD’) cut_off_date, to_char(ptp.regular_earn_date, ‘YYYY/MM/DD’) date_earned, to_char(ptp.regular_process_date, ‘YYYY/MM/DD’) payroll_run_date, to_char(ptp.default_paydate, ‘YYYY/MM/DD’) date_paid FROM pay_all_payrolls_f papf, pay_time_periods ptp, pay_consolidation_sets pcs…
Read MoreSELECT papf.person_number, ppnf.full_name employee_full_name, ppnf.first_name, ppnf.last_name, to_char(ppos.date_start, ‘MM/DD/YYYY’) date_start, paam.assignment_number, paam.primary_flag, paam.assignment_status_type active_status, paam.bargaining_unit_code, aapf.payroll_name, PAAM.ASS_ATTRIBUTE6 attribute_value FROM per_all_people_f papf, per_all_assignments_m paam, per_person_names_f ppnf, per_periods_of_service ppos, pay_payroll_assignments ppa, pay_pay_relationships_dn pprd,…
Read MoreSELECT hddsb.data_file_name, hdds.ucm_content_id, hdds.creation_date, hdds.data_set_name, hdds.imported_status, hdds.loaded_status, hdds.import_lines_success_count, hdds.import_lines_error_count, hdds.import_lines_total_count, hdds.import_success_count, hdds.import_error_count, hdds.loaded_count, hdds.error_count, hdpl.pval018 assignment_number, hdpl.pval008 element_name, hdpl.pval010 ldg, hdpl.imported_status import_status, hdll.validated_loaded_status validation_status, CASE WHEN hdll.validated_loaded_status = ‘UNPROCESSED’ THEN…
Read More1. Overview This document explains how to Allow only Numbers and Decimal Using Jquery in Oracle APEX. 2. Technologies and Tools Used The following technologies has been used to achieve…
Read More1. Overview This document is about table function to return lookup values For LOV’s in oracle apex. 2. Technologies and Tools Used The following technologies have been used for table…
Read MoreSALES ORDER Warranty Item Setup STEP BY STEP Process STEP1: Create Warranty Item Navigation : Inventory -> Item -> Master Item CREATE A NEW WARRANT ITEM CODE HS-T7PSWAR-03 ITEM MASTER…
Read More1. Overview This document is about Interactive Grid – Add row from another report using JavaScript in oracle apex. 2. Technologies and Tools Used The following technologies have been used…
Read More