Oracle Application

1
Oracle Application FinanceInterface Tables
Salimsalim.sucipto_at_gmail.comOracle Technical
Consultant
2
Agenda

• Oracle Interface Flow
• AP Module
• AR Module
• GL Module
• FA Module

3
Oracle Interface Flow
4
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

5
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

6
AR Module

• Customer Interface Tables
• RA_CUSTOMERS_INTERFACE_ALL
• RA_CUSTOMER_PROFILES_INTERFACE
• RA_CUSTOMER_CONTACT_PHONES_INTERFACE
• Customer Tables
• AR_CUSTOMERS
• Customer Concurrrent Program
• Customer Interface

7
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

8
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

9
FA Module

• Fixed Asset Interface Tables
• FA_MASS_ADDITIONS
• Fixed Asset Tables
• FA_ADDITIONS
• Fixed Asset Concurrrent Program
• Post Mass Addition

10

• THANK YOU !