Interface Table Names in Oracle Applications

Interface Table Names in Oracle Applications, www.askhareesh.com
Payables - Invoices
AP_INVOICES_INTERFACE
AP_INVOICE_LINES_INTERFACE

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

Receivables - Invoices
RA_INTERFACE_LINES_ALL
RA_INTERFACE_DISTRIBUTIONS_ALL
RA_INTERFACE_SALESCREDITS_ALL

Receivables - Lock Box
AR_PAYMENTS_INTERFACE_ALL

Receivables - Tax
AR_TAX_INTERFACE

Cash Management - Bank Statements
CE_STATEMENT_HEADERS_INT_ALL
CE_STATEMENT_LINES_INTERFACE

Fixed Assets
FA_INV_INTERFACE

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

Purchasing - Purchase Orders
PO_HEADERS_INTERFACE
PO_LINES_INTERFACE
PO_DISTRIBUTIONS_INTERFACE
PO_REQUISITIONS_INTERFACE_ALL
PO_REQ_DIST_INTERFACE_ALL
PO_RESCHEDULE_INTERFACE

Purchasing - Receiving 
RCV_HEADERS_INTERFACE
RCV_TRANSACTIONS_INTERFACE
RCV_LOTS_INTERFACE
RCV_SERIALS_INTERFACE

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

Master Scheduling/MRP
MRP_FORECAST_INTERFACE
MRP_SCHEDULE_INTERFACE

Shop Floor Management
WSM_LOT_JOB_INTERFACE
WSM_STARTING_LOTS_INTERFACE
WSM_LOT_MOVE_TXN_INTERFACE

Quality
QA_RESULTS_INTERFACE

Work in Process
WIP_MOVE_TXN_INTERFACE
CST_COMP_SNAP_INTERFACE
WIP_COST_TXN_INTERFACE
WIP_JOB_SCHEDULE_INTERFACE
WIP_JOB_DTLS_INTERFACE


2 comments:

  1. Having these Oracle interface table names collected in one place can save a lot of time when working with data imports, integrations, and troubleshooting. The breakdown by areas such as Payables, Receivables, Purchasing, Inventory, and General Ledger makes it easier to locate the right interface table for a specific task. This type of structured reference is also useful when managing large business datasets. Alt Delta Datalytics works in the data and technology space, where organized information and reliable data handling are important for supporting effective business processes and informed decisions.

    ReplyDelete