Oralce FAQs

What are the Interface and API table for Receipts Conversion In Oracle receivables .
AR_PAYMENTS_INTERFACE_ALL
AR_INTERIM_CASH_RECEIPTS_ALL and
AR_INTERIM_CASH_RCPT_LINES_ALL
AR_CASH_RECEIPTS_ALL
AR_CASH_RECEIPT_HISTORY_ALL
AR_DISTRIBUTIONS_ALL
AR_RECEIVABLE_APPLICATIONS_ALL
AR_PAYMENT_SCHEDULES_ALL ...

What do you mean by HZ_ in customer tables?
All tables that starts with HZ_ are related to the Trading Community Architechture (TCA). In these table we can find all the information about the Customers Organization Person's. 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.


What is the difference between Recurring Journals and Mass Allocation?
Recurring Journals are for transactions that repeat every accounting period. Example: Rent expenses that recur every month.
Mass Allocation Journals are for single journal entry formula that allocates revenues and expenses across a group of cost centers, ...

What is Automatic Offset ?
It is Accounts Payable feature and quite similar to intercompany function in General Ledger. It is used to create multiple liability lines for the transactions between sister companies.
For Eg Say two companies purchasing goods from the same supplier. But when invoice is created whereas both the companies are liable to pay.
Automatic Offset function helps here to create multiple liability lines to balance the journal at balancing level.
We can achieve this by selecting option at Accounting Area of Payable Option.
Navigation – Setup ->Options->Payable
There are three radio buttons
1) None
2) Accounts
3) Balancing

None- No Automatic Offset will be done.
Accounts-The distribution line segments will be copied to the liability lines excepting accounts segment which copied from the liability line itself.
Balancing-Only Balancing Segment from distribution lines segments will be copied to the liability lines excepting Accounts segment which copied from the liability line itself.


What is the difference between cross validation rules and Security Rules?
Cross Validation Rules that define valid combinations of segment values a user can enter in an account. Cross validation rules restrict users from entering invalid combinations of account segment.
Cross validation rules can applied only to KFF.
Security Rules – It determines the accounting transactions user can view at different levels of hierarchy such as at Site Level- > Application Level -> Responsibility Level -> User Level.
Or Security Rules for restricted segment values that user can enter during the data entry. The list of values will only display that are not restricted by security rules assigned to the responsibility whenever your user logged on.
Security Rules can be appled to KFF and DFF.