Thursday, January 30, 2014

Interface Tables and Programs

Appl
Type
Exact Program Name
Interface Tables
GL
Journals
Journal Import
GL_INTERFACE
GL
Budgets
Upload Budget Amounts
GL_BUDGET_INTERFACE
GL
Daily Rates
Trigger - GL_DAILY_RATES_INTERFACE_ASIT
GL_DAILY_RATES_INTERFACE
AP
Invoices
Payables Open Interface Import
AP_INVOICES_INTERFACE
AP_INVOICE_LINES_INTERFACE
AP
Supplier
Supplier Open Interface Import
AP_SUPPLIERS_INT
AP
Supplier Sites
Supplier Sites Open Interface Import
AP_SUPPLIER_SITES_INT
AP
Supplier Contacts
Supplier Site Contacts Open Interface Import
AP_SUP_SITE_CONTACT_INT
AR
Transactions
Autoinvoice Import Program or Autoinvoice Master Program
RA_INTERFACE_LINES_ALL
RA_INTERFACE_DISTRIBUTIONS_ALL
RA_INTERFACE_SALESCREDITS_ALL
AR
Receipts
Process Lockboxes
AR_PAYMENTS_INTERFACE_ALL
AR_INTERIM_CASH_RECEIPTS_ALL  AR_INTERIM_CASH_RECEIPT_LINES_ALL
AR
Customers
Customer Interface
RA_CUSTOMERS_INTERFACE
RA_CUSTOMER_PROFILES_INTERFACE
RA_CONTACT_PHONES_INTERFACE
RA_CUSTOMER_BANKS_INTERFACE
RA_CUST_PAY_METHOD_INTERFACE
CM
Bank Statement
Bank Statement Import & AutoReconciliation
CE_STATEMENT_HEADERS_INT_ALL
CE_STATEMENT_LINES_INTERFACE
PO
Requisitions
Requisition Import
PO_REQUISITIONS_INTERFACE_ALL
PO_REQ_DIST_INTERFACE_ALL
PO
Purchase Orders
Import Standard Purchase Orders
PO_HEADERS_INTERFACE
PO_LINES_INTERFACE
PO_DISTRIBUTIONS_INTERFACE
PO
Receipts
Receiving Transaction Processor
RCV_HEADERS_INTERFACE
RCV_TRANSACTIONS_INTERFACE
OM
Sales Order
Order Import
OE_HEADERS_IFACE_ALL
OE_LINES_IFACE_ALL
OE_ACTIONS_IFACE_ALL
OE_ORDER_CUST_IFACE_ALL
OE_PRICE_ADJS_IFACE_ALL
OE_PRICE_ATTS_IFACE_ALL
INV
Items
Import Items
MTL_SYSTEM_ITEMS_INTERFACE
MTL_ITEM_REVISIONS_INTERFACE
MTL_ITEM_CATEGORIES_INTERFACE
INV
Customer Items
Import Customer Items
MTL_CI_INTERFACE
INV
Customer Item Cross References
Import Customer Item Cross References
MTL_CI_XREFS_INTERFACE
INV
Material Transactions
Process transaction interface
MTL_TRANSACTIONS_INTERFACE
MTL_MTL_TRANSACTION_LOTS_INTERFACE
MTL_SERIAL_NUMBERS_INTERFACE
INV
Costs
Cost Import Process
CST_ITEM_CST_DTLS_INTERFACE
CST_RESOURCE_COSTS_INTERFACE
CST_RES_OVERHEADS_INTERFACE
CST_DEPT_OVERHEADS_INTERFACE

1 comment:

  1. we have created a concurrent program using GLLEZL to create journals in our system.
    It is generating transaction level journal rather than summary one.

    How to create a summary level journal rather than transaction Level(line level).

    Latter we should be able to drill down.

    Thanks

    Kiran

    ReplyDelete

Note: Only a member of this blog may post a comment.