Finance module tables in oracle apps r12 : Oracle r12 Finance tables

Finance module tables in oracle apps r12 : Oracle r12 Finance tables

In this post , We will be discuss about the Finance module tables in oracle apps r12. Finance module is divided into multiple sub modules like Payables , Receivables , Cash Management and General Ledger. I will try to share the most important tables for each financials modules. These finance module tables help to extract the financial information's form the oracle application. I will try to share these module tables one by one and will try to explain more about these tables in oracle apps r12. Please find below detail understanding about Oracle r12 Finance tables.

 

 

Most Important Finance module tables in oracle apps r12

1. Payable (AP Invoices & Payments) Tables

2.Receivables Tables

3.Cash Management Tables

4.General Ledgers Tables

 

Here below is the detail explanation of the each finance module tables which further divided into sub-modules.

 

Payable Table :- 

Payable Invoices Tables in Oracle Apps

AP_INVOICES_ALL

THIS TABLE STORE ALL INFORMATION BETWEEN Invoice Headers Workbench information

AP_INVOICE_LINES_ALL

THIS TABLE STORE ALL INVOICE LINES INFORMATION SAME LIKE INVOICE WORKBENCH

 AP_INVOICE_DISTRIBUTIONS_ALL

THIS TABLE STORE ALL INVOICE DISTRIBUTIONS INFORMATION (ALL GL ACCOUNT INFORMATION)

AP_BATCHES_ALL

if you are entering the payables invoices in batches , then in this table you will get information about this batch details.

AP_PAYMENT_SCHEDULES_ALL

THIS TABLE STORE INFORMATION OF THE INVOICE PAYMENT SCHEDULE TAB SAME LIKE INVOICE WORKBENCH. This table store all information about due dates of the payments like on which dates we need to make the payments . This table also store information about discounts also.

Payable Payments Tables in Oracle Apps

AP_PAYMENT_HISTORY_ALL

 It also stores the maturity history for future dated payments.

The table contains a row for each future dated payment, once the future dated payment matures, i.e. becomes negotiable.

Any time a payment is cleared or un cleared, a row is inserted into this table for the payment.

 

AP_CHECKS_ALL

THIS TABLE STORE ALL THE INFORMATION ABOUT PAYMENTS, Here you will get all the payment information ,Check Number , Banks Detail Vendor etc.

AP_INVOICE_PAYMENTS_ALL

IF YOU WANT TO SEE ONE CHECK IS DONE AGAINST WHICH PAYABLES INVOICES THEN YOU CAN CHECK FROM THIS TABLE. Here you can see invoices paid against check.

Receivables Tables :

RA_CUSTOMER_TRX_ALL

This is the AR Invoice/Transactions Header Table. In this Table , We will get the Customer Information’s, site Information’s, Payment Terms ,Transaction Source and Transaction Type kind of Information’s.

RA_CUSTOMER_TRX_LINES_ALL

This is the AR Invoice/Transactions Lines tables. In this Table , We will get the AR Invoice Lines Information’s along with the Tax Lines Information’s.

Here in this Table , We will get the separate Lines for the Each Tax line. If any invoice has 1 Line and two taxes applied to this Line. Then we will

get three lines for this Invoice. One for Line and Two for Taxes.

RA_CUST_TRX_LINE_GL_DIST_ALL

This table store the AR Invoice accounting information’s for each line of the AR Invoice. Here will get all the Accounting Information’s.

RA_CUST_TRX_LINE_SALESREPS_ALL

This Table Stores the Sales Person name used in the RA_CUSTOMER_TRX_ALL table.

AR Receipts Table

AR_CASH_RECEIPTS_ALL

This Table Stores Cash Receipt Header tables

AR_RECEIVABLE_APPLICATIONS_ALL

This Table Store , Which AR Receipt applied to Which Ar Invoice in the Oracle application

 

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

AR_CASH_RECEIPT_HISTORY_ALL

This table stores all of the activity that is contained for the life cycle of a receipt.

GL Tables :

gl_ledgers

select * from apps.gl_ledgers where ledger_id=25004

'This Table Stores the GL Ledger detail in Oracle apps r12'

gl_je_headers

select * from apps.gl_je_headers

'This Table stores GL Journals Header Information. Important Columns of this Table is NAME,JE_SOURCE,PERIOD_NAME,CURRENCY_CODE,STATUS’

gl_je_lines

select * from apps.gl_je_lines

'This Table stores GL Journals Lines Information.Important Columns of this table 'ACCOUNTED_DR,ACCOUNTED_CR,ENTERED_DR,ENTERED_CR,CODE_COMBINATION_ID

GL_code_combinations

‘This table stores GL code combinations informations.Important columns of this table is ‘CODE_COMBINATION_ID’ AND CHART_OF_ACCOUNT_ID’

SELECT * FROM apps.GL_code_combinations

gl_je_batches

‘This table stores GL Journal Batches Informations.

 

GL_IMPORT_REFERENCES

'Table uses to join the GL journals with the Subledger Transactions’. Columns 'GL_SL_LINK_ID' link with the 'GL_SL_LINK_ID' column of 'apps.xla_ae_lines' table.

Select * from apps.GL_IMPORT_REFERENCES

gl_periods

‘This table Stores GL periods name and the Start and End of the Period.

select * from apps.gl_periods

gl_currencies

This table stores all the GL currencies Information or we can say 'Master of the Currencies uses in the General Ledger'.

gl_daily_rates

Select * from apps.gl_daily_rates

This table stores the GL currencies Daily rates in the system.