AR Interview Questions

Auto invoice:- Auto invoice is the interface between Order management and Account Receivables. Auto invoice picks data from AR interface tables, validate and create transactions in AR. Auto Lock box:...

Commitments Deposits When you enter a deposit, Receivables creates the following journal entry: DR Receivables (Deposit) CR Offset Account Use the AR: Deposit Offset Account Source profile option to ...

There are 6 types of transactions 1)Invoice(salesinvoices) 2) debitmemo(increases the suppliersbalance) 3) creditmemo(decreases the suppliers balance) 4) deposits(increases the suppliersbalance)...

In R12 we have 2 key flexifields and those 2 are optionals

1) Sales tax location key flexield: this flexfiled is used to calculate tax based on the location wise
2) Territory key flexfiled: By using this key flexfield we can find out the the sales information based on the location wise

There are 2 kff in AR

1. Sales tax location flexfield
2.Territory flexfield.

MRC is nothing but multiple currency by using the MRC can record and maintain the transaction more than one functional currency its works at transaction level in 11i upto 8 currencies we can use in R1...

We need two set of books one primary and another secondary
1 primary set of books INR
2 secondary set of books USD
Define daily rates
we have to set up MCR

In 11i up to 8
In R12 up to 9

thankssss

I think we can have a total of 8 SOB's (including the Primary SOB). Therefore, we can have 7 Reporting SOB.

Someone pls confirm!!

Hi Alfred, Auto-invoice is a program that can be used to import and validate transaction data from other financial systems from which one can create invoices, debit memos, credit memos, and on-accou...

Dear Mr. Alfred, I little bit disagree with your answer that account value is defined that which value is to credited or debited. But sorry to say in my opinion As per Accounting Rules, Account Head ...

valuset is nothing but list of values wth validations.it wil restrict the user to enter valid values

There are 8 types of valueset

1.None
2.Dependent
3.Independent
4.special
5.pair
6.Table
7.Translate Independent
8.Translate Dependent

Value set is nothing but set of rules or conditions or properties or attributes which are going to enforce or attach to the segments upon attaching value set to the segment your segment behave according to the value set.

Disagree wirh RVS123,
Encumbrance fund can never be reserved for planned expenditure.

In Oracle Applications, encumbrances are used with only AP-PO-GL modules and not AR. Budgets are created in GL. Typically, encumberances are used to reserve funds for a purchase you are going to make ...

_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 un...

_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 un...

Auto invoice is a facility provided by Oracle Receivables, that the transactions in Legacy system can be taken in to Receivables through interface.. To setup auto invoice you need to ensure the syste...

Considering the volume of transactions involved, it is not always feasible to create all the invoices manually. To overcome this Oracle AR provides a standard program called RAXMTR (Auto invoice Maste...

1.first check the Transactions for the period being closed. 2.Reconcile transaction activity for the period. 3.Reconcile customer outstanding balances 4.Review unapplied receipts register 5.Run Receip...

Process to close the Period in AR.1) Complete the transactions2) Apply receipts against the transactions3) Run the Create Accounting program to transfer the subledger data to XLA and to GL4) Run the U...

Both of the tables mentioned signifies the interface table involved during Auto invoice for transactions in receivables.

Setups in AP: Select your operation unit Define Financial opt - Payable opt - Payable system setup Create supplier profile - supplier information Create bank in Cash Management and enable to payables ...

Setups in AP:Select your operation unitDefine Financial opt - Payable opt - Payable system setupCreate supplier profile - supplier informationCreate bank in Cash Management and enable to payablesDefin...

Auto Lockbox eliminates manual data entry by automatically processing receipts that are sent directly to your bank. ARLPLB (auto lockbox program) imports, Validates and loads the payment receipt recor...

Lock box is enabled to import the receipts from bank filethere are three steps in process1. Import: in this step it reads and formats the data transferring to interface tables2. Validations: here it w...

For Auto Invoice : RAXMTR (Auto invoice Master Program) whichmark records in interface table to be processesd. then it calls RAXTRX (Auto invoiceImport Program) which validated the records and updates into base table.

For Customer Invoice : RACUST

Autoinvoice Import Program -- for auto invoice program Customer Interface Master Conc Program --> for Customer Interface

ra_interface_lines_all is the interface table for AR Transactions.

AR_PAYMENTS_INTERFACE_ALL

AR_INTERIM_CASH_RECEIPTS_ALL and AR_INTERIM_CASH_RCPT_LINES_ALL
AR_CASH_RECEIPTS_ALLAR_CASH_RECEIPT_HISTORY_ALLAR_DISTRIBUTIONS_ALLAR_RECEIVABLE_APPLICATIONS_ALLAR_PAYMENT_SCHEDULES_ALL

We can use batch payments only if "AP use batch payments is" assigned to your responsibility at system administrator level.

Party is base to customer. One party may have multiple customers assigned.

In AP Unposted Invoice Sweep process is used to transfer invoices and payments from one period to another. Invoices on hold will not post and therefore need to have the G/L Date changed to the future ...

For AR and CM : Receipt Number is Required and
For AP and CM : Payment Document Number is required

Transaction Flexfields are used to capture information that will help you trace transactions from Oracle Receivables back to the systems from which they originated, in Auto Invoices.
AutoInvoice ensures that each Transaction Flexfield is unique so you can refer to previously processed transactions.

Transaction Flexfield actually identifies the the uniqueness among the Multiple lines of a single Invoice