Packaged Interfaces

Our interfaces allow upload, download and data validation of every column in each interface table.  Data validation includes not null, data type and maximum length of each column based on specific table constraints.
 
We have Excel macros for uploading and downloading to/from the following standard Oracle interfaces:

Oracle Financials – Payables - Invoices
AP_INVOICES_INTERFACE
AP_INVOICE_LINES_INTERFACE

Oracle Financials – Receivables - Customers
RA_CUSTOMERS_INTERFACE_ALL
RA_CUSTOMER_PROFILES_INT_ALL
RA_CONTACT_PHONES_INT_ALL
RA_CUSTOMER_BANKS_INT_ALL
RA_CUST_PAY_METHOD_INT_ALL
HZ_PARTY_INTERFACE

Oracle Financials – Receivables - Invoices
RA_INTERFACE_LINES_ALL
RA_INTERFACE_DISTRIBUTIONS_ALL
RA_INTERFACE_SALESCREDITS_ALL

Oracle Financials – Receivables – Lock Box
AR_PAYMENTS_INTERFACE_ALL

Oracle Financials – Receivables - Tax
AR_TAX_INTERFACE

Oracle Financials - Cash Management – Bank Statements
CE_STATEMENT_HEADERS_INT_ALL
CE_STATEMENT_LINES_INTERFACE

Oracle Financials - Fixed Assets
FA_INV_INTERFACE

Oracle Financials - General Ledger – Journal Entry
GL_INTERFACE

Oracle Manufacturing – Cost Management
CST_PC_ITEM_COST_INTERFACE
CST_PC_COST_DET_INTERFACE

Oracle Manufacturing - Inventory
MTL_REPLENISH_HEADERS_INT
MTL_REPLENISH_LINES_INT
MTL_SERIAL_NUMBERS_INTERFACE
MTL_SYSTEM_ITEMS_INTERFACE
MTL_TRANSACTION_LOTS_INTERFACE
MTL_TRANSACTIONS_INTERFACE

Oracle Manufacturing – Purchasing – Purchase Orders
PO_HEADERS_INTERFACE
PO_LINES_INTERFACE
PO_DISTRIBUTIONS_INTERFACE
PO_REQUISITIONS_INTERFACE_ALL
PO_REQ_DIST_INTERFACE_ALL
PO_RESCHEDULE_INTERFACE

Oracle Manufacturing – Purchasing - Receiving
RCV_HEADERS_INTERFACE
RCV_TRANSACTIONS_INTERFACE
RCV_LOTS_INTERFACE
RCV_SERIALS_INTERFACE

Oracle Manufacturing - Order Entry – Sales Orders
SO_HEADERS_INTERFACE_ALL
SO_HEADER_ATTRIBUTES_INTERFACE
SO_LINES_INTERFACE_ALL
SO_LINE_ATTRIBUTES_INTERFACE
SO_LINE_DETAILS_INTERFACE
SO_PRICE_ADJUSTMENTS_INTERFACE
SO_SALES_CREDITS_INTERFACE

Oracle Manufacturing - Master Scheduling/MRP
MRP_FORECAST_INTERFACE
MRP_SCHEDULE_INTERFACE

Oracle Manufacturing - Shop Floor Management
WSM_LOT_JOB_INTERFACE
WSM_STARTING_LOTS_INTERFACE
WSM_LOT_MOVE_TXN_INTERFACE

Oracle Manufacturing - Quality
QA_RESULTS_INTERFACE

Oracle Manufacturing - Work in Process
WIP_MOVE_TXN_INTERFACE
CST_COMP_SNAP_INTERFACE
WIP_COST_TXN_INTERFACE
WIP_JOB_SCHEDULE_INTERFACE
WIP_JOB_DTLS_INTERFACE


To contact us, click here.
 
© 2001 - 2006 Interfaces International, Inc. All Rights Reserved.