API to Check Item On-hand Quantity for Specific Inventory Organization
DECLARE v_api_return_status VARCHAR2 (1); v_qty_oh NUMBER; v_qty_res_oh NUMBER; v_qty_res NUMBER; v_qty_sug NUMBER;…
Read MoreInventory Location,Item Master Organization,Inventory, Sub Inventory Item Class and Item Creation
Inventory 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 MoreFusion HCM – Query for Element Entry Details
SELECT * 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 MoreFusion HCM – Query for Personal Payment Method Details
SELECT 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 MoreFusion HCM – Query for OTL Time Entries Details
SELECT 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 MoreFusion HCM – Query for Absence Accrual Balance
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
Supplier 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 process in Fusion Applications
Requisition 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
Function 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-
PO 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 More