Supplier Invoice Import (Payables Open Interface import)

Hi all now its time for ap invoice interface.You can use this interface table to insert invoice information into
oracle application table.Check it out!!

For header level entry

Insert into AP_INVOICES_INTERFACE (INVOICE_ID=>ap_invoices_interface_s.nextval,
INVOICE_NUM,
INVOICE_TYPE_LOOKUP_CODE,
INVOICE_DATE,
VENDOR_ID,
VENDOR_SITE_ID,
INVOICE_AMOUNT,
INVOICE_CURRENCY_CODE,
TERMS_ID,
DESCRIPTION,
SOURCE,
GROUP_ID,
PAYMENT_METHOD_LOOKUP_CODE,
PAY_GROUP_LOOKUP_CODE,
ACCTS_PAY_CODE_COMBINATION_ID,
ORG_ID,
LEGAL_ENTITY_ID,
OPERATING_UNIT,
PAYMENT_METHOD_CODE)

for line level entrt
Insert into AP_INVOICE_LINES_INTERFACE(

INVOICE_ID=>ap_invoices_interface_s.nextval,,
INVOICE_LINE_ID=>ap_invoice_lines_interface_s.nextval,
LINE_NUMBER,
LINE_TYPE_LOOKUP_CODE,
AMOUNT ,
DESCRIPTION
)


Note that while submitting :
parameter=>source:should be "Quick Invoices"
Use "payables open interface import" in ap responsibility to import payables information.

good luck!!

Supplier Interface in Oracle application R12

There are basically three interface tables in suppliers interface
ap_suppliers_int
ap_suppiler_sites_int
ap_sup_site_contact_int


The minimum columns that has to be populated in the suppliers interface are
ap_suppliers_int
Vendor_ interface_ id => ap_suppliers_int_s.next_val
summary_flag=>set to y
enabled_flag=>set to y
vendor_name
segment1=>vendor number
terms_id/terms_name
invoice_currency_code



ap_suppiler_sites_int

vendor_site_interface_id=> ap_supplier_sites_int_s.nextval
vendor_interface_id =>ap_supplier_sites_int_s.nextval
vendor_site_code
org_id
vendor_id
address_line1
terms_id/terms_name
invoice_currency_code
country

ap_sup_site_contact_int

vendor_interface_id =>ap_supplier_sites_int_s.nextval
vendor_contact_interface_id=>AP_SUP_SITE_CONTACT_INT_S.NEXTVAL
vendor_site_code
org_id
vendor_site_id
vendor_id
last_name


note if you want to populate url or email then make sure they are in correct format or oracle rejects these data.

The data inserted via this interface are automatically populated into hz_parties table.


Interface programs in ap resposibility to import information are
"SUPPLIER OPEN INTERFACE IMPORT"
"SUPPLIER SITES OPEN INTERFACE IMPORT"
"Supplier Site Contacts Open Interface Import"

good luck