AP Interface

AP Interface

Procedure:

Best Practices for interfaces as per my experience

1. Create a staging table from mandatory, conditional required, optional required columns from interface select statement as xx_table_name

2. alter the table add columns as process flags, error flags

3. Load the data through sql loader as per client requirements

4. write a plsql procedures to validate data and transfer to interface tables

5. submit standard program to import data

 

 

 

AP Invoice Interface

Interface Table: AP_INVOICES_INTERFACE,

AP_INVOICE_LINES_INTERFACE,

 

Error Tables

AP_INTERFACE_REJECTION,

AP_INTERFACE_CONTROL

 

Base Tables

AP_INVOICES_ALL

AP_INVOICE_LINES_ALL

 

Concurrent Program = Payables Open Interface Import



 

Staging Table Creation:

CREATE TABLE XX_AP_INV_STAGE

(

   Invoice_Id                   NUMBER PRIMARY KEY,

   Invoice_Type_Lookup_Code     VARCHAR2 (80),

   Vendor_Number                VARCHAR2 (240) NOT NULL,

   Vendor_Site_Code             VARCHAR2 (30) NOT NULL,

   Invoice_Num                  VARCHAR2 (50) NOT NULL,

   Invoice_Date                 DATE NOT NULL,

   Invoice_Currency_Code        VARCHAR2 (15) NOT NULL,

   Exchange_Rate                NUMBER NOT NULL,

   Invoice_Amount               NUMBER NOT NULL,

   Description                  VARCHAR2 (240),

   Po_Number                    VARCHAR2 (20),

   Liability_Account            VARCHAR2 (100),

   Desc_liability_acc           VARCHAR2 (240),

   Tax_code                     VARCHAR2 (15),

   Tax_Amount                   NUMBER,

   Inv_Recieved_Date            DATE NOT NULL,

   Created_Date                 DATE NOT NULL,

   Terms_name                   VARCHAR2 (50) NOT NULL,

   Terms_Date                   DATE NOT NULL,

   Pay_Group_Lookup_Code        VARCHAR2 (25),

   Payment_Currency_Code        VARCHAR2 (15),

   Payment_Method_Lookup_Code   VARCHAR2 (25) NOT NULL,

   GL_Date                      DATE NOT NULL,

   Invoice_Source               VARCHAR2 (80) NOT NULL,

   Validation_Record_Flag       VARCHAR2 (1),

   Error_Message                VARCHAR2 (2000),

   Created_by                   NUMBER,

   Creation_date                DATE,

   Last_Updated_by              NUMBER,

   Last_Update_Date             DATE,

   Last_Update_Login            NUMBER

)