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