I’m emptying out the trove of documents I have from my Oracle consulting days. The Cash Application Work Queue that came out with Oracle Receivables in the 12.1 upgrade was a great feature that is really very basic. In fact, before it came out my friend and I had been brainstorming how to create this function for our client so it was one less thing we had to worry about. Here is a quick setup.
Menu / Request Option Setup
When you upgrade to R12.1 the new concurrent request to run the rules engine has not been attached to the “Receivables All” request group. Add “Assign Cash Application Work Items” to your request set. It should probably be scheduled to run on intervals.
1. Assign a default user. This the fallback if none of the rules you create pick up a receipt
2. This form in the screen shot has an extra tab (Cash Application Owners) that errors when you click on it. (Note 880923.1) I opened SR 3-1184593321 at the time of implementation and they said that there is only a data script fix for this at the moment.
2. Create a rule name and conditions. Under “Result” enter who that particular rule gets routed to.
Receipts > Cash Application Work Queue
Here it defaults to your user id and you hit search to see what you have that is unapplied in your queue. Click the “Apply Receipt” button to open up the receipt window to apply the receipt. Remember, you need to run the concurrent request to sort the receipts to the appropriate owners based on the rules you created.
Select update to make notes about the receipt. These notes are not added to the receipt. You can also change the status of the work item in this window.
The work item status are found via this query.
Select * From AR_LOOKUPS ARL WHERE 1=1 AND ARL.LOOKUP_TYPE='WORK_ITEM_STATUS'