AR Invoice Tables in Oracle Fusion

AR Invoice Tables in Oracle Fusion

Hi friends, we are going to discuss about the AR Invoice Tables in Oracle Fusion. We will try to share some of the most important AR Invoice tables which helps to store the complete AR Invoice information in oracle fusion. As a Fusion financial consultant , we should have the complete understanding about the backend tables involves in the AR Invoicing. Using these AR Invoice tables we can develop the Custom AR Invoice BIP report in oracle fusion. When we create the AR Invoice in Oracle Fusion application , then that AR invoice data inserts into multiple AR Invoice tables in the backend. In this post , we will try to explain all these. We will also share the working query too which helps to find & analyze the joins between the different AR Invoice tables in oracle Fusion. Please find below the complete details about AR Invoice Tables in Oracle Fusion.

5 Important AR Invoice Tables In Oracle Fusion

Here below are some of the important tables about AR Invoice.

1. RA_CUSTOMER_TRX_ALL

2.RA_CUSTOMER_TRX_LINES_ALL

3,RA_CUST_TRX_LINE_GL_DIST_ALL

4.RA_CUST_TRX_LINE_SALESREPS_ALL

RA_CUSTOMER_TRX_ALL:- 

This table helps to store the complete AR Invoice Header details. We can find the TRX_NUMBER, Transaction/Invoice Date, Customer , Customer Site, Payment Terms, Invoice Source, Invoice Transaction Type, Currency and many other header related information's.

RA_CUSTOMER_TRX_LINES_ALL:-

This table help to store the complete AR Invoice lines details. We can get the Invoice Line No, Item, Description, Qty, Unit Price, Accounted price. 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_SALESREPS_ALL:- This tables helps to store the Sales representative information's for the AR Invoice in Oracle Fusion. This Table Stores the Sales Person name used in the RA_CUSTOMER_TRX_ALL table.

 

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.

Complete SQL Query to extract the AR Invoice Details in Oracle Fusion

Here below is the important sql query having AR Invoice tables which helps to extract the AR Invoice data in oracle fusion.

select a1.trx_number,a1.transaction_date from RA_CUSTOMER_TRX_ALL a1,RA_CUSTOMER_TRX_LINES_ALl a2,RA_CUST_TRX_LINE_GL_DIST_ALL a3

where a1.customer_trx_id=a2.customer_trx_id

and a2.customer_trx_id=a3.customer_trx_id

and a2.customer_trx_line_id=a3.customer_trx_line_id