Transcript Oracle Application – Finance Interface Tables

Oracle Application – Finance
Interface Tables
Salim
[email protected]
Oracle Technical Consultant
Agenda
– Oracle Interface Flow
– AP Module
– AR Module
– GL Module
– FA Module
Oracle Interface Flow
External Source (Text File,
CSV File, External Table,
etc)
SQL Loader
Insert Statement
Other
Oracle Interface Table
Oracle Application
Concurrent Program
Oracle Module Table
AP Module
– Supplier Interface Tables:
• AP_SUPPLIERS_INT
• AP_SUPPLIER_SITES_INT
• AP_SUP_SITE_CONTACT_INT
– Supplier Tables:
• PO_VENDORS
• PO_VENDOR_SITES_ALL
• PO_VENDOR_CONTACTS
– Supplier Concurrrent Program:
• Supplier Open Interface Import
• Supplier Sites Open Interface Import
• Supplier Site Contacts Open Interface
Import
AP Module
– AP Invoice Interface Tables:
• AP_INVOICES_INTERFACE
• AP_INVOICE_LINES_INTERFACE
– AP Invoice Tables:
• AP_BATCHES_ALL
• AP_INVOICES_ALL
• AP_INVOICE_LINES_ALL
– AP Invoice Concurrrent Program:
• Payables Open Interface Import
AR Module
– Customer Interface Tables:
• RA_CUSTOMERS_INTERFACE_ALL
• RA_CUSTOMER_PROFILES_INTERFACE
• RA_CUSTOMER_CONTACT_PHONES_INTERFA
CE
– Customer Tables:
• AR_CUSTOMERS
Customer Concurrrent Program:
- Customer Interface
AR Module
– AR Interface Tables:
• RA_INTERFACE_LINES_ALL
– AR Invoice Tables:
• RA_CUSTOMER_TRX_ALL
• RA_CUSTOMER_TRX_LINES_ALL
– AR Invoice Concurrrent Program:
- Autoinvoice Master Program
GL Module
– GL Transaction Interface Tables:
• GL_INTERFACE
– GL Transaction Tables:
• GL_JE_BATCHES
• GL_JE_HEADERS
• GL_JE_LINES
– GL Transaction Concurrrent Program:
- Journal  Import  Run
FA Module
– Fixed Asset Interface Tables:
• FA_MASS_ADDITIONS
– Fixed Asset Tables:
• FA_ADDITIONS
– Fixed Asset Concurrrent Program:
- Post Mass Addition
THANK
YOU !