Title Oracle Custom WEB ADI for AP Invoice Interface.pdf ✅

Oracle Custom WEB ADI for AP Invoice Interface Raju Ch Requirement: Web ADI interface needed to be developed to import Invoices, Layout to be designed Solution: Following steps to be followed  Create integrator  Create Layout  Create Mappings  Create Document  Defining the Form Function for Integrator RAJU CHINTHAPATLA
Oracle Custom WEB ADI for AP Invoice Interface Raju Ch Compile the below Custom table and Package in APPS schema --> ==================================================================== DROP TABLE XXAA_APINV_IFACE_TBL; CREATE TABLE XXAA_APINV_IFACE_TBL ( SOURCE VARCHAR2(50), ORGANIZATION VARCHAR2(40), INVOICE_TYPE VARCHAR2(40), SUPPLIER_NAME VARCHAR2(60), SUPPLIER_NUM VARCHAR2(60), SUPPLIER_SITE VARCHAR2(40), INVOICE_DATE DATE, INVOICE_NUMBER VARCHAR2(60), INVOICE_AMOUNT NUMBER(10,2), TERMS VARCHAR2(60), INVOICE_CURRENCY VARCHAR2(25), GL_DATE DATE, PAYMENT_CURRENCY VARCHAR2(25), PAYMENT_METHOD VARCHAR2(40), LINE_NUM NUMBER, LINE_TYPE VARCHAR2(25), LINE_AMOUNT NUMBER(10,2), SEGMENT1 VARCHAR2(25), SEGMENT2 VARCHAR2(25), SEGMENT3 VARCHAR2(25), SEGMENT4 VARCHAR2(25), SEGMENT5 VARCHAR2(25), LINE_DESCRIPTION VARCHAR2(100), ORG_ID NUMBER, VENDOR_ID NUMBER, VENDOR_SITE_ID NUMBER, TERM_ID NUMBER, CODE_COMBINATION_ID NUMBER, last_update_date DATE, last_updated_by NUMBER, creation_date DATE, created_by NUMBER, last_update_login NUMBER , status VARCHAR2(50), error_code VARCHAR2(15), error_message VARCHAR2(3000) ); --> ==================================================================== CREATE OR REPLACE PACKAGE XXAA_APINV_IFACE_PKG IS PROCEDURE XXAA_APINV_IFACE_LOAD_PRC ( P_SOURCE VARCHAR2 ,P_ORGANIZATION VARCHAR2 ,P_INVOICE_TYPE VARCHAR2 ,P_SUPPLIER_NAME VARCHAR2 ,P_SUPPLIER_NUM VARCHAR2 ,P_SUPPLIER_SITE VARCHAR2 ,P_INVOICE_DATE DATE ,P_INVOICE_NUMBER VARCHAR2 ,P_INVOICE_AMOUNT NUMBER ,P_TERMS VARCHAR2 RAJU CHINTHAPATLA
Oracle Custom WEB ADI for AP Invoice Interface Raju Ch ,P_INVOICE_CURRENCY VARCHAR2 ,P_GL_DATE DATE ,P_PAYMENT_CURRENCY VARCHAR2 ,P_PAYMENT_METHOD VARCHAR2 ,P_LINE_NUM NUMBER ,P_LINE_TYPE VARCHAR2 ,P_LINE_AMOUNT NUMBER ,P_LINE_DESCRIPTION VARCHAR2 ,P_SEGMENT1 VARCHAR2 ,P_SEGMENT2 VARCHAR2 ,P_SEGMENT3 VARCHAR2 ,P_SEGMENT4 VARCHAR2 ,P_SEGMENT5 VARCHAR2 ); PROCEDURE XXAA_APINV_IFACE_IMPORT_PRC; END XXAA_APINV_IFACE_PKG; / --> ==================================================================== CREATE OR REPLACE PACKAGE XXAA_APINV_IFACE_PKG IS PROCEDURE XXAA_APINV_IFACE_LOAD_PRC ( P_SOURCE VARCHAR2 ,P_ORGANIZATION VARCHAR2 ,P_INVOICE_TYPE VARCHAR2 ,P_SUPPLIER_NAME VARCHAR2 ,P_SUPPLIER_NUM VARCHAR2 ,P_SUPPLIER_SITE VARCHAR2 ,P_INVOICE_DATE DATE ,P_INVOICE_NUMBER VARCHAR2 ,P_INVOICE_AMOUNT NUMBER ,P_TERMS VARCHAR2 ,P_INVOICE_CURRENCY VARCHAR2 ,P_GL_DATE DATE ,P_PAYMENT_CURRENCY VARCHAR2 ,P_PAYMENT_METHOD VARCHAR2 ,P_LINE_NUM NUMBER ,P_LINE_TYPE VARCHAR2 ,P_LINE_AMOUNT NUMBER ,P_LINE_DESCRIPTION VARCHAR2 ,P_SEGMENT1 VARCHAR2 ,P_SEGMENT2 VARCHAR2 ,P_SEGMENT3 VARCHAR2 ,P_SEGMENT4 VARCHAR2 ,P_SEGMENT5 VARCHAR2 ); PROCEDURE XXAA_APINV_IFACE_IMPORT_PRC; END XXAA_APINV_IFACE_PKG; / --> ==================================================================== CREATE OR REPLACE PACKAGE body XXAA_APINV_IFACE_PKG IS PROCEDURE XXAA_APINV_IFACE_LOAD_PRC ( P_SOURCE VARCHAR2 RAJU CHINTHAPATLA
Oracle Custom WEB ADI for AP Invoice Interface Raju Ch ,P_ORGANIZATION VARCHAR2 ,P_INVOICE_TYPE VARCHAR2 ,P_SUPPLIER_NAME VARCHAR2 ,P_SUPPLIER_NUM VARCHAR2 ,P_SUPPLIER_SITE VARCHAR2 ,P_INVOICE_DATE DATE ,P_INVOICE_NUMBER VARCHAR2 ,P_INVOICE_AMOUNT NUMBER ,P_TERMS VARCHAR2 ,P_INVOICE_CURRENCY VARCHAR2 ,P_GL_DATE DATE ,P_PAYMENT_CURRENCY VARCHAR2 ,P_PAYMENT_METHOD VARCHAR2 ,P_LINE_NUM NUMBER ,P_LINE_TYPE VARCHAR2 ,P_LINE_AMOUNT NUMBER ,P_LINE_DESCRIPTION VARCHAR2 ,P_SEGMENT1 VARCHAR2 ,P_SEGMENT2 VARCHAR2 ,P_SEGMENT3 VARCHAR2 ,P_SEGMENT4 VARCHAR2 ,P_SEGMENT5 VARCHAR2 ) IS l_error_message VARCHAR2(3000); l_error_code VARCHAR2(2); l_org_id NUMBER; l_invoice_num VARCHAR2(60); l_vendor_id NUMBER; l_vendor_site_id NUMBER; l_term_id NUMBER; l_code_combination_id NUMBER; BEGIN l_error_message := ''; l_error_code :='V'; -->Organization Validation BEGIN l_org_id := NULL; SELECT organization_id INTO l_org_id FROM hr_organization_units hou WHERE hou.name=P_ORGANIZATION; EXCEPTION WHEN no_data_found THEN l_error_message :=l_error_message||','||'Organization not defined '; l_error_code :='E'; WHEN too_many_rows THEN l_error_message :=l_error_message||','||'Too Many Records for Organization '; l_error_code :='E'; WHEN OTHERS THEN l_error_message :=l_error_message||','||'Other Errors with Organization '||SQLCODE ||sqlerrm; l_error_code :='E'; END; -->Invoice Number Validation BEGIN RAJU CHINTHAPATLA