Blog / Category
AP
23 articles in this category
Creating a Supplier in Oracle Fusion 24D
Creating a Supplier in Oracle Fusion Creating a supplier in Oracle Fusion involves several key steps to ensure accurate setup and integrati…
Query to get Invoice,value of invoice and cash collected details:
Introduction: This query will fetch you the below data.1) Total Number of invoices2) Total value of invoices (USD)3) Cash collected (USD)The input parameter pas…
Non-PO invoice report in Cloud
Introduction: This blog has the script to get the Non po invoice details in Oracle Cloud application for Audit purpose. Cause of the issue: Auditor wanted to se…
Query to get the tax type and tax accounts details.
SELECT hou.name Entity_name, tax_type_id, tax_type_code, tax_type_name, (SELECT concatenated_segments FROMapps.gl_code_combinations_kfv WHEREcode_combination_id…
Query to get ship to and Dist location mismatch invoices details.
select distinct hou.name, a.org_id, a.invoice_id, a.invoice_num, a.invoice_date, a.attribute11 ship_to d.segment4 dist_loc, aps.vendor_name, apsa.vendor_site_co…
AP Open invoice extract in EBS
Introduction: This script will extract the AP open invoices select aia.invoice_num, aia.invoice_currency_code, DECODE(aia.PAYMENT_STATUS_FLAG,’N’,’UN-PAID’,’P’,…
Lower Deduction Cost
Lower Deduction Cost Details Introduction: This report will provide LDC details. Cause of the issue: To get the remaining amount pan wise. How do we solve: So,…
Supplier Contact Details
Supplier Contact Details Introduction: This report will provide active supplier contact details. Cause of the issue: To apply TDS tax deduction against open inv…
Oracle R12 Internal Bank Account Query
SELECT hou.name operating_unit, xep.name legal_entity, cebb.bank_name, cebb.bank_number, cebb.bank_branch_name, cebb.bank_branch_number, cebb.bank_branch_type,…
AP Web Report Workflow Status
SELECT ‘WPAY’ TYPE, gl.segment1 division, gl.segment3 dcc, gl.segment4 ccc, h.report_submitted_date creation_date, (TRUNC (SYSDATE) – TRUNC (h.report_submitted_…
ASL Duplicate Site validation
SELECT count(*) into v_asl_site_count FROM po_lookup_codes plc, hr_org_units_no_join hou, hr_org_units_no_join hou1, hr_all_organization_units_tl hout, hr_all_o…
Query to get tax registration at supplier level – Oracle Fusion
The below query extracts the Tax Registration details such as Tax Regime Code, Registration Number of Suppliers from Fusion Applications. SELECT HP.party…
Call requisition import program back from back end
declare l_request_req_id NUMBER; begin BEGIN l_request_req_id := apps.fnd_request.submit_request (application => ‘PO’ –Application, , program => ‘REQIMPORT’ –Pr…
ASL (Approved supplier list) setup validation for Local and Global
ASL Setup Validation ASL (Approved supplier list) setup validation for Local and Global The local setup we have to pass the parameter location code, item and Ve…
Approved Supplier list insert script
DECLARE paslrec po_approved_supplier_list_rec; paarec po_asl_attributes_rec; padrec po_asl_documents_rec; chvrec chv_authorizations_rec; psicrec po_supplier_ite…
Supplier Contact Import Using FBDI – Oracle Fusion
This blog describes the step by step process of Supplier Contacts migration in Fusion Application using File Based Data Import. Using this process we can create…
Script to extract Expenses SLA Details
SELECT aerh.invoice_num “Report_Number”, papf.full_name “Employee_Name”, papf.employee_number “Emp_Number”, hou.NAME “Operating_Unit”…
AP Web Report Workflow Status
SELECT ‘WPAY’ TYPE, gl.segment1 division, gl.segment3 dcc, gl.segment4 ccc, h.report_submitted_date creation_date, &nbs…
Script to extract Goods Received Date for Suppliers along with Invoice and PO Information
select (select hou.name from apps.hr_operating_units hou where organization_id = (select org_id from apps.ap_invoices_all apa where apa.vendor_id = ap.vendor_id…
Vendor Ledger Report Query
SELECT flag, vendor_num, vendor_name, vendor_site_id, vendor_site_code, state_code, proj…
Query for Supplier details with banks
SELECT aps.vendor_name|| ‘ ~ ‘|| as…
Extract for Payments – Check and EFT
SELECT papf.employee_number employee_number , aps.vendor_name payee_name…
AP Supplier Banks Payments Query
SELECT pvs.org_id org_id, iep.default_payment_method_code, alc.lookup_code, hou.NAME org_name, pv.vendor_id supplier_id…