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

Concurrent Request
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.

Standard Forms

Setup > Receipts > Cash Application Owner Assignment

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.

Rules Engine

Setup a default user name.  Then create rules and sequence them.

2. Create a rule name and conditions.  Under “Result” enter who that particular rule gets routed to.

Application Workbench

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'