Create Supplier using AP_SUPPLIERS_INT

Create Supplier

Name of the Interface Tables used:

  • AP_SUPPLIERS_INT: holds Supplier information that is loaded by the user for import.

Mandatory Columns (AP_SUPPLIERS_INT):

VENDOR_INTERFACE_ID

                        VENDOR_NAME

SEGMENT1 (Conditionally Required)

 

  • AP_SUPPLIER_INT_REJECTIONS: stores Suppliers, sites, contacts rejections information.

 

Base Tables Affected:

  • AP_SUPPLIERS

General Tips for Running the Create Supplier:

  • Save the script file and then run the script from the SQL Prompt (Example : RUN createsupplier.sql)
  • Enter the values for the Parameters from inside the script file itself unless it is required to Enter some value from the SQL Prompt.
  • This script will create the Supplier.

After successfully Insertion into Interface table, we need to submit the standard Program.

Supplier Open Interface Import:

Script To Verify whether the Create Supplier is successful:

Navigation to find the above created Supplier in Application

(N) Payables >> Suppliers >> Entry

Query for Supplier TEST Supplier 1

Related posts:

Leave a Reply