Oracle Apps R12 Account Receivables (AR) Transaction Type Setup

Posted by

Transaction Types are used in Oracle Account Receivables (AR)  to define the accounting for the  debit memos, credit memos, on-account credits, chargebacks, commitments, and invoices which are created  in Oracle Account Receivables (AR) . Transaction types  are also used to determine whether transaction(s)  updates  customers’ balances and if the Account Receivables  (AR) posts the transactions to the General Ledger

Oracle Account Receivables (AR)  provides the following transaction types:

  • Invoice
  • Credit Memo ,
  • Projects Credit Memo ,
  • Projects Invoice ,
  • Intercompany

Responsibility: Receivables Manager

Navigation: Setup > Transactions > Transaction Types

Oracle Apps R12 Transaction Types
Oracle Apps R12 Transaction Types

Field details for the Transaction Types Setup :

Operating Unit:  OU which will use these transaction type

Name : Name of the Transaction Type

Description:  Description of the Transaction Type

Class:   Invoice, Chargeback, Credit Memo, Debit Memo, Deposit, or Guarantee

Legal Entity: provide the Legal Entity Name

Open Receivables: Select if transactions with the defined  type is to be used to  update customer balances

Post to GL: Select if transactions with the defined  type is to be posted to General Ledger  . The check box must be checked if the class is Deposit or Guarantee. If  transaction is defined as  a ‘void’ transaction type, do not check this box

Create Sign :  For Credit Memo , set value as  Negative Sign , for others set value as Positive Sign

Printing Option:  Default Printing Option for the transaction type

Transaction Status :  Open / Closed / Pending / Void

Natural Application: The check box must be checked if the class is Deposit or Guarantee

Allow Freight :  To allow freight to be entered for transactions with this transaction type, check the Allow Freight check box

Receivable Account : Provide the  Receivable Account for transactions with the transaction type. Receivables uses it with  AutoAccounting definition, to determine the receivable accounts for transactions with these transaction types. Receivables creates a receivables transaction record using this account so you can transfer to your general ledger and create a journal entry if Post To GL is Yes for this transaction type.

For guarantee transaction types, provide the Accounting Flexfield for the Unbilled Receivable account

For Guarantee and Deposit transaction types, provide the Accounting Flexfield for the Unearned Revenue account if Allow Freight is set to No

Credit Memo transaction types Receivable Account is not required

SQL Query to get the list of Active Transaction Types in Oracle Apps R12 AR:

SELECT RCTTA.ORG_ID,RCTTA.NAME , RCTTA.DESCRIPTION, RCTTA.POST_TO_GL, RCTTA.STATUS, RCTTA.ACCOUNTING_AFFECT_FLAG,
RCTTA.DEFAULT_STATUS ,  RCTTA.ALLOW_FREIGHT_FLAG, RCTTA.ALLOW_OVERAPPLICATION_FLAG,
RCTTA.START_DATE, RCTTA.TAX_CALCULATION_FLAG,RCTTA.SET_OF_BOOKS_ID
FROM RA_CUST_TRX_TYPES_ALL  RCTTA
WHERE RCTTA.STATUS =’A’
Oracle Apps R12 Transaction Types Data
Oracle Apps R12 Transaction Types Data