Oracle R12 GL Tables

Sr. No	Category	Table Name	Description/ Uses
1	General Ledger	GL_CODE_COMBINATION	Stores Valid account combinations
2		GL_SETS_OF_BOOKS	Stores Information about the sets of books
3		GL_IMPORT_REFERENCES	Stores Individual transactions from subledgers
4		GL_DAILY_RATES	Stores the daily conversion rates for foreign currency
5	Transactions	GL_PERIODS	Stores Information about the Accounting Periods
6		GL_JE_HEADERS	Stores Journal Entries
7		GL_JE_LINES	Stores Journal Entries lines that we enter in the Enter Journals Form
8		GL_JE_BATCHES	Stores Journal Entry Batches
9		GL_BALANCES	Stores Actual, Budget and encumbrance balances for details and summary accounts
10		GL_BUDGETS	Stores Budget defintions
11		GL_INTERFACE	Import journal entry batches
12		GL_BUDGET_INTERFACE	Upload budget data from external sources
13		GL_DAILY_RATES_INTERFACE	Import daily conversion rates

Oracle R12 AP Tables

Sr. No	Category	Table Name	Description/ Uses
1	Supplier Tables	AP_SUPPLIERS	This table replaces the old PO_VENDORS table.
2			It stores information about your supplier level attributes.
3		AP_SUPPLIER_SITES_ALL	It stores information about your supplier site level attributes.
4		IBY_EXTERNAL_PAYEES_ALL	stores Payee(supplier) information.
5		HZ_PARTIES	Party data for the suppliers.
6		HZ_PARTY_SITES	Party site data for the supplier sites.B4
7	Supplier Interface tables	ap_suppliers_int	Supplier Interface. Execute Supplier Open Interface Import Program
8		ap_supplier_sites_int	Supplier site interface. Execute "Supplier Sites Open Interface Import" Program
9	Invoice	AP_INVOICES_ALL	It contains records for invoices you enter
10		AP_INVOICE_LINES_ALL	It contains records for invoice lines entered manually, generated automatically or imported from the Open Interface.
11		AP_INVOICE_DISTRIBUTIONS_ALL	It holds the distribution information that is manually entered or system-generated
12	Invoice Interface	AP_INVOICES_INTERFACE	Invoice Header Information. Run Payables Open Interface Import concurrent program
13		AP_INVOICE_LINES_INTERFACE	Invoice Lines and Distributions Information
14	Payments:	AP_CHECKS_ALL	Check Header Information
15		AP_INVOICE_PAYMENTS_ALL	Details of Invoice paid by a Check/Payment
16		AP_PAYMENT_HISTORY_ALL
17		AP_INV_SELECTION_CRITERIA_ALL
18		AP_SELECTED_INVOICES_ALL
19		AP_PAYMENT_DISTRIBUTIONS_ALL
20		CE_PAYMENT_DOCUMENTS	AP_CHECK_STOCKS_ALL
21		IBY_PAY_SERVICE_REQUESTS	Payment Process Request information  (11i Terminology is Payment Batch)
22		IBY_PAY_INSTRUCTIONS_ALL	Payment Instruction information
23		IBY_DOC_PAYABLES_ALL	Invoice information stored by IBY for generating payment
24		IBY_PAYMENTS_ALL	Payment Information
25	Accounting	XLA_EVENTS	replaces AP_ACOCUNTING_EVENTS_ALL
26		XLA_AE_HEADERS	replaces AP_AE_HEADERS_ALL
27		XLA_AE_LINES	replaces AP_AE_LINES_ALL
28	Bank Accounts	CE_BANK_ACCOUNTS	AP_BANK_ACCOUNTS_ALL
29		CE_BANK_ACCT_USES_ALL	replaces AP_BANK_ACCOUNT_USES_ALL
30	Credit Card Transactions Table	AP_EXPENSE_FEED_LINES	Use the Credit Card Transaction Interface Table to load transaction datafrom your credit card issuers into your Payables system. When younsubmit the Credit Card Transaction Validation and Exception Report, for records where the CREATE_DISTRIBUTION_FLAG is Y, Payables uses the data in the AP_EXPENSE_FEED_LINES table to create distributions with proper accounts in the AP_EXPENSE_FEED_DISTS table

Oracle R12 AR Tables

Sr. No	Category	Table Name	Description/ Uses
1	Transactions	RA_CUSTOMER_TRX_ALL	Transaction Header table
2		RA_CUSTOMER_TRX_LINES_ALL	Transaction Lines table along with Tax lines.
3		RA_CUST_TRX_LINE_GL_DIST_ALL	Distribution for Transaction Lines
4		RA_CUST_TRX_LINE_SALESREPS_ALL	Salesrep information for Transaction Lines
5	Transaction Interface Tables	RA_INTERFACE_LINES_ALL	Transaction Lines interface
6		RA_INTERFACE_SALESCREDITS_ALL	Transaction Sales credit information
7		RA_INTERFACE_DISTRIBUTIONS_ALL	Transaction Distribution information
8		RA_INTERFACE_ERRORS_ALL	Transaction errors table
9		AR_PAYMENTS_INTERFACE_ALL	Interface table to import receipts
10		AR_INTERIM_CASH_RECEIPTS_ALL	Lockbox transfers the receipts that pass validation to the interim tables
11		AR_INTERIM_CASH_RCPT_LINES_ALL	Lockbox transfers the receipts that pass validation to the interim tables
12	Receipts tables	AR_CASH_RECEIPTS_ALL	Cash Receipt Header tables
13		AR_RECEIVABLE_APPLICATIONS_ALL	stores Receipt Application details
14		AR_PAYMENT_SCHEDULES_ALL	This table is updated when an activity occurs against an invoice, debit memo, chargeback, credit memo, on-account credit, bills receivable
15		AR_CASH_RECEIPT_HISTORY_ALL	This table stores all of the activity that is contained for the life cycle of a receipt.
16			• Each row represents one step.
17			• The status field for that row tells you which step the receipt has reached.
18			• Possible statuses are Approved, Confirmed, Remitted, Cleared, and Reversed.
19	Setup tables	RA_CUST_TRX_TYPES_ALL	This table stores information about each transaction type for all classes of transactions, for example, invoices, commitments, and credit memos.
20		AR_RECEIPT_CLASSES	This table stores the different receipt classes that you define.
21		AR_RECEIPT_METHODS	This table stores information about Payment Methods, receipt attributes that you define and assign to Receipt Classes to account for receipts and their applications

Oracle R12 Business Partner Tables

Sr. No	Category	Table Name	Description/ Uses
1	Customer Tables	HZ_PARTIES	A party is an entity that can enter into a business relationship.
2		HZ_CUST_ACCOUNTS	This table stores information about customer/financial relationships established between a Party and the deploying company.
3		HZ_PARTY_SITES	This table links a party (HZ_PARTIES) and a location (HZ_LOCATIONS) and stores location-Specific party information such as a person’s mail stops at their work address.
4		HZ_CUST_ACCT_SITES_ALL	This table stores information about customer/financial account sites information.
5		HZ_CUST_SITE_USES_ALL	This table stores information about the business purposes assigned to a customer account site
6		HZ_LOCATIONS	A location is a point in geographical space described by an address and/or geographical Indicators such as latitude or longitude.