SELECT 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 MoreRequisition Creation and Approve Step 1: Login as Application User Step 2: you will be in home page as below Step 3: we need to navigate to Functional Setup Manager,…
Read MoreFunction to format the invoice number in AP: Please find the below steps for Function to format the invoice number in AP CREATE OR REPLACE FUNCTION XXXX_VALIDATE_INVOICE( p_invoice_number VARCHAR2)…
Read MorePO details reports Using xml element tag-: Please find the below steps for PO details reports Using xml element tag: CREATE OR REPLACE PACKAGE BODY po_details_test_pkg as procedure po_details_insert( v_errbuf …
Read MoreAPI to update the supplier: Please find the blow steps for API to update the Supplier DECLARE p_api_version NUMBER; p_init_msg_list …
Read MoreAPI to update the customer locations: Please find the below steps for update customer locations /* Formatted on 2/1/2018 6:54:52 PM (QP5 v5.163.1008.3004) */ DECLARE p_location_rec …
Read MoreAPI to update the attribute in AR invoice: Please find the below script for update the attribute in AR Invoice: DECLARE CURSOR c_ers_num is select trx_number,interface_header_attribute15 from ra_customer_trx_all where trx_number…
Read MoreObjective: To achieve, Dynamically adding or removing parent rows and include or exclude ‘n’ number child rows for the particular parent in the form. Apex Steps: 1. Create HTML table structure…
Read MoreMerge Statement :- ØThe MERGE statement reduces table scans and can perform the operation in parallel if required. ØIt helps us to conditionally insert or update data depending on the condition.…
Read More