R12: API For VAT Registration Number

(Doc ID 2329534.1)

Last updated on NOVEMBER 17, 2017

Applies to:

Oracle Payables - Version 12.2.5 and later
Information in this document applies to any platform.


Using the ap_vendor_pub_pkg.create_vendor API to create supplier.
The supplier is getting created successfully, but the vat_registration_num column in ap_suppliers is not being populated with required values.

--Variables passed as input to create supplier
p_vendor_rec.vendor_name := lr_supplier_int_rec.supp_name;
p_vendor_rec.vendor_name_alt := lr_supplier_int_rec.ALT_SUPP_NAME;
p_vendor_rec.vat_registration_num := lr_supplier_int_rec.VAT_REG_NUM;
p_vendor_rec.organization_type_lookup_code := lr_supplier_int_rec.LEGAL_STRUCTURE;
p_vendor_rec.awt_group_id:= lr_supplier_int_rec.INV_WTH_TAX_GROUP;
p_vendor_rec.attribute3 := to_char(lr_supplier_int_rec.zycus_supp_id);
p_vendor_rec.jgzz_fiscal_code := lr_supplier_int_rec.NUM_1099;
p_vendor_rec.allow_awt_flag := lr_supplier_int_rec.ALLOW_WTH_TAX_FLAG;

--API Call to Create New Supplier
ap_vendor_pub_pkg.create_vendor(p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
p_commit => p_commit,
p_validation_level => p_validation_level,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_vendor_rec => p_vendor_rec,
x_vendor_id => x_vendor_id,


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms