Interview Answers on Techno AR in Oracle EBS R12

** AR Techno-Func 

Q- What is the difference between Unidentified Receipt, Unapplied Receipts and On Account 

Receipts ?

What are the Accounting Entries for each of this ?

A. Unidentified Receipts: The Customer is yet to be identified and so receipt is not matched.

Unapplied Receipts: The Customer is identified and entered but the amount is not matched with any of

his invoice.

On Account Receipts: The Customer is entered and instead of matching the amount to any of his 

invoice it 

is matched with the On Account option. 

This option is available as first item in the pick list of invoices.

Q. What is Receipt Method, what is significance of it

Q. What is AutoAccounting ?

A. This is the account generator in Accounts receivables. 

This decides accounts for

Receivables

Revenue

AutoInvoice Clearing

Freight

Tax

Unbilled Receivable

Unearned Revenue

From where the accounts are defaulted ?

Sales reps

Transaction Lines

Transaction Types

Taxes

Or you can have Constant values

Q- When are the following accounts are used

Unbilled Receivable

Unearned Revenue

A. When you use Invoicing Rule, the receivables are accounted on different dates as defined in the rule. 

Till such time receivables are accounted, the amount is debited to Unbilled Receivables.

If you use Accounting Rule, the revenue is accounted on different dates. 

Till such time revenue is accounted, the amount is credited to Unearned Revenue..

Q. What is AutoCashRule Set ?

This decides the sequence of the invoice matching rules for unmatched receipts entered though quich 

cash or

 AutoLockBox(interface). The rules are already defined in the system. Like “Match Payment with Invoice”,

“Apply to the Oldest Invoice First”, “Clear the Account”, etc.

Q. How do you define document numbering for receipts ? can you have different sequences for 

each Payment Method.

In system administration. You can have different sequences for different payment methods.

Q. What is the difference between on-account and unapplied receipts? 

Answer :

 a. Unapplied Receipt:- 

 This receipt is not applied to an existing invoice when it is entered. 

When the customer does not want to apply the entered 

receipt they can leave it as unapplied and apply the amount on a later date. 

 b. On-Account:- 

 In case of an On-Account receipt, there is no identified invoice against the receipt. 

Advance money is received from the customer and the invoice for the same can be raised at a later date. 

Q. What is AutoLockBox?

Q. How do you apply payments to unrelated customers' invoices? 

Answer :

The correct way to apply a receipt to more than one customer is to either establish a relationship

 between the customers OR make sure the 

System Option - Allow Payment of Unrelated Transactions is checked. 

Once one or both of the conditions above are met, follow these procedures: 

A. Navigate to Receipts>Receipts or Receipts>Batches to enter a new receipt. 

B. Enter the receipt number, amount, payment method, and customer number of the first customer you 

want to apply the invoice too. 

 You must enter a customer number on this screen in order to make the Applications button available. 

C. Select the Applications button. 

D. Apply the receipt to the first customer's invoice. 

E. If you want to apply monies to another, different customer's invoice, then 

scroll to the right to find the Customer number field and change the number 

to the other customer's number. 

NOTE: If you will be processing many payments to related customers' invoices, 

you can drag the Customer number column and drop it close to the Apply to 

column, then save these changes in a folder. 

F. Then scroll back to the Apply To field and select the LOV. You should now 

see the other customer's open invoices and can make a selection from here. 

G. Save your changes. 

Q. If a receipt is applied to a wrong customer account. What is the best way to move the funds 

from one account to another? 

Answer :

The receipt can be reversed and a new receipt entered for the correct customer 

if the original receipt does not have any adjustments or chargebacks that have 

been posted to the general ledger. Otherwise, a debit memo reversal will have 

to be created. 

Or, if you have established a relationship between the customers or activated 

the System Option - Allow Payment of Unrelated Transactions, then you can 

unapply the application for the original customer and then apply an amount to 

the other customer on the existing receipt. 

Q. How do you apply a receipt to the same transaction twice? 

Answer :

Oracle Receivables does not allow you to add a second line to a receipt for the same invoice or debit 

memo. 

However, you can change the original line applied to the invoice and increase the applied amount by the 

unapplied portion that you want to apply. 

Q. Why can you enter duplicate receipt numbers?

Answer Duplicate receipt numbers is a functionality of Receivables. Many customers use 

their customer's check number as the receipt number and for this reason, unique receipt numbers are not required. 

Internally, a unique cash_receipt_id is assigned to each receipt as it is saved.

However, a receipt is considered as 'duplicated' - and not allowed, if the receipt number, receipt date, 

amount, and customer are identical to another receipt. 

Q AR_INTERIM_CASH_RECEIPTS_ALL

This is a temporary table that stores entries for receipts entered via

QuickCash. Oracle Receivables creates one record for each receipt. If

you enter a receipt with a status of Unapplied, Unidentified, On

Account, or apply payment to one invoice, Oracle Receivables stores

both payment and application information. When the payment is

applied to many invoices, Oracle Receivables creates one record for each

receipt application in 

AR_INTERIM_CASH_RCPT_LINES_ALL. 

After you run the Post QuickCash program, Oracle Receivables creates a

record in AR_CASH_RECEIPTS_ALL for each receipt and

AR_RECEIVABLE_APPLICATIONS_ALL for each receipt application.

Oracle Receivables then deletes data from this table. The primary key

for this table is CASH_RECEIPT_ID.

Q AR_PAYMENTS_INTERFACE_ALL

This table stores imported lockbox information that has not been

validated. AutoLockbox creates one row in this table for each record in

a transmission. When you run the validation step of AutoLockbox,

Oracle Receivables transfers the information from the

AR_PAYMENTS_INTERFACE_ALL tables to the

AR_INTERIM_CASH_RECEIPTS_ALL and

AR_INTERIM_CASH_RCPT_LINES_ALL tables. The primary key for

this table is TRANSMISSION_RECORD_ID.

--========================

** Technical Questions-

-----------------------

*PLSQL

Q Can one use dynamic SQL statements from PL/SQL?

Q What is a mutating and constraining table

Q User defined exception

Q What are REF cURSORs

Q What is Forward decaration in Package,

Q-Will 'before delete trigger' get fired if table is truncated.

A- TRUNCATE will not fire any ON DELETE triggers that might exist for the tables. 

But it will fire ON TRUNCATE triggers

Q What is Global Temporary tables

--> Session specific

Q What is Pragma Autonomous transactions

--========================

*ShellScripting

Q How I end host pgm in error or warning 

--> exit 1

Q how wud you send output of a pgm in email 

--> cd $APPLCSF$APPLOUT/o<reqId>.out and use mail -s command 

Q how you call plssql procedure in shellscript 

--> use sqlplus command

Q hOW u get logged in user within shellscript

--> using $1

Q what is "$?" 

--> it returns result of previous command 

--==========================

Interview with YK on 19th Mar22 for japan BSA position

Billing process

what all info u need to generate invoice

month end closing reports

Autoinvoice setups

what is autoaccting 

GL Date on invoice

significance of Payment term

Receipt method -why and how we setups

Customer model in oracle (TCA)