Oracle database script for all modules
Find out application base path which is useful to find out the file on application server. SELECT fa.application_id "Application ID", fat.application_name "Application Name", fa.application_short_name "Application Short Name", fa.basepath "Basepath" FROM...
/ Posted by KapilPayroll details of employees with all the attributes. SELECT TO_NUMBER (pap.employee_number) employee_number, INITCAP (pap.title) || ' ' || (pap.full_name) full_name, NVL (pet.attribute1, pet.element_name) Description, SUM(DECODE (pec.classification_name, 'Earnings', result_value, 'Deductions', result_value...
/ Posted by KapilGet the details about the loan of employees. Change the effective date as required. SELECT DISTINCT papf.EMPLOYEE_NUMBER, papf.full_name, pbv.balance_name Loan_Detail, MAX (pbv.VALUE) Loan_Remaining_Amount, hou.name Department_Name FROM per_all_people_f papf, per_all_assignments_f paaf,...
/ Posted by KapilList of employee with all the details like Name, Gender, Nationality, Department, Hire date & Address. /* Formatted on 8/21/2021 9:28:51 PM (QP5 v5.136.908.31019) */ SELECT papf.employee_number "Employee Number", papf.title...
/ Posted by KapilBank details of employees with bank name and account. SELECT DISTINCT a.employee_number, a.full_name employee_name, TRIM (d.segment1) bank_name, TRIM (d.segment2) bank_name_arabic, TRIM (d.segment6) IBAN FROM per_all_people_f a, per_all_assignments_f b, pay_personal_payment_methods_f c,...
/ Posted by KapilUser can find out the number of record in table SELECT table_name, TO_NUMBER(EXTRACTVALUE ( xmltype(DBMS_XMLGEN.getxml ( 'select count(*) c from ' || table_name)), '/ROWSET/ROW/C')) COUNT FROM user_tables WHERE table_name LIKE...
/ Posted by KapilDuring the debug of form user face issue to find out the trace file of the activity. Below script make it easy to find trace file through concurrent request id....
/ Posted by KapilEasily identify executable file name of concurrent request. SELECT fcpv.user_concurrent_program_name concurrent_program_name, fe.execution_file_name source_name, fl.meaning program_type FROM apps.fnd_concurrent_programs_vl fcpv, apps.fnd_executables fe, apps.fnd_lookups fl WHERE fe.executable_id = fcpv.executable_id AND fl.lookup_type = 'CP_EXECUTION_METHOD_CODE'...
/ Posted by Kapil