Category Archives: AP API’s

Association of Bank Acct using IBY_DISBURSEMENT_SETUP_PUB

Associate Bank Account to Supplier

Name of the API used:

IBY_DISBURSEMENT_SETUP_PUB.Set_Payee_Instr_Assignment Continue reading

Related posts:

Create Bank using IBY_EXT_BANKACCT_PUB, IBY_EXT_BANKACCT_PUB, IBY_EXT_BANKACCT_PUB and IBY_DISBURSEMENT_SETUP_PUB

Create Bank, Branch, Account and associate to Supplier

Prerequisites:

In the below examples we have done the following steps Continue reading

Related posts:

Create Supplier Sites using AP_SUPPLIER_SITES_INT

Create Supplier Sites

Name of the Interface Tables used:

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

Mandatory Columns (AP_SUPPLIER_SITES_INT):

VENDOR_INTERFACE_ID

VENDOR_ID                    

VENDOR_SITE_CODE

OPERATING_UNIT_NAME/ORG_ID

 

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

Base Tables Affected:

  • AP_SUPPLIER_SITES_ALL

General Tips for Running the Create Supplier:

  • Save the script file and then run the script from the SQL Prompt (Example : RUN createsuppliersites.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 Sites.

 

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

Supplier Sites 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 XXAOA SUPPLIER – DEMO

Related posts:

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.

Continue reading

Related posts: