Accointing for invoice in advance
a) Receivable A/c …………………Dr.
To Unearned revenue a/c
(when we raise the invoice with invoicing rule as advance)
b) Unearned Revenue A/c ………….. Dr.
To Revenue A/c
(when we receive the payment, the number of journal entry (b) is depend upon the accounting rules which can be fixed or variable)
Accounting for invoice in arrear
a) Unbilled receivable a/c ………………..Dr.
To Revenue a/c
(when we receive the payment of unbilled invoice, the number of journal entry (a) is depend upon the accounting rules which can be fixed or variable))
b) Receivable a/c …………………….Dr.
To Unbilled receivable a/c
(when we raise the invoice, with invoicing rule arrear)
What is the use of Transaction Flexfield in Autoinvoice ?
Transaction Flexfield actually identifies the the uniqueness among the Multiple lines of a single Invoice
What are value sets?
Value sets are the defined as list of possible values for a specific purpose. These are assigned to flexfields. These are the only possible values to be choosen from. This eliminates the data entry errors.
Value set is a set of possible values.
There are 8 value set types:
1.Dependent
2.Independent
3.Table
4. None
5.Pair
6.Translatable Dependent
7.Translatable Independent
8. Special
Describe the main tables involved in AR, and what is the data stored in them?
RA_BATCHES_ALL — Information about Transaction BATCHES RA_CUSTOMER_TRX_ALL — Header information about Transaction
RA_CUSTOMER_TRX_LINES_ALL — Lines information about Transaction
RA_CUST_TRX_LINE_GL_DIST_ALL - Distribution information about Transaction
RA_CUST_TRX_LINE_SALESREPS_ALL — Sales representative of Transaction Information
AR_PAYMENT_SCHDULES_ALL - Information about Payment Schedules
AR_APPLICATION_PAYABLES_ALL
RA_INTERFACE_ERRORS - Errors in AutoInvoice Interface Data
RA_INTERFACE_LINES_ALL - Use this table to enter Header and Lines information in AutoInvoice Interface program
RA_INTERFACE_DISTRIBUTIONS_ALL - Distribution Table in AutoInvoice Interface program
RA_INTERFACE_SALESCREDITS_ALL - Sales Credits information in AutoInvoice Interface
What do you mean by HZ_ in customer tables?
HZ stands for Human Zone(HZ_). Anytihing which is related to the human like Customer profiles, their accounts, locations, relationships are stored in these tables only. From release 11i TCA came into picture in Accounts Recievable module, where oracle has grouped all the customer information at one place. Most important tables in TCA are-
HZ_PARTIES,
HZ_CUST_ACCOUNTS_ALL,
HZ_CUST_ACCT_SITES_ALL,
HZ_CUST_SITE_USES_ALL,
HZ_LOCATIONS,
HZ_PARTY_SITES,
HZ_PARTY_SITE_USES,
HZ_CONTACT_POINTS. few to name.
What is the difference between _all, _tl, _vl, _v tables in Oracle Apps ? Also name various other table suffix.
_ALL : Table holds all the information about different operating units. Multi-Org environment. You can also set the client_info to specific operating unit to see the data specific to that operating unit only.
_TL are tables corresponding to another table with the same name minus the _TL. These tables provide multiple language support. For each item in the table without _TL there can be many rows in the _TL table, but all with different values in the LANGUAGE column.
_B these are the BASE tables. They are very important and the data is stored in the table with all validations. It is supposed that these table will always contain the perfect format data. If anything happens to the BASE table data, then it is a data corruption issue.
_F these are date tracked tables, which occur in HR and Payroll. For these there are two date columns EFFECTIVE_START_DATE and EFFECTIVE_END_DATE which together with the PK identifies a row uniquely. The date intervals cannot overlap. Many think they are Secured data. Guess someone from Oracle confirms.
_V tables are the views created on base tables _VL are views for multi language tables which combines the row of the base table with the corresponding row of the _TL table where the LANGUAGE = USERENV(’LANG’).
_S are sequences, used for finding new values for the primary key of a table.
_A are Audit Shadow Tables
_AVN and _ACN are Audit Shadow Views (when data was changed, and with what values)
How many Flex fields are there in AR and what are they?
Required Key Flex fields:
1. Territory Flex field
2. Sales Tax Location flex field
Optional Key Flex fields:
1. Transaction flex field (requied only if Auto Invoicing is enabled)
2. System Items Flex field (If Inventory or OM is installed this should be defined there. other wise, it should be set up in AR).
Batch sources control the standard transaction type assigned to a transaction and determine whether Receivables automatically numbers your transactions and transaction batches. You can define two types of transaction batch sources-Manual and Imported
What is the importance of Batch Source set up in AR ?
