Search This Blog

Tuesday, April 23, 2013

Oracle AR Interview Questions


Oracle AR Interview Questions

AR Interview Questions

1) How do you add or change the LOV for telephone type in customer standard?
A: the Lookup Type of Phone_line_type sets this up. Menu: Setup-> System -> Quick Codes -> Receivables Query on Lookup Type of Phone_line_type and add a new type
2) How can I define a default printer for my reports only?
A: In SYSADMIN Navigate: Menu: Profile-> System Enter your Username in the User Field Query the    Profile "Printer" Enter the printer you would like your reports to print. References: System Administrator's Guide
Q: May I change the Tax Location Flex field after it is defined?

A: No. You cannot change the location flex field once it has been chosen. You will need to setup a new organization in AR to choose a different Tax Location Flex field. References: Tax Manual, Chapter 3, and Sales Tax

Q: When installing AR how do I determine the latest patches to apply?
A: 1. > Verify the patch level that you are on: Menu: Transactions-> Transactions Release 11: Menu option Special/About AR Release 11i: Menu Option Tools/About AR Here you will see the patch level that you are on for client and server.
2. > Determine the latest AR patches: Review the Proactive Patch List on Metal ink. Menu: Technical Libraries/Applications/Financials/Oracle Receivables Top Product Articles/11 and 11i Patch set Information This will contain the latest Patch set released plus any one-off patches that are available. References: 
Q: May I change the set of books that is assigned to an operating unit?
A: No. You cannot change from one set of books to another. You must create a new org and complete the setup again.
Q: How does the system calculate 'Clear Date' and 'GL Date' in ARZACS report?
A: This information can be found by going to the System Administrator Responsibility. Go to concurrent programs and find the concurrent program that you want.
Menu: Sesame>Concurrent>Program>Define, query Short name (i.e.: ARZACS) Click "Parameters" button to get the list of parameters.
Thus, you can find the description for all the parameters.
The parameter 'Clear Date' has the default type for this field of Current Date. The default date for clearing of receipts is the system date of the report.
The parameter 'GL Date' has the default value, which depends on the 'Clear Date'. The default type here is 'Segment' which means that the default value is the value entered in a prior segment of the same parameter window, which in this case is the Clear Date. The Default value is the clear date which means that as per functionality all these receipts will have a GL date which is the same day when the receipts was cleared. [Insert answer to question here.]
Q: Where is Account Generator: Purge Runtime Data profile option?
A: Trying to set the "Account Generator: Purge Runtime Data" profile option as indicated in the Oracle Receivables User Guide during upgrade to 11i. The profile option doesn't exist.
Per bug 788392 the profile option is no longer used and does not exist in the 11i instance. There is now a concurrent process, Purge Obsolete Workflow Runtime Data. References: Purging Workflow Runtime Tables
Q: Why Can't I find a Dispute Button In AR Online?
A: The function used by the menu item defined in Receivables Manager/Collections/ AR Online is Customer Search.
Whereas the menu defined for receivables responsibility has both: Customer Search and ARW_BTN_DISPUTE.
This explains why when using receivable user, the dispute button is available. You are not going to see the Dispute button when you use the navigation path Receivables Manager/Collections/AR Online References: How do you disable the dispute button in AR Online 11i?

Q: Why is Seeded Data protected from update?
A: You cannot disable the seeded data. This is to prevent customers from disabling a critical seeded data.

Q: Why does the WHEN_MOUSE_CLICK trigger not fire when Right Mouse button is clicked?
A: With Developer 6i, the behavior of Client Server and Web is the same. The WHEN-MOUSE-CLICK trigger fires for the left button only.

Q: How do I change the Application or Database passwords?
A: The APPLSYS and APPS passwords always have to be the same. The passwords can be changed manually following notes listed below under references.
For Release 11.0 and 11.5, you have the option to Download and install the Password changing utility available. For release 11.0, the patch number is 1430422 and for 11.5 the patch number is 1685689. There is no utility patch available for release 10.7. References: How To Use FNDCPASS to Change The Oracle Users, APPS, APPLSYS and Application Module Passwords (INV, AR, AP, etc.) in Release 11.0How To Use FNDCPASS to Change The Oracle Users, APPS, APPLSYS and Application Module Passwords (INV, AR, AP, etc.) in Release 11.5

Q: Does Item Validation Organization need to be set if you are not using Order Entry or Order Management?

A: This is a mandatory setup step, it needs to be populated regardless of whether you use these other modules or not.
Currently for release 11.5 the OM Item Validation parameter is located in the OM Super user responsibility under Setup > Parameters Prior to release 11.5, the profile option OE: Item Validation Organization must be set.


Q: How to stop Transaction Numbering Gaps.

A: For performance efficiency, Oracle uses caching with a default cache value of 20. That means that when you enter a transaction, 20 numbers are read into memory. The next time someone wants a number from the sequence, Oracle reads memory for the next number. It doesn't have to perform a disk I/O to read the next number from the sequence.
That means that when memory is cleared after you commit a transaction and exit the form, numbers let in the cache are lost. That's why you get gaps in the number sequence between 1 and 20.
You can avoid the problem by changing the sequences as follows:
ALTER SEQUENCE RA_TRX_NUMBER__S NOCACHE;
Need to login as AR for 10.7 and APPS for 11.0 you must alter sequence logged in as the owner i.e. AR/AR
This change could affect the performance of Invoice entry in very high volume environments. References: 


How To Make Document Transaction Numbering Gapless?
 
Refer to Oracle Applications System Administration Reference Manual for more details.



Q: What are Demand Classes and how are they used in AR?

A: Demand classes allow you to segregate scheduled demand and production into groups, allowing you to track and consume those groups independently. A demand class may represent a particular grouping of customers, such as governmental and commercial customers, or it may represent sales channels or regions. Demand classes may also represent different sources of demand, such as retail, mail order, and wholesale.
You can optionally define demand classes to group similar customers or sales orders. You can use demand classes as a means of forecasting different sources of demand separately.


Q: How do I setup 'Setup Details' in Receivables to run AR Setup Report?

A: Following the instructions for running the AR Setup Report. Log on as Receivable Manager and Navigate to SETUP -> SYSTEM. I do have a navigation to setup details as outlined in the instructions.
In Sesame responsibility, navigate to Application, Menu Query for AR_SETUP_SYSTEM_GUI Place the cursor in the last record, click on the green + icon in the toolbar to add a record. Enter a Menu Name, for function picks the Setup Details from LOV and save.
When you log back into AR responsibility, you should see this navigation.

 
Q: Do I have to post transactions from all organizations before I can close the period?
A: If you are using the same set of books across several organizations you have to post all transactions within all organizations sharing the same set of books before you are able to close the period in these organizations.


Q: How to Recompile AR Flex fields: Sales Tax Location Flex field and Location Flex field Structure


Question and Answers Section


1. How do you place an invoice in dispute?

1.) To place an invoice in dispute, Login as Receivables Manager Responsibility Menu: Collections>Customer Calls>Find Customer> Choose Topics>Select the transaction, Choose Actions>Enter a dispute Action, and then enter the amount in dispute, Save your work.

2.) Another means to do this is as follows: Menu:Transactions>Transactions Summary> Query the transaction to place in dispute> Select the transaction, then choose Installments> Enter the Dispute Amount and Dispute Date, Save your work.

3.) Have you reviewed your Receivables Lookup Codes? Is the Dispute Action enabled?
2. Can you query a waybill number from the Collections Workbench?
The waybill number is not available as input in the Standard CollectionWorkbench forms.
3. What is the Cumulative Balance field on the Account Details form in the ARXCWMAI workbench? How is it different then the Total Balance field?
In windows you can do multi-selects. When you are in this form, you can hold down the shift key and click on the column, it will highlight every thing in between. You can also hold the Ctrl key down and click on the columns to add or remove a record at a time frombeing highlighted.
The Cumulative balance shows sum of all selected records as opposed toTotal Balance, which is total for all found records.
4. Why Does the TRANS field clear When I Create a Customer Call?
In the Customer Call screen, the TRANS field is simply for querying purposes.If you wish to connect a Customer Call to a specific Transaction, you will need to click on Topics and enter the Transaction information on this screen.
5. I Just upgraded from an Earlier Version of Release 11i, now I Can No Longer See My Customer Calls Attached to my Transactions?
In earlier releases of Release 11i, the Account Details form would show all CustomerCalls that were associated to that customer. In 11i.AR.J, the functionality changedand now the Call must specifically be linked to the Transaction to be seen. Therefore,you will need to create a Topic for the Customer Call and then enter the Transactionthat should be linked to the call.

QUESTIONS & ANSWERS
-------------------
1. What tables cannot be updated through customer interface?

Answer
------
No updates will be allowed to be made through customer interface for
following tables
RA_SITE_USES_ALL
RA_CUSTOMER_RELATIONSHIPS_ALL
RA_CUST_RECEIPT_METHODS
AP_BANK_BRANCHES
AP_BANK_ACCOUNTS_ALL
AP_BANK_ACCOUNT_USES_ALL


2. How to send additional customer and address information through
Customer interface? 


Answer
------
Here is where attribute columns are used.
* Additional Customer data can be populated in
RA_CUSTOMERS_INTERFACE_ALL.customer_attribute1 to 15
This will go into RA_CUSTOMERS.attribute1 to 15
* Additional address information can be populated in
RA_CUSTOMERS_INTERFACE_ALL.address_attribute1 to 15
This will go into RA_ADDRESSES_ALL.attribute1 to 15
And so on.

3. What quick codes and other set ups need to be done in order to ensure that
Customer Interface completes successfully?


Answer
------
* Quick codes
Countries
Site Use Codes
Credit Ratings
Risk Codes
Account Statuses
Communication Types
Customer Classes
* Freight Carriers
* Demand Classes
* Auto cash Rule Sets
* Payment Terms
* Auto invoice Grouping Rules
* Collectors
* Payment Methods
* Statement Cycles
* Dunning Letter Sets
* Customer Profile Classes
* Customer Bank Information
* Tax Codes
* Customer Exemptions

4. If the same customer has more than one business purpose, i.e. SHIP_TO, BILL_TO, then the table RA_CUSTOMERS_INTERFACE_ALL will be populated with Two records, with same customer name, same address, but DIFFERENT value for The column SITE_USE_CODE.


Will Customer Interface error out as duplicate record?

Answer
------
No, because intelligence is built in the Customer Interface program to transfer
This as only one customer with two different business purposes

5. What should be the batch size (number of customer records)?
-General guidelines for optimal performance?

Answer
------
About 10,000 records per batch is ideal, it is suggested to keep the batch Size small.


6. Why does customer interface error out if there is mismatch in address Information?

Answer
-------
Because the code validates against these mismatches.

arplscin.sql and arplbcin.sql

It validates the address being inserted or updated with respect to the tax location flexfield structure. For each row being inserted or updated in RA_CUSTOMERS_INTERFACE, and that has not already been marked in error, The set_location_ccid function is called to return either an existing ccid
For the address entered or to create a new entry in AR_LOCATION_VALUES for This new address. The RA_CUSTOMERS_INTERFACE record is then updated with the Value of the coccid returned.

7. How do you send records at customer level profile and address/site level Profile?

Answer
------
For every customer record in RA_CUSTOMERS_INTERFACE_ALL, insert two records
In table RA_CUSTOMER_PROFILES_INT_ALL. (Refer Note: 1070800.6)


8. Active customer has some Active ship to addresses and some Inactive ship to Addresses (in other words an active customer may have some active sites and Some Inactive sites.) How does customer interface load this site?
Information?

Answer
-------
Customer interface process sends both active and invective sites to Oracle Receivables (Refer Enhancement Bug: 285185)


9. Does Customer Interface import salesperson data? 

Answer
------
No, Refer Enhancement Bug: 147495


10. Where can I get the exhaustive list of error codes for Customer Interface?
(RA_CUSTOMERS_INTERFACE_ALL.INTERFACE_STATUS)?


Answer
------
Refer Enhancement Bug: 1375421


11. Customer Interface process can be used for updating the customer information
How does the UPDATE work?

Answer
-----
Current functionality of Customer Interface is to update all the data. You
Cannot run Customer Interface to update only changed data.
(Refer Bug: 879121 for the intended functionality)

12. What are some of the important fields that Customer Interface does not load?

Answer
------

Not all fields in RA_CUSTOMERS are being loaded by the interface.
SIC_CODE
GSA_INDICATOR
FOB_POINT
SALES_CHANNEL_CODE
FREIGHT_TERM
WAREHOUSE_ID
PRICE LIST
SHIP_PARTIAL
PAYMENT_TERM_ID in RA_SITE_USES.PAYMENT_TERM_ID

(Refer Enhancement Request Bug: 245300)

13. New TCA/Customer Model, how to load customer as PERSON or ORGANIZATION
Through Customer Interface?



Answer
------

a) Populate ra_customers_interface_all. Person flag = 'Y'
Run Customer Interface process will load this record as PERSON

b) Populate ra_customers_interface_all. Person flag = 'N' (or NULL)
Run Customer Interface process will load this record as ORGANIZATION



14. New TCA/Customer Model, which tables will Customer Interface process Load the data into?

Answer
------

All HZ tables, for example:
HZ_PARTIES, HZ_PERSON_PROFILES, HZ_ORGANIZATION_PROFILES, HZ_CUST_ACCOUNTS,
HZ_CONTACT_RESTRICTIONS, HZ_CONTACT_POINTS
.

FAQ Details


1. Q: What manual should I read for more information on GL Transfer?

A: You can find detailed information on GL Transfer in the Receivables User Guide, Chapter 8 - Accounting for Receivables. References: See Note: 209936.1 for the most current version of the 11i User Guide. See Note: 67189.1 for current documentation for Oracle Receivables.


2. Q: What are the Metal ink keywords I should use when searching for more information about the GL Transfer?

A: ARGLTP, General Ledger Interface, GL Transfer

3. Q: Is it possible to submit the transfer to GL, import and posting process in GL automatically by scheduling the request?

A: The General Ledger Transfer Program cannot be scheduled. It needs to be submitted from the Run GL Transfer form within AR due to validations done through this form. References: Note: 116489.1

4. Q: Is it possible to post receipts and transactions separately to GL?
A: The GL Transfer is not design to distinguish between transactions and receipts. If the receipts and the transactions have the same gl date, there is no way to post the one type and keep the other type in AR.

5. Q: What does AR store in the REFERENCE1 through REFERENCE10 columns of the GL_IMPORT_REFERENCES?

A: See Note: 1012626.102 for a detailed description.

6. In Oracle Receivable, when you create an invoice, the gl_date_closed and actual_date_closed are initialized to '31-DEC-12', why does this occur?

A: Date 31-DEC-12 in columns gl_date_closed and actual_date_closed in table ar_payment_schedules means that the transaction / receipt has not been closed yet. Once a transaction is closed through an application or adjustment these dates get changed to date, the latest action against the transaction took place. References:
For technical explanation on the date format please review Note: 1014182.102
IMPORTANT: If you did not find the information you were searching for, please review the following documents: Note: 219297.1Troubleshooting Guide - Receivables General Ledger Transfer Note: 107059.1 Journal Import - FAQ

QUESTIONS & ANSWERS
-------------------

1. How do you suppress the Credit Memo verbiage?

***********************
Credit Memo Confirmation
This is not a request for payment
***********************

AND

100% of Credit Memo Applied to Invoice XXXXX


Answer
---------
There is no functionality within the application to turn this off.


2. How do you remove the ATTN: Accounts Payable from your invoices?


Answer
-----------
Assign a bill-to contact on the invoices, and the contact will appear.



3. How do you print invoices in portrait mode?

Answer
----------
Currently, you cannot select portrait mode to print the invoices. You
Would have to use the Invoice Print Views.


4. How do you print attachments to invoices?

Answer
----------
Currently, there is no functionality in the application to do this.


5. How do you suppress the header page on Invoices?

Answer
-----------

1. Use responsibility Application Developer
2. Concurrent>Program>Define
3. Query up short name RAXINV%
4. Click on parameters, arrow down to 'Number of Alignment Pages'
And change the value to zero. Save.

You cannot suppress the batch summary


6. How do you print invoices from Oracle Projects?

Answer
-----------

You can print an invoice from Oracle Projects Invoice Review or run a
Management report. However, if you print from Oracle Projects your invoice
Will be missing the tax and freight. Tax and Freight are only printed from
The Oracle Receivables module.


7. How do you reprint statements?

Answer
----------
Statements can be reprinted in reel 11 by clicking Special->Reprint


8. How do you suppress Remit-To Address from printing on Dunning Letters?

Answer
---------
This is designed functionality.
Enhancement Request 341653 received no votes from the User Groups in the 2000
Voting cycle

9. How do you prevent a Dunning Letter being created for a customer?

Answer
---------
The profile option (Profile: Send Letters) must be turned off for every Bill-to
Usage address defined for the customer, as well as at the customer header level.
If there is any active Bill-to entry and the profile option is still enabled,
The customer may be dunned.


10. How do you print statements by Customer Profile?

Answer
---------

You can define a statement cycle that is unique to each profile, then print
Statements by indicating that particular statement cycle.

Example:

Profile 1 defined to use statement cycle Month-Prof1
Profile 2 defined to use statement cycle Month-Prof2
Profile 3 defined to use statement cycle Month-Prof3

During Statement Cycle printing, you can specify Month-Prof1, this will
Then print only all those customers with profile 1.




Frequently Asked Questions (FAQ) Guide Oracle Receivables Receipts Workbench Versions 10.7, 11.0, 11.5
The information in this document has been reviewed and is current as of 25-NOV-2002.
Instructions for the reader: This FAQ document identifies the most frequently reported how-to questions relating to the Oracle Receivables Receipts Workbench. The articles below do not include bugs/patches or troubleshooting as these are addressed in great detail in the notes referenced at the bottom of this 

document.


1. What manual should I read for more information on receipts workbench?
Answer ------ Please see Metal ink Note: 67189.1 for the most current version of the Receivables Users Guide for the release you are using.
Also see Oracle Receivables User Guide for Release 11i 2. What are the Metal ink keywords I should use when searching for more information about the receipts workbench?
Answer ------ ARXRWMAI, ARXRW, receipts workbench ARZCAR, automatic receipts/remittances 3. How to unapplied a receipt in a date different than the last open period?
Answer ------ When you unapplied a receipt application, Oracle Receivables assigns a reversal GL date to each application that you reopen. The reversal GL date defaults to the GL date of the original application if that period is still open. If the original application's GL date is in a closed period, then the reversal GL date defaults to the current date. If the current date is not open, the default is the last date of the most recent open period.
If you want the reversal GL date to be a different date, you can change it as follows:
A. Navigate to Receipts>Receipts or Receipts>Batches. B. Query the receipt you want to unapply. C. Select the Applications button. D. Uncheck the 'Apply' box to unapply the receipt application. E. BEFORE YOU SAVE scroll to the right until you see the Reversal GL Date column. F. Change this date to any date in an open period that is on or after the original GL date for the receipt. G. Save your work. (After saving, the Reversal GL Date column becomes blank and it grayed out.) 4. How can I turn on / activate automatic numbering (auto numbering) for manual receipts?
Answer ------ Oracle Receivables does not automatically number manual receipts. However, document sequencing can be activated for manual receipts. Document sequence numbers are unique numbers that can be assigned to receipts created in Receivables. Document sequencing is an optional feature within Receivables that can be activated using a profile option. The exception to this is that if you are using automatic receipts, you must use document sequencing to sequence the automatically generated receipts.
References ---------- See the Oracle Receivables User Guide Release 11i, Chapter 2 - Setting Up, 'Implementing Document Sequences' for more information on this function.
Enhancement 473005.

5. 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.

6. How do you write off small receipt balances?

Answer ------ In Oracle Receivables version 11i, you can write off unapplied cash receipt balances. Receipt write-off functionality is provided to account for small overpayments that you do not intend to refund or maintain as unapplied amounts or on account balances. With this function, you can choose to write off an unapplied cash receipt amount, within certain limits, to a specific general ledger account. The write-off amount is credited to this account, such as a miscellaneous revenue account, and no longer reflects as an unapplied amount on the receipt or on the customer's account.
You can write off individual unapplied receipt amounts during receipt application or later, at any time using the Applications window. You can also write off balances of multiple receipts in mass using the Create Receipt Write-off option.
For Release 11.0.3 please see Note 199769.1 for a possible workaround.
References ---------- See the Oracle Receivables User Guide Release 11i, Chapter 6 - Receipts, 'Writing Off Unapplied Receipts' for more information on this function.
How to setup Receipt Write Off, please also check document 'Receipt Write-Off White Paper' Note 203243.1.
See also Note 184887.17. 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. 8. How do you access the LOV for Category and Reason Code on the Reverse Receipts window?
Answer ------ The Reverse Receipts window is a modal window. Oracle Applications 10.7NCA and R11.0 do not support icon toolbar access in modal windows. You can use Control-L to access the LOV for these fields in either of these versions.
In version 11i, you can click on the LOV or use Control - L to access the LOV. 9. How do you resolve unposted quick cash items? These items print on the Unposted Items Report with message, '* This receipt is part of an unposted quick cash batch'?
Answer ------ There are several reasons why this situation may occur, so first we need to determine if the records are duplicates or if they need to be processed.
A. Run the following script for your general ledger posting date range to determine the number of batches affected. Input the receipt number that received the error. Or if you received this error for multiple receipts, change the 4th line of the script from = to IN and then list each receipt number in single quotes, separated by commas, in parentheses, such as IN (1234, 1235, 1236, 1237).
SELECT cash_receipt_id, receipt_number, amount, batch_id, status, gl_date, gl_posted_date FROM ar_interim_cash_receipts_all WHERE receipt_number = '&receipt_number' and gl_date between '&DD-MMM-RRRR' and '&DD-MMM-RRRR';
B. Run the following script for each unique batch_id returned in script #1 above to see if the batches exist in the permanent tables. If you received multiple batch_id's above, change the 4th line of the script from = to IN and then list each batch_id separated by commas in parentheses, such as IN (5001, 5002, 5003, 5004).
SELECT batch_id, batch_applied_status, operation_request_id, name, batch_date, deposit_date, status, gl_date, closed_date FROM ar_batches_all WHERE batch_id = '&from above';
C. Run the following script for each cash_receipt_id returned in script #1 above to see if the receipts exist in the permanent tables. If you received multiple cash_receipt_id's above, change the 3rd line of the script from = to IN and then list each cash_receipt_id separated by commas in parentheses, such as IN (15122, 15123, 15124, 15125).
SELECT cash_receipt_id, receipt_number, amount, status FROM ar_cash_receipts_all WHERE cash_receipt_id = &cash_receipt_id;
D. If script #3 above returned no rows for the receipt and if the batch_applied_status from script #2 above is not 'POSTBATCH_WAITING', then refresh your test environment with data from your production system and run the following script in TEST:
UPDATE ar_batches_all SET request_id = null, batch_applied_status = 'POSTBATCH_WAITING', status = 'OP', operation_request_id = null WHERE batch_id = 'batch_id identified above';
Commit ;
Then select your batch for quick cash posting. You can query the batch name associated with the batch id and check the control amount and total to make any needed adjustments.
When you have completed these steps in TEST and confirmed that they worked correctly, please repeat in Production.
If script #3 above returned rows for the receipt, then you need to delete these cash receipts from the AR_INTERIM_CASH_RECEIPTS_ALL and AR_INTERIM_CASH_RECEIPTS_LINES_ALL tables. The safest way to do that is to delete the quick cash receipts using the forms. Then rerun the AR posting to GL. You can also use the following scripts to delete these duplicate interim records:
From your TEST environment first:
DELETE FROM ar_interim_cash_receipts_all WHERE cash_receipt_id = &id;
DELETE FROM ar_interim_cash_rcpt_lines_all WHERE cash_receipt_id = &id;
References ---------- See the Oracle Receivables User Guide Release 11i, Chapter 6 - Receipts, 'QuickCash' for more information on this process. 10. 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.
References ---------- See Note 207487.1, Applying Receipt to Multiple Customers 11. What do you do with invoices that have credit balances?
Answer ------ Create a zero-dollar receipt and apply it to the invoice. This will give the zero-dollar receipt a positive balance that can be used to pay off other invoices.
Example: Invoice A - $100 Receipt B - $120
Apply Receipt B to Invoice A and Invoice A will have a -$20 balance.
To resolve, create Receipt C for $0. Apply Receipt C to Invoice A and Invoice A will be closed. Then Receipt C will have a balance of $20 to be used for other invoices. 12. How are count and amount totals at the receipt header level updated after reversing a receipt?
Answer ------ a. Actual Count and Amount will always show THE ACTUAL NUMBER AND AMOUNT of receipts entered, regardless of any reversals. b. Returned Count and Amount show the number and amount of receipts reversed for the reasons "Non-sufficient funds", or "Stop Payment", i.e. the CUSTOMER has backed out of the payment. c. Reversed Count and Amount show the number and amount of receipts reversed for the reason "Reverse Payment", i.e. the ENTRY CLERK has made a mistake and wants to back out the payment. d. Difference Count and Amount show the Control - (Actual - Reversed) totals. 13. I applied a receipt to the 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.
References ---------- See the Oracle Receivables User Guide Release 11i, Chapter 6 - Receipts, 'Reversing Receipts' for more information on this function. 14. What is the difference between a reversed receipt and a debit memo reversal?
Answer ------ Receivables lets you reverse a receipt when a customer stops payment on a receipt or if a receipt is returned from the bank for insufficient funds. You can also reverse a receipt if you want to re-enter and reapply it in Receivables (although you can just unapply and reapply, rather than reverse if you prefer).
You can reverse cash and miscellaneous receipts before or after they are posted to the General Ledger, and before or after they are applied. Receivables lets you create two types of reversals:
1. Standard Reversal With a standard reversal, Receivables creates reversing journal entries for your general ledger and reopens all of the debit and credit items that were closed with the original receipt. You can create a standard reversal for cash and miscellaneous receipts, as well as a transaction related to a chargeback as long as there is no activity against the chargeback and the chargeback has not been posted to the general ledger. You also cannot process a standard reversal for any receipts that have adjustments or chargebacks that have been posted to the general ledger. For these exceptions, a debit memo reversal must be used.
To reverse a receipt: A. Navigate to: Receipts>Receipts or Receipts>Batches (enter batch information, then press the Receipts button). B. Query the receipt to reverse. C. Select the Reverse button. D. Confirm or change the reversal date and reversal GL date. Oracle Receivables assigns the GL date and reversal GL date as the current date. If the current date is not in an open period, then it assigns both dates as the last date of the most recent open period. If the original GL date of the receipt is later than the current date, then Receivables uses the original GL date. You can change the reversal GL date and GL date to any date in an open period that is on or after the original GL date for the receipt. E. Select the Category for this reversal. Valid categories are: Reverse Payment, Non-Sufficient Funds, and Stop Payment. F. Select a Reason for this reversal. G. Type a comment for the reversal, if desired. H. Select the Reverse button. I. Save your work.
2. Debit Memo Reversal Debit memo reversals are typically used when a standard payment reversal cannot be done. Debit memo reversals are required when you want to reverse a receipt that was previously applied to a chargeback and the chargeback has activity against it (such as another receipt, credit memo, or adjustment); or when chargebacks or adjustments have been posted to the General Ledger for the receipt you want to reverse.
Receivables does not update any of the activity associated with the original receipt when you create a debit memo reversal. Instead it creates new receivable debit items for the items closed by the original receipt.
You cannot process a debit memo reversal for a miscellaneous receipt.
To create a debit memo reversal: A. Navigate to: Receipts>Receipts or Receipts>Batches (enter batch information, then press the Receipts button). B. Query the receipt to reverse. C. Select the Reverse button. D. Confirm or change the reversal date and reversal GL date. Oracle Receivables assigns the GL date and reversal GL date as the current date. If the current date is not in an open period, then it assigns both dates as the last date of the most recent open period. If the original GL date of the receipt is later than the current date, then Receivables uses the original GL date. You can change the reversal GL date and GL date to any date in an open period that is on or after the original GL date for the receipt. E. Select the Category for this reversal. Valid categories are: Reverse Payment, Non-Sufficient Funds, and Stop Payment. F. Select a Reason for this reversal. G. Type a comment for the reversal, if desired. H. Check the Debit Memo Reversal box. I. Select a debit memo Transaction Type for this reversal. J. Select the Reverse button. K. Save your work.
15. How do you refund an overpaid (on account) receipt?
Answer ------ If your customer has overpaid and you want to cut a refund check for the overage from on account, follow these procedures to clear the credit entry from Accounts Receivable and process a refund through Accounts Payable.
This is a manual process between AR and AP.
A. You need to get the on account balance applied to an invoice. When the receipt was applied, the following general ledger entries were made:
Cash On Account -------- ---------------- 100 100
B. Create a debit memo for the amount of the on account credit you want to refund. Use a special Debit Memo transaction type that uses a clearing account rather than Revenue. This will cause the following general ledger entries to be made:
Receivable Clearing --------------- ------------- 100 100
C. Apply the on account amount to the new debit memo. This will cause the following general ledger entries to be made (leaves you with a Cash debit for $100 and a Clearing account credit for $100):
Receivable On Account Cash --------------- ---------------- ------------- 100 100 100 100
D. In Oracle Accounts Payable, process a check crediting $100 to cash and debiting the clearing account for $100 as below. This returns the cash and all other accounts to zero.
Cash Clearing ------------ ------------- 100 100 16. How do you refund a receipt for returned goods?
Answer ------ If your customer is requesting a refund for goods returned, follow these procedures to clear the credit entry from Accounts Receivable and process a refund through Accounts Payable. This is a manual process between AR and AP.
A. Create a credit memo in AR for the returned goods. Use the same Revenue and Receivable accounts referenced on the original invoice. This will cause the following general ledger entries to be made:
Receivable Revenue --------------- ------------- 100 100
B. Create a debit memo to offset the credit memo. Use a special Debit Memo transaction type that uses a clearing account rather than Revenue. This will cause the following general ledger entries to be made:
Receivable Clearing --------------- ------------- 100 100
C. In Oracle Accounts Payable, process a check crediting $100 to cash and debiting the clearing account for $100 as below. This returns the cash and all other accounts to zero.
Receivable Clearing --------------- ------------- 100 100
17. How do you delete receipts and applications from interim tables?
Answer ---------- If a receipt came in through quickcash and was not purged from the interim table or it was missing from the batch and was entered manually, then you can delete the receipts and their application as follows:
SELECT receipt_number, cash_receipt_id, gl_date FROM ar_interim_cash_receipts_all WHERE receipt_number = &receipt_number;
Using the cash_receipt_id you can delete the data:
DELETE FROM ar_interim_cash_receipts_all WHERE cash_receipt_id = &id;
DELETE FROM ar_interim_cash_rcpt_lines_all WHERE cash_receipt_id = &id;
commit; 18. How can you prorate a receipt amount between tax and line items?
Answer ------ Application Rule Sets determine the logic Receivables uses to apply partial payments to your customer's open debit items, as well as how discounts affect the open balance for each type of associated charges. You can set up different application rule sets for each transaction type. You can also assign a default application rule set in the System Options.
Receivables provides the following seeded Application Rule Sets: - Line first / tax after - Line first / tax prorate - Prorate all - Over application rule
References ---------- See the Oracle Receivables User Guide Release 11i, Chapter 6 - Receipts, 'Receivables Application Rule Sets' and Chapter 2 - Setting Up, 'Application Rule Sets' for more information.19. How do you clear a Note Receivable?
Answer ------ This is done in Oracle Cash Management for Note Receivables when the receipt class is set with a clearance method of "By Matching". To clear automatically, you need to setup your receipt class with a clearance method equal to "By Automatic Clearing". 20. How do you change a GL bank account for a receipt class?
Answer ------ To change the receipt class bank account information, end-date the receipt class you want to change and create a new receipt class with the desired GL bank information.
References ---------- See the Oracle Receivables User Guide Release 11i, Chapter 2 - Setting Up, 'Receipt Classes' for more information on this process. 21. How do you create a manual miscellaneous receipt?
Answer ------ Navigate to Receipts>Receipts or Receipts>Batches (and enter batch information if applicable). Select Receipt Type = Misc from the dropdown and then enter your receipt information.
References ---------- See the Oracle Receivables User Guide Release 11i, Chapter 6 - Receipts, 'Entering Miscellaneous Receipts' for more information on this process. 22. How to ensure that AR is posting to GL and that content matches?
Answer ------ Please review Note 1057131.6 23. When a receipt is reversed, where does the reversal of the On Account line go?
Answer ------ If a receipt that has a partial amount placed on account is reversed, the on account portion of the receipt is also reversed. 24. Why is the field "Includes Tax" at the adjustment receipt level not updateable?
Answer ------ Navigation: Receipts>Receipts>(Query receipt)>Applications button>Adjustments button
"Includes Tax" defaults in based on how you define your Adjustment Activity. The Tax Code source you specify determines whether Receivables calculates and accounts for tax on adjustments.
References ---------- See the Oracle Receivable User Guide Release 11i, Chapter 2- Setting Up, 'Receivables Activities' for more information.25. How is the ar_payment_schedules.due_date field derived for receipts?
Answer ------ The value stored in ar_payment_schedules.due_date for a receipt is the maturity date in the receipts form under the remittance region. It initially defaults to the receipt date. If the receipt date is changed to a later date, you are requested to enter a maturity date that falls after the receipt's date. 26. What is the maturity date for receipts in Oracle Receivables?
Answer ------ The maturity date in Oracle Receivables is a date that determines when funds for an automatic receipt can be transferred from your customer's bank account to your bank account. The maturity date cannot be before the receipt date. 27. How to setup an AR responsibility to allow create only miscellaneous receipt or not to create any receipt at all?
Answer ------ A. If you do not want the responsibility to enter any receipts, exclude the 'Receipt: Enter' and 'Miscellaneous Receipts: Enter' functions.
Navigation: Using System Administrator responsibility, Go to Security>Responsibility>Define. Query the Receivables responsibility in which you want to restrict the entering receipt functionality. Go to the Menu exclusion zone. Enter new records to exclude 'Receipt: Enter' and 'Miscellaneous Receipts: Enter' functions.
B. If you want the responsibility to enter just miscellaneous receipts, leave the setup excluding the 'Receipt: Enter' function only but upgrade your versions of the following programs:
forms/US/ARXRWRCT.fmb to 115.84 or higher resource/ARXRWRCT.pld to 115.121 or higher (patchset 11i.AR.F #1763786 or higher) 28. What is the difference between on-account and unapplied receipts?
Answer ------ 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.
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.
References ---------- Please check the Oracle Receivables User Guide release 11i, Chapter 6 - Receipts.

29. What to do when a customer pays less, because they expect a credit? How to apply this negative on-account cash?
Answer ------ Applications functionality does not allow creation of negative receipts. You need to enter the credit memo and apply this.30. What to do when the "Receipt Summary" form is incorrectly sorted?
Answer ------ Use the Folder functionality to sort.
A. On the Tool bar click on the Folder Option -> New. This will lead you onto 'Create New Folder' window.
Enter a name - Enter a Name for reference purpose. In Autoquery region--- Choose the radio button -- 'Always' Set the checkbox 'Open as Default' to 'Yes' Set the checkbox 'Public' to 'Yes' Click on OK
B. Now again click on the Toolbar --> Folder -> Sort Data. This will lead to a popup window - 'Sort Data'. The window will have three columns: Receipt Number Type Receipt Date Checkbox 'Run Query' set to 'Yes'
This means that you can have sorting based on these three columns only. Against each column we have an option to specify the type of order by. Please select the appropriate order by clauses applicable in your case and then again on the toolbar, click on the Folder -> Save.
C. Close the form and then Navigate again into window and verify the result. You would see that the data is displayed as per the order set above.
The following windows in the Receipts Workbench are Folder windows. You can customize the appearance of these windows by selecting options from the Folder menu: �Applications �Lockbox Transmission Data �QuickCash �Receipt Batches Summary �Receipts Summary �Remittances Summary
References ---------- See Note 183963.1, How to Use Folders to Change the Layout of Summary Screens in Oracle Applications.
For more information about folders, see: Customizing the Layout of a Folder in the Oracle Applications User Guide. See Note 66926.1 Core Technology AOL Product Documentation for most recent version of Oracle Applications User Guide. 31. Why does LOV in Receipts Workbench show inactive customers?
Answer ------ This behaviour is intended functionality. Inactive customers are displayed in the LOV in the Receipt workbench, because inactive customer may still have outstanding transactions.
References ---------- See Note 211818.1 How to Prevent a Customer from Displaying in the Receipts LOV. 32. Why message "Do you want to cancel claims on this receipt?" when you want to reverse a receipt?
Answer ------ Receivables integrates with Oracle Marketing Online�s Trade Management to let you record, research, and resolve your customers� short payments and over payments on their receipts. These payment discrepancies are called claims.
When there is a claim attached to a receipt then you will get this warning message. If you want to cancel the claim you can say ' Yes". If you say 'No', then the claims will not be cancelled.
If the claims are not cancellable, or not complete, a message will tell you that the receipt may not be reversed until the claims have been completed.
References ---------- Please check the Oracle Receivables User Guide release 11i, Chapter 6 - Receipts, Applying Receipts and Working with Claims. 33. What is receipt API?
Answer ------ Please review Note 165807.134. How to get a debug log file from the receipt API?
Answer ------ Please review Note 177132.135. Where to get an explanation of accounting entries concerning receipts?
Answer ------ Please check the Oracle Receivables User Guide release 11i, Chapter 8 - Accounting for Receivables. 36. How to process a payment for a credit memo in AR?
Payments need to be processed through Accounts Payable. See also question 16. How do you refund a receipt for returned goods? 37. How can you change the type of the receipt from cash to misc once it is entered and saved?
Answer ------ This is not possible as the field Type is not updateable once it is entered and saved. Cash type receipts store data in different tables than miscellaneous type receipts. That is why the 'Type' field on the Receipts form is protected as soon as the receipt is saved for the first time.
38. What date does AR use to calculate earned discounts?
Answer ------ When determining the discount percent for earned discounts, Receivables uses the invoice date, discount grace days, and the apply date of the receipt to determine the discount percent for this payment term.
References ---------- See the Oracle Receivables User Guide Release 11i, Chapter 6 - Receipts, Discounts. 39. Why does the receipt summary form not show the transaction numbers?
Answer ------ Functionally a receipt can be applied to one or more transactions. Hence the summary form cannot show transaction numbers.
40. How to confirm automatic receipts at batch level?
Answer ------ 1. Go to Receipts Summary Form. 2. Query the receipt batch. 3. Use Edit, Select all to mark all records. 4. Push button confirm.
References ---------- See Note 185309.1.
41. How to setup an AR responsibility with disabled "Reverse...1" button in the receipts form?
Answer ------ You need to do the following to disable the reverse...1 button in the receipts form. Navigate to System administrator responsibility. Navigate to Security>Responsibility>define Then query on : Responsibility name: your responsibility name Application: Oracle Receivables In the menu exclusion tabbed region select the following function: Receipt Reversal : Standard Receipt Reversal: Debit Memo Then save your work. By doing the above , your receipt reversal button would be disabled in the receipts form.
42. Why do on-account receipts have "wrong" count on batch header window?
Answer ------ When a part of one receipt is applied and part unapplied it is treated as one receipt with the count going to 'Applied' count.
References ---------- See Note 207766.1, 11i-AR-On-Account Receipts Are Showing Wrong Count On Batch Header Screens.
43. What is the meaning of exchange gain/loss?
Answer ------ A realized gain or loss occurs when the exchange rate changes between the invoice date and the receipt date.
References ---------- Please check the Oracle Receivables User Guide release 11i, Chapter 6 - Receipts, Applying Cross Currency Receipts, Calculating the Foreign Currency Exchange Gain or Loss.
44. Why does post quick cash not overapply receipts?
Answer ------ You cannot overapply a receipt to an open debit item using AutoCash rules.
References ---------- Please check the Oracle Receivables User Guide release 11i, Chapter 6 - Receipts, How AutoLockbox Applies Receipts, Overapplying Invoices.
45. How change a distribution set in a misc receipt?
Answer ------ When entering a Misc Receipt and selecting the receivable activity you are not able to select a specific distribution set. This is a non-updateable field. The values that you see are the ones that were setup in the setup>receipts>receivable activity.
References ---------- Please check the Oracle Receivables User Guide release 11i, Chapter 6 - Receipts, Entering Miscellaneous Receipts.
46. How group all of the misc receipts into a API receipt batch?
Answer ------ Receipt API for receipt batches has not been issued by Oracle.
47. How to Apply an On-Account Receipt?
Answer ------ See Note 142222.1, How to Apply an On-Account Receipt.
References ---------- Please check the Oracle Receivables User Guide release 11i, Chapter 6 - Receipts, Applying Receipts.
48. How do you change the GL date default for receipts?
Answer ------ Oracle Receivables defaults the current date for the receipt GL date as long as the date is in an open period. Otherwise, it will default to the last day of the most recent open period. There are no profile options available to stop the receipt's GL date from defaulting.
However, the profile option 'AR: Application GL Date Default' will control the GL date default when you apply receipts.
References ---------- See the Oracle Receivables User Guide Release 11i, Appendix B for more information on this profile option.
49. Why does payment method LOV not having any values when entering receipt batch?
Answer ------ Payment method associated with this batch source is probably enddated.
50. Why is the system not allowing you to pay the invoice or debit items of an unrelated customer?
Answer ------ Make sure system option Allow Payment of Unrelated Invoices is set to 'Yes'. To apply the on account receipt of one customer to another customers' invoices, instead of entering the transaction number of the unrelated debit item, you have to enter the customer number first, then you will be able to select an unrelated customer's debit item.
References ---------- See Note 1063174.6 Unable to apply a receipt to an unrelated transaction. Please check the Oracle Receivables User Guide release 11i, Chapter 6 - Receipts, Applying Receipts.
51. Why does receipt write-off report complete with no data found?
Answer ------ Please check Note 176785.1 Receipt Write-Off Report Completes With No Data Found.
52. Is there a limit to the number of times one can format a remittance batch?
Answer ------ There is no limit to the number of times you can format a remittance batch.
References ----------
Also see Chapter 6 - Receipts - Formatting Remittance Batches in theOracle Receivables User Guide for Release 11i
53. Why is AR: Enable Cross Currency profile option missing?
Answer ------ In patchsets 11.5.AR.H and forward, it is assumed that this option is enabled.
References ---------- See Note 207372.1 AR: Enable Cross Currency Profile Option is Missing.
54. How do you reverse receipts in a different period?
Answer ------ When you reverse a receipt, Oracle Receivables assigns the GL date and reversal GL date as the current date. If the current date is not in an open period, then it assigns both dates as the last date of the most recent open period. If the original GL date of the receipt is later than the current date, then Receivables uses the original GL date.
You can change the reversal GL date and GL date to any date in an open period that is on or after the original GL date for the receipt.
NOTE: If you want a transaction to be posted in a prior period, the period must be open. If the period is already closed and you do not want to open it, you will not be able to do this. Please be aware that reopening a period can lead to further unposted items. If you choose to go this route, please ensure that your data entry personnel do not enter any transactions into this period.
References
Frequently Asked Questions (FAQ)
Oracle Receivables Transaction Workbench Version 10.7, 11 & 11.5
The information in this document has been reviewed and is current as of 29-NOV-2002.
Instructions for the reader: This FAQ document identifies the most frequently reported how-to questions relating to the Receivables Transaction Workbench program. The articles below do not include bugs/patches or troubleshooting as these are addressed in great detail in the notes referenced at the bottom of this document. 
FAQ Summary
Why is the incomplete button greyed out for some transactions and not for others? 
How do you delete a transaction? 
Can price information default into the AR form? 
Can you changed the gl date on a transaction that has not been completed and has had no activity against it? 
Can you change the transaction number of an invoice after a transaction has been completed? 
You have imported transactions through autoinvoice from a legacy system with the wrong transaction date and they have already been posted to the GL. What do you do now? Can you make the correction through the tables? 
On the transactions form header there is a field called Reference, where can the value for this be found in the tables? 
How does the status of an invoice get changed to closed? 
Can you change the amount of a deposit after you have completed the transaction? 
Can you apply a receipt to a closed transaction? 
Where is the sales order number stored for transactions? 
Can the payment terms be changed on a posted invoice with no activity? 
You are creating a transaction but the remit to address is not being defaulted, what can be done to so that it automatically defaults? 
Where does the salesperson field get defaulted from in the Transactions form? 
Can you change the accounting segment on an Invoice with Rules? 
How to modify the invoice sequence so it no longer increments by 20? 
How do you apply a credit memo to a transaction? 
Can you incomplete a chargeback and change some of the information? 
Why is the Unit of Measure field greyed out on the line items portion of the form when trying to create a credit memo? 
You are attempting to enter an adjustment but you receive the following error "value entered is not valid for current field please re-enter." What should be done? 
How are the GL accounts derived for Credit Memos? 
What sign do I use to input my Credit Memo? 
Why are there 2 conflicting status fields for a transaction? (MORE and the ViewDetails tabs).
We are unable to copy credit memo from a completed credit memo. Is this feature available only for Invoice/Debit Memo?
Why can't I change the invoicing rule of a Credit Memo on form ARXTWMAI?
How do you setup Oracle Receivables to handle reoccuring invoices?
How do you create a transaction for TAX only?
FAQ Details
1. Q:Why is the incomplete button greyed out for some transactions and not for others?
A: Menu: Transactions -> Transactions Query up the transaction in question. Notice the complete box is checked and the GL Date field is populated. This means that the transaction has been posted to GL and therefore the incomplete button is now not available, hence it is greyed out. (Also, if you press the accounting button, the Accounting form will open. At the bottom of the form see the GL Posted Date field. This field informs you of the date the transaction has been posted.) There are three reasons why the complete button may be greyed out on a transaction. 1. It may already be posted to GL, as described above. 2. It may have been printed. Unless, you have the system option "Allow change to Printed Transactions" checked. 3. It has activity against it, even if the activity has been reversed. References:ARXTWMAI: Cannot Incomplete Invoices

2. Q: How do you delete a transaction?
A: There are four options available. If there is activity or you do not allow changes to be printed transactions you can use options 3 and 4. Option 1. 10.7 Character: Open the Enter Invoices form and use the \ Row Delete command. All other Releases: Simply use the Delete button. This will delete the invoice and any distributions. Option 2. Void the invoice by changing the invoice's transaction type in the Transaction form to a type with Open Receivables and Post to GL options set to No. This will delete the payment schedule record and cancel account distributions by removing the GL date. Option 1 & 2 can be done only if the invoice has no activity against it. Also, if the invoice has been printed and you have the profile option, 'AR: Allow Change to Printed Invoice' set to NO you will not be able to delete or void this invoice. Option 3. You can use this option if there us activity against the invoice. You can reverse the distributions by creating a Credit Memo against the invoice. Option 4. You can adjust the balance of the transaction to zero.

3. Q: Can price information default into the AR form?
A: In AR, the only was that you can default a price list is through standard memo lines. Standard memo lines are populated via the description field on the invoice lines form References: Price does not Default when Manually entering an Invoice

4. Q: Can you change the gl date on a transaction that has not been completed and has had no activity against it?
A:Yes, this can be done as long as the gl date is in an open period.

5. Q: Can you change the transaction number of an invoice after a transaction has been completed?
A:No, after completing a transaction, the transaction number field is protected against update.

6. Q: You have imported transactions through autoinvoice from a legacy with the wrong transaction date and they have already been posted to the GL. What do you do now? Can you make the correction through the tables?
A:The only supported method would be either to do adjustments for the transactions or issue credit memos against the transactions. Updating the transactions through the tables would not be supported.

7. Q: On the transactions form header there is a field called Reference, where can the value for this be found in the tables?
A: The field is mapped to one of the interface_header_attribute columns of the ra_customer_trx record. The profile AR_PA_COD (AR: Transaction Flexfield QuickPick Attribute) determines which one it is (e.g., profile = "1" --> reference mapped to interface_header_attribute1). References: What table.column holds the reference field/sales order number in ARXTWMAI

8. Q: How does the status of an invoice get changed to closed?
A:The status gets changed When the payment schedule amount_due_remaining is 0. Also, ensure that 'Show closed invoices' is selected from the special menu in the receipt applications form.

9. Q: Can you change the amount of a deposit after you have completed the transaction?
A:As long as no invoices have been applied against the deposit the amount can be changed. Once you have applied invoices against it, the incomplete button becomes greyed out.

10. Q: Can you apply a receipt to a closed transaction?
A: No, once an invoice is closed you cannot apply a receipt to it.

11. Q: Where is the sales order number stored for transactions?
A:At the header level, the sales order number is stored within the sales_order column of table ra_customer_trx_all. At the line level, the sales order number is stored with the sales_orders column of table ra_customer_trx_all. -OR- The sales_order could be stored in RA_CUSTOMER_TRX. INTERFACE_HEADER_ATTRIBUTE1-15 and RA_CUSTOMER_TRX_LINES. INTERFACE_LINE_ATTRIBUTE1-15. (Often, the sales_order is stored in ATTRIBUTE1 of the Line Transaction Flexfield.)

12. Q: Can the payment terms be changed on a posted invoice with no activity?
A:You cannot incomplete a posted invoice, therefore you cannot change the payment terms on that invoice. While you cannot change the payment terms, you can change the due date of a posted invoice in the Collections Workbench (ARXCWMAI), if the profile option, AR: Update Due Date is set to "YES". Menu: Collections -> Account Details Query the transaction and change the Due Date. The Days Late column will reflect the change. References: ARXTWMAI - Transactions Workbench: Cannot Change Payment Terms after Posting br>the Transaction 

13. Q: You are creating a transaction but the remit to address is not being defaulted, what can be done to so that it automatically defaults?
A: A "Default Value" should be assigned for the Country and State with a blank zip code range. By adding this "default value" will eliminate the user from having to enter every possible Country and State combination that may be used. Also, by using this "default value" items will pass validation without running into an error because the remit-to address is not defined. You can only have one default remit-to address defined. Character: (\ Navigate Setup Print Remit-To) All Other Releases: Setup -> Print -> Remit-To Addresses References:Remit To Address Is Not Defaulting On The Transactions

14. Q: Where does the salesperson field get defaulted from in the Transactions form?
A: For multi-org, you cannot enter a salesperson at the customer level, you can only assign a salesperson to a customer site. For non multi-org , you can assign a salesperson to a customer and to each of their site uses. To determine the salesperson that is defaulted during transaction entry, the hierarchy is as follows: FOR MULTI-ORG: If Salesperson is defined at Bill-To site, use this as default Else if Salesperson is defined at the Ship-To site, use this as default Else if System Options 'Require Salesperson' is set to Yes, then the Default is 'No Sales Credit' Else if system option 'Require Salesperson' is set to No then no Salesperson is defaulted FOR NON-MULTI ORG: If Salesperson is defined at Bill-To site, use this as default Else if Salesperson is defined at the Ship-To site , use this as default Else is a Salesperson defined at customer level, use this as default Else if System Options 'Require Salesperson' is set to Yes, then the Default is 'No Sales Credit' Else if system option 'Require Salesperson' is set to No

15. Q: Can you change the accounting segment on an Invoice with Rules?
A:If an invoice with rules has been created and the revenue has been already recognized for at least one of the periods and you want to change one of the accounting segment values, the best option is to reverse the invoice in full. If the period(s) for which revenue has been recognized is already closed, the credit memo will make entries for that transaction in the next open period.

16. Q: How to modify the invoice sequence so it no longer increments by 20?
A: The default cache is 20, but this can be altered to zero using NOCACHE as required. Altering to 0 will ensure sequence numbers are not 'lost' and consistency maintained (often an Auditors requirement.) For performance efficiency, Oracle uses caching with a default cache value of 20. That means that when you enter a transaction, 20 numbers are read into memory. The next time someone wants a number from the sequence, Oracle reads memory for the next number. It doesn't have to perform a disk I/O to read the next number from the sequence. That means that when memory is cleared after you commit a transaction and exit the form, numbers left in the cache are lost. That's why you get gaps in the number sequence between 1 and 20. You can avoid the problem by changing the sequences as follows: ALTER SEQUENCE RA_TRX_NUMBER__S NOCACHE; This change could affect the performance of Invoice entry in very high volume environments. References: How do you stop invoice numbers from jumping by 20?

17. Q: How do you apply a credit memo to a transaction?
A:Menu: Transactions->Transactions Query the credit memo, make sure that the transaction is complete. Using the menu, select Special => Applications Select the transaction that you want to apply the credit memo to. References: How to Create a Credit Memo Transaction White Paper Maintaining Invoice and Credit Memo Transactions White Paper

18. Q: Can you incomplete a chargeback and change some of the information?
A:No, you can not incomplete a chargeback in Receivables once the transaction has been saved and marked as Complete.

19. Q: Why is the Unit of Measure field greyed out on the line items portion of the form when trying to create a credit memo?
A:If you are creating an on account credit memo (meaning not against a specific invoice), the UOM is nulled out. Oracle Receivables does not concern itself with quantities or units of measure unless there is a specific invoice involved. References: Unit of measure is not available on a credit memo

20. Q: You are attempting to enter an adjustment but you receive the following error "value entered is not valid for current field please re-enter." What should be done?
A: The user should have a minimum adjustment limit defined Menu: Setup-> Transactions-> Adjustment Limits and define a minimum adjustment limit for the user. References: How To Setup Adjustments In Accounts Receivables

21. Q: How are the GL accounts derived for Credit Memos?
A:Check the profile option: AR: Use Invoice Accounting for Credit Memos If this is set to YES , then the credit memo associated with an invoice will use the accounting of the invoice. If this is set to NO , then the credit memo will use the accounting defined for the transaction type of the credit memo. Check Menu: Setup -> Transactions -> Transaction Type Query up the transaction type with a class of credit memo.

22. Q: What sign do I use to input my Credit Memo?
A: The system does not automatically assume that the transaction is negative. The default sign for the transaction only insures that the completed transaction has the sign you want. It does not assume that any entries are negative and does not create negative signs on either quantity or dollar amounts unless you specify that this is what you want. First, you will be able to add both positive and negative amounts to the transaction, but the system will force a final ending negative balance. Suggestions: If the quantity is returned, use a negative quantity. If the credit is an adjustment in price, use a negative dollar amount. This will differentiate to the users creating the transactions, whether the transaction was a return or a credit amount.

23. Q: Why are there 2 conflicting status fields for a transaction? (MORE and the ViewDetails tabs).
A: Status on the MORE Tab doesnt get updtd by the trans's being closed or by any action against the trans. Its a cosmetic field and gets populated by the setup in the trans type form. It can be manly updtd on the trans itself. The values are Closed, Open, Pending and Void.The other status is fr the payment schedules of the trans & is the relevant status for determining if transaction's balance is open or closed.

24. Q: We are unable to copy credit memo from a completed credit memo. Is this feature available only for Invoice/Debit Memo?
A: The form called Transaction Copy is intended to copy debit transaction types such as Invoices and Debit Memos. It is not intended to copy credit transaction types such as Credit Memos. The User's Guide refers to this screen in the Copy Invoices section. There is no section on Copy Credit Memos.

25. Q: Why can't I change the invoicing rule of a Credit Memo on form ARXTWMAI?
A: Credit memos do not have rules by themselves. The credit memo follows the initial distribution and rules created by the invoice. References: How To Create a Credit Memo with Rules

26. Q: How do you setup Oracle Receivables to handle reoccuring invoices?
A:Setup Receivables to handle billing in ADVANCE, issuing Accounting Rules and Duration. By Billing in Advance: Because you are billing the customer for an entire invoice in the first accounting period, the offset account must be UNEARNED REVENUE. Revenue is considered earned only when services or support have been provided. References: How to setup Reoccuring Invoices, Monthly Billing

27. Q: How do you create a transaction for TAX only?
A:1. Make sure that you have created an ADHOC tax rate. Menu: Setup=>Tax=>Codes 2. Make sure that you have set the following profile options to "YES" TAX: Allow Ad Hoc Tax Changes TAX: Allow Override of Tax Code 3. Create a memo line in Receivables with an amount of zero and a line_type equal tax. Menu: Setup=>Transactions=>Memo Line 4. Create an invoice, with the Memo Line that you just created in the description of the line item. 5. Click on Tax Button, make sure the Tax Code is the adhoc tax rate that you created. 6. Enter the Tax amount in the amount field and save. References: How to create a TAX only invoice in Receivables

IMPORTANT: If you did not find the information you were searching for, please review the following Transaction Workbench information:
Transaction Workbench Setup and Usage Instructions Transaction Workbench Current Issues Transaction Workbench Troubleshooting Guide Consolidated Billing Invoices FAQ
Frequently Asked Questions (FAQ)
Oracle CollectionsStrategies Version 11.5
The information in this document has been reviewed and is current as of 23-July-2003.
Instructions for the reader: This FAQ document identifies the most frequently reported how-to questions relating to the Oracle Collections Pay Invoice sub-program. The articles below do not include bugs/patches or troubleshooting as these are addressed in great detail in the notes referenced at the bottom of this document.
FAQ Summary
What is a Strategy? 
What makes strategies effective? 
What is a filter and why do Collections Strategies need them? 
How do customers leverage these filters? 
What is the difference between a Strategy and a Checklist? 
Where do I create Checklists? 
Can Checklists be shared across multiple Strategies? 
How are Strategies assigned to delinquent customers? 
What happens if there is not a match on the Strategy? 
What if there is not a Default Strategy identified? 
Is it possible to honor "grace days" when creating strategies? We may not want to contact customers until the grace days have passed. 
Is it possible to have groups of customers that should receive Strategy Dunning Work Items and those that are excluded? 
Can I create Collections Strategies that feed Oracle's Predictive Dialer? 
So, I can use both Strategies and Advanced Outbound? 
I have created a new Strategy using the Collections HTML Manager responsibility. But when I log into the Forms application as Collections Agent, open Collections, find a customer, navigate to Strategy Tab and click the Change Strategy Button, my new strategy is not listed.
As a Collections Agent, I have clicked on the Change Strategy Button on the Strategy Tab, selected the new Strategy, and clicked OK. I receive a confirmation message that my strategy has changed, but when I check the Strategy Tab, only the original strategy is listed.
I click on change strategy button to assign a new strategy, select the strategy and click OK. But, the new strategy appears and is automatically closed. So, the system is not changing the strategy.
I've noticed that all of my Fuflillment/Send Dunning Work Items are in "Open" status. How do I get them sent?
What happens to my Strategy when I take a Promise to Pay?
I re-ran my scoring engine and have a new score for the Collections object (Party, Account, Transaction). I then re-ran Strategies Concurrent Programs but did not get new Strategies assigned. What happened?
Where can I go to read more about Collections Strategies?
What will be different for Strategies in 11.5.9?
FAQ Details
1. What is a Strategy?A:A Collections Strategy is a series of automated and/or manual assignments called "Work Items" that a collecting organization creates to improve collector's effectiveness when collecting bad debt. These "best practices" Collections Strategies are assigned a numeric "Rank". The Score of a Party, Account, Invoice or Case is matched to this "Rank" to determine the appropriate Strategy.

2. What makes strategies effective?A:To be effective, Collections Strategies must be configurable, provide a high degree of automation when appropriate, adaptable to a collecting organization's business practices, and provide direction and prioritization to collectors performing the collections activities.

3. What is a filter and why do Collections Strategies need them?A: Oracle Collections allows collecting organizations to segment or filter their database into groups of customers based on many different criteria. These Filters are Views on the database. Collections uses Filters for Scoring, Strategy Selection and as part of a Scoring Component. Each View represents a Universe of Customers (or their delinquent objects) that meet a set of criteria. A Filter is required for Scoring Engines but is optional for Strategies. The Filter for Scoring Engines identifies which transactions will be scored by that Scoring Engine. The Filter for Strategies identifies which scored objects are eligible for that Strategy. Scoring Components use views in certain instances: if you want to use a select statement that uses the result from another select statement as input, then you need a View.
4. How do customers leverage these filters?A: Collecting organizations realize that one collections strategy does not fit all. They really want to Treat Different Customers Differently. Reasons for this range from different legal guidelines across the various countries in EMEA to small versus large customers to new versus long term customers. By using Filters/Views to create different Universes of Customers, collecting organizations can use unique Scoring Engines and Strategies that are applicable to each Customer Universe. This enables the collecting organization to hone their strategies for specific customer groups which ultimately result in more effective collections rates and satisfied customers. 
5. What is the difference between a Strategy and a Checklist?A:A Strategy is a series of distinct Work Items that are executed in a sequential manner. Work Items are either automated or manual; and are send a letter (email, fax, print), make a call or visit. Each Work Item is actionable and when one is completed, the next begins until the delinquencies are cured or the Strategy is changed. A Checklist is a granular list of items that a collector should ensure are completed as they work their delinquencies. Checklists are not meant to duplicate a list of Work Items for a Strategy, but to provide additional information for the collector to review. A Checklist may be particularly useful to a new collector who needs assistance in learning the required collections steps or for the specialist who may be tracking the completion of bankruptcy or litigation filings. The checklist is not tied to a particular Work Item in a Strategy, but are meant to be used throughout the Strategy. Items on a Checklist are not actionable. The collector can check off the completed items on a checklist but this does not impact the Strategy progression from one Work Item to the next in any way.

6. Where do I create Checklists?A:Checklists are created in the same Administration screens where Strategies are created. This is on the Strategy Tab in the HTML screens. While on this tab, you indicate if you are creating a Checklist by setting the Checklist field to Yes. Then, you build the Checklist by selecting one or more Work Items. The Work Items then appear on the Checklist UI when the Collector (FORMS) or Specialist (HTML) clicks on the Checklist Button. If you set the Checklist Flag to No then the system understands you are creating a Strategy and not a Checklist. By using the same Administration screens, the manager/administrator can re-use Work Items as both items on a Checklist as well as Strategy.

7. Can Checklists be shared across multiple Strategies?A: Yes. When the manager creates a Strategy, they have the option to link a Checklist to it. When you click into the Chekclist Template field, the system pops a Checklist Search window where the manager selects an existing Checklist for the new Strategy.

8. How are Strategies assigned to delinquent customers?A: Strategy selection and assignment is based on the matching of several parameters. The Strategy Management Concurrent Program kicks off the process to: 1) Verify that the Strategy level matches the object being scored. In 11.5.9, there is a new Set Up Screen in HTML that requires the collecting organization determine the level they will run their collections efforts at: Customer (Party), Account or Transaction. So, the system determines the level and will only select a Strategy that was create for that level. 2) The system compares the score of the object with the Rank on the Strategy. If there is not an exact match, then the system looks for the Strategy with the closest but lower Rank. 3) The system compares the Category of the object with the Strategy's Category. Category choices are Delinquent; Pre-Delinquent; Bankruptcy; Write Off; Litigation and Repossession. 4) The system determines if the object is defined in the Filter associated to the Strategy.

9. What happens if there is not a match on the Strategy?A: If there is not a match, then the system assigns a default Strategy. This default strategy is defined in the profile: IEX: Strategy Default Template.

10. What if there is not a Default Strategy identified?A: If there is not a default strategy assigned, the system selects another defined Strategy on the system. It is generally the first active Strategy on the database. Hint: if you feel that the wrong Strategy was assigned, verify that the strategy you were expecting is set to Active. The system will not assign an inactive Strategy.

11. Is it possible to honor "grace days" when creating strategies? We may not want to contact customers until the grace days have passed.A: Yes this is quite possible. The seeded Invoice Scoring Component looks simply at the due date of the installment and if it is passed, the Invoice/Installment is "scored" and a delinquency is created. You could create a new component that looks at due date and adds the number of grace days that are offered. That way, these Invoice/Installments are not flagged as delinquent. You could also use the Score Range Configuration to identify these items in the grace period as "pre-delinquent" and have a holding Strategy or a polite reminder Strategy initiated.

12. Is it possible to have groups of customers that should receive Strategy Dunning Work Items and those that are excluded?A: Yes, this can be achieved through the use of strategies and filters. 1. Create 2 views, one that lists all customers you want to receive dunning letters and the other that lists the ones you do not want to send dunning letters to. For example: create view iex_f_strat_dunn_v as (select a.delinquency_id, a.party_cust_id from iex_delinquencies_all a, ar_customer_profiles_v b where a.cust_account_id = b.CUSTOMER_ID and b.dunning_letters = 'N') -On this example this will be a filter so dunning is NOT sent. 2. Create 2 strategies, one that sends dunning and one that does not send dunning. 3. Assign the filters you created on step 1 to the strategies from step 2. 4. When the strategy selection runs it will look at the available strategies and use the filters to select what strategy should be used against which customer to send or exclude from dunning.

13.Can I create Collections Strategies that feed Oracle's Predictive Dialer?A: Oracle's Predictive Dialer is the EBusiness Suite product module named Oracle Advanced Outbound. Outbound Campaigns are created using either a combination of Discoverer/Oracle Marketing Online or importing lists of delinquent customers from other sources. Discoverer/OMO can create a list based on any criteria in the database including Strategy information. When Collections Strategies were created, it was envisioned that a collecting organization would use either Strategies or Advanced Outbound, but not both.

14. So, I can use both Strategies and Advanced Outbound?A: Although Collections Strategies do not actually "feed" the dialer, Customers can use the combination of Collections Strategies and OMO/Advanced Outbound to successfully complete their work. See the suggested steps below to attain this: Step 1: create appropriate universe and strategy to flag items for the dialer a. create a universe of customers who should be flagged for the dialer: universe could be customers who are 8 to 60 days late b. create Collections strategy with several work items: b1. Send Dunning b2. wait X days then make (predictive) call: why don't we call this Predictive Call Review Work Item Step 2: Run Concurrent Programs to Score and assign Strategies Step 3: execute Send Dunning work item Step 4: reconcile payments with delinquent customers and close strategies that have resulted in payments a. assumption is that some customers will pay when they receive the dunning letters; other customers will call into the Collections Center if there is a number to call on the Dunning Letter b. the Strategies of the customers who have paid will be automatically closed Step 5: create campaign (OMO/Advanced Outbound) for records that have the "predictive" call work item flag Step 6: send campaign to call center a. Advanced Outbound makes calls b. assumption is that more of these delinquent customers will be contacted and cured Step 7: as the Strategies progress, the strategies of the customers who have been cured will be closed Step 8: when the "predictive" call work item shows up in UWQ, the collector decides what to do (change strategies, make another call, etc.) a. assumption is that these customers are the hard-core delinquent ones who have not responded to the dunning letters nor the predictive calls b. collector (or Collecting Organization) needs to decide what to do next So, although the Strategies don't automatically "feed" the dialer, the two approaches to curing delinquent customers can be used to complement each other.

15.I have created a new Strategy using the Collections HTML Manager responsibility. But when I log into the Forms application as Collections Agent, open Collections, find a customer, navigate to Strategy Tab and click the Change Strategy Button, my new strategy is not listed.A: This is a common first time mistake. Be sure that the Strategy Enable Flag is set to "Y" (yes). When you first create a Strategy, the Enable Flag is set to "N" (no). After you have created the strategy and added the necessary work items, remember to set the Enable Flag to "Y" (yes).

16. As a Collections Agent, I have clicked on the Change Strategy Button on the Strategy Tab, selected the new Strategy, and clicked OK. I receive a confirmation message that my strategy has changed, but when I check the Strategy Tab, only the original strategy is listed.A: After the change strategy successful message is displayed, you need to refresh the Strategy Tab to see newly assigned (changed) strategy. Simply click the 'Display All' Check box to show all Strategies including closed one and immediately remove the "Display All" Check box to show only the newly assigned Strategy.

17. I click on change strategy button to assign a new strategy, select the strategy and click OK. But, the new strategy appears and is automatically closed. So, the system is not changing the strategy.A: When a "newly changed strategy" is immediately closed it is because the new strategy does not have any work items as part of its Strategy Template. Go back into the Collections HTML Manager Set Up Screens and add some work items for that strategy templates.

18. I've noticed that all of my Fuflillment/Send Dunning Work Items are in "Open" status. How do I get them sent?A: Check with the Collections Forms Administrator. They need to run the workflow background process and choose parameter 'IEX: Fulfillment Mailer' and the workitems will be executed. This workflow background process should be scheduled to run on regular intervals many times per day.

19. What happens to my Strategy when I take a Promise to Pay?A: In 11.5.8, when a collector takes a promise to pay against a transaction, the strategy for that transaction is suspended until the promise is either broken or kept. If broken, the strategy resumes with the next work item in that strategy. If kept, the strategy is automatically closed. Hint: after taking the Promise, the collector should leave their "Call" work item open. The work item will not be displayed in UWQ since the strategy is on hold.

20. I re-ran my scoring engine and have a new score for the Collections object (Party, Account, Transaction). I then re-ran Strategies Concurrent Programs but did not get new Strategies assigned. What happened?A: Strategies are not re-assigned to objects with existing strategies just because the Strategy Concurrent Program is run again. A new strategy will only be assigned if the old one has completed and the delinquency is not cured or if the collector clicks the Change Strategy button on the Strategy Tab.

21. Where can I go to read more about Collections Strategies?A:There is Technical White Paper posted on MetaLink that provides details on why collecting organizations use Collections Strategies and how they can configure Scoring and Strategies to meet their business needs. The Technical White Paper provides information relevant to the 11.5.8 release and will be updated for 11.5.9 in the future. To find the Technical White Paper "Using Collections Scoring and Strategies for Superior Collecting" cut the following link and paste into your browser: http://metalink.oracle.com/metalink/plsql/showdoc?db=NOT&id=215011.1

22. What will be different for Strategies in 11.5.9?A:In 11.5.9, Strategies can be assigned at the Party (Customer) level or the Account level. The White Paper details how to create Strategies and Scoring Engines for Transactions only as was the functionality in 11.5.8. So in 11.5.9, collecting organizations determine what level they will run their business (Customer/Party or Account or Transaction) and then create the necessary scoring engines and strategies to meet their needs. The concepts of scoring and strategies are still the same even though the customer has the option to determine the level of execution