ORA-02266: unique/primary keys in table referenced by enabled foreign key Cause: An attempt was made to truncate a table with unique or primary keysreferenced by foreign keys enabled in another…
Read MoreInventory Location,Item Master Organization,Inventory, Sub Inventory Item Class and Item Creation Step 1: Login as Application User Step 2: you will be in home page as below Step 3: we…
Read MoreSELECT * FROM per_all_people_f peo, per_all_assignments_f asg, per_person_names_f per_name, per_periods_of_service ser, per_person_types_tl per_typ, per_legal_employers ple, pay_rel_groups_dn payrel, pay_assigned_payrolls_dn papd, pay_all_payrolls_f pay, pay_element_entry_values_f peevf, pay_input_values_f pivf, pay_element_entries_f peef, pay_element_types_f petf, pay_entry_usages…
Read MoreSELECT per_pay.* FROM per_all_people_f peo, per_all_assignments_f asg, per_person_names_f per_name, per_periods_of_service ser, pay_pay_relationships_dn pay_rel, pay_personal_payment_methods_f per_pay, pay_org_pay_methods_f org_pay, pay_bank_accounts bnk_act, per_legislative_data_groups ldg, per_person_types_tl per_typ, per_legal_employers ple WHERE asg.person_id = peo.person_id AND ser.person_id…
Read MoreSELECT papf.person_number emp_id, TO_DATE (TO_CHAR (sh21.start_time, ‘DD/MM/YYYY’), ‘DD/MM/YYYY’ ) start_time, TO_DATE (TO_CHAR (sh21.stop_time, ‘DD/MM/YYYY’), ‘DD/MM/YYYY’ ) stop_time, sh26.attribute_category elements, sh27.status_value, ROUND (SUM (sh21.measure), 2) measure FROM per_all_people_f papf, per_all_assignments_m asg, …
Read MoreSELECT peo.person_number emp_id, aapft.NAME absence_plan_name, acc_ent.end_bal balance FROM per_all_people_f peo, per_all_assignments_f asg, per_person_names_f per_name, per_periods_of_service ser, per_person_types_tl per_typ, per_legal_employers ple, anc_absence_plans_f_tl aapft, anc_absence_plans_f aapf, anc_per_accrual_entries acc_ent WHERE asg.person_id = peo.person_id AND…
Read MoreSupplier Refund Process in Oracle Fusion Applications Please find the below setups for Supplier Refund Process 1. Create Prepayment Invoice 100000 2. Process Payment for Prepayment Invoice 100000 3. Create Standard Invoice 80000…
Read More