People and Culture Blog

Item Master Data Management (IMDM) Implementation for a US based Dairy Cooperative Society

For any organization, Item Master is the core set of data that is used for most of the daily processes in an ERP system. Items are used to represent products…

Read More

adcfgclone.pl appsTier on a new setup or a clone fails with : sh: /u01/apps_st/comn/clone/bin/../jre/bin/java: /lib/ld-linux.so.2: bad ELF interpreter

Error: sh: /u01/apps_st/comn/clone/bin/../jre/bin/java: /lib/ld-linux.so.2: bad ELF interpreter: No such file or directory Cause: Missing library file on the Application node [applmgr@uat1] ls -lrt /lib/ld-linux.so.2 ls: cannot access /lib/ld-linux.so.2: No such…

Read More

Concurrent Programs failing in a newly cloned or created EBS Instance

Error : Environment:Environment java.lang.UnsatisfiedLinkError: no rwu in java.library.path Environment:getEnvironmentStrings java.lang.UnsatisfiedLinkError: no rwu in java.library.path REP-50125: Caught exception: java.lang.reflect.InvocationTargetException +—————————————————————————+ Start of log messages from FND_FILE +—————————————————————————+ +—————————————————————————+ End of log…

Read More

Rman Active duplication or Standby creation fails with RMAN-03002, RMAN-05501

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 More

R12.1.3 opmnctl services failed with Error code : 204 in a new setup

Error : 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 More

RPMs required when Migrating or Cloning to a new server – EBS R12.1.3

If 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 More

Fusion HCM Query to Fetch Payroll Details

SELECT 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 More

Fusion HCM Query to Fetch Assignment Details

SELECT 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 More

Fusion HCM Query to fetch HDL Load Error Details

SELECT 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 More

Allow Only Number and Decimals Using Jquery in Oracle Apex

1.        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 More