Oracle Fusion/Cloud Procurement: Supplier FBDI Import

Safi
3 min readApr 22, 2024

--

Supplier Import :POZ_SUPPLIERS_INT

Batch ID
Import Action *
Supplier Name*
Supplier Number
Tax Organization Type
Supplier Type
Business Relationship*
Tax Registration Number
Payment Method

Run ESS Job :

1.Load Interface File for Import

2.Import Suppliers

Supplier Address Import: POZ_SUPPLIER_ADDRESSES_INT

Batch ID
Import Action *
Supplier Name*
Address Name *
Country
Address Line 1
Address Line 2
City
Postal code
Phone
RFQ Or Bidding
Ordering
Pay
E-Mail

Run ESS Job

  1. Load Interface File for Import
    2.Import Supplier Addresses

Supplier Site Import: POZ_SUPPLIER_SITES_INT

Batch ID
Import Action *
Supplier Name*
Procurement BU*
Address Name
Supplier Site*
Purchasing
Pay
Primary Pay
Communication Method
E-Mail
Pay on receipt
Invoice Summary Level
Invoice Currency
Hold All Invoices
Hold Unmatched Invoices
Exclude Tax From Discount
Payment Method

Run ESS Job

  1. Load Interface File for Import
  2. Import Supplier Sites

Supplier Site Assignment: POZ_SITE_ASSIGNMENTS_INT

Batch ID
Import Action *
Supplier Name*
Supplier Site*
Procurement BU*
Client BU*
Bill-to BU

Run ESS Job

  1. Load Interface File for Import
  2. Import Supplier Site Assigments

Supplier Contact Import: POZ_SUP_CONTACTS

Batch ID
Import Action *
Supplier Name*
First Name
Last Name
E-Mail

POZ_SUPP_CONTACT_ADDRESSES_INT

Run ESS Job

  1. Load Interface File for Import
  2. Import Supplier Contact

Supplier Bank Account Import: IBY_TEMP_EXT_PAYEES

Import Batch Identifier
*Payee Identifier
Business Unit Name
*Supplier Number
Supplier Site
*Pay Each Document Alone

IBY_TEMP_EXT_BANK_ACCTS

  • Import Batch Identifier
    *Payee Identifier
    *Payee Bank Account Identifier
    **Bank Name
    **Branch Name
    *Account Country Code
    Account Name
    *Account Number
    Account Suffix

IBY_TEMP_PMT_INSTR_USES

Import Batch Identifier
*Payee Identifier
*Payee Bank Account Identifier
*Payee Bank Account Assignment Identifier
*Primary Flag

  1. Load Interface File for Import
  2. Import Supplier Bank Account

--

--

No responses yet