Since receivables dunning letters have been obsoleted in R12, it’s hard to find useful information on the Oracle Support site about dunning letters in R12, especially about running dunning letters at delinquency level. In R12 now you will need to run Oracle Advanced Collections Dunning Plans instead.

A couple of months ago one of our customers asked me to find out if it’s possible to send dunning letters at delinquency level per customer/transaction type. They were using 4 transaction types and wanted also a different dunning letter template for each transaction type, so I was facing another challenge on that.

I knew before I started my research that dunning letters in R12 were based on transaction scoring. You have to define one or more score components, score-engines and dunning plans to get this all working. Oracle delivers seeded score components and score-engines, but all that seeded stuff wasn’t really helpful for me.

First thing I did was searching for more information on the Oracle Support site and reading the implementation guide to get an idea where to begin with the setup. As you can guess I could find hardly any information about dunning letters at delinquency level. All information I found was about dunning letters at customer level, because 95% of the Oracle eBS customers is using dunning letters at customer level.

With the attachment functions in PeopleSoft it is possible to load pay slips, annual statements or other documents into the database. It is a good idea to have the attachments into the database, because then you can handle the security with PeopleSoft (and with Oracle on the database level), instead of on the file system. In this case the attachments are in PDF format. Once the pay slips are uploaded into the database, it is possible to view them by clicking on a link in ESS (Employee Self Service). When you click on the link, acrobat reader will start and present the pay slip in a new window. The user can print the pay slip or annual statement from acrobat reader.

Example ESS page

When all pay slips and annual statements would be printed by everyone, surely there is no business case for saving paper. But nevertheless there is a business case for saving stamps. In practice not all of the pay slips will actually be printed, however.

Listen to Jeff Robbins giving an overview of PeopleTools 8.51 through this recorded advisor webcast.

According to Jeff Robbins we can expect release 8.51 in Q3 this year and 8.52 in Q3 next year, keeping in mind the Oracle safe harbor statement.

Click here for the webcast

After the ‘ultimate collection’ of PeopleSoft and Siebel, this last post in the series is an ‘ultimate collection’ of E-Business Suite (re)sources.

• E-Business Suite Wiki: E-Business Suite Wiki by Oracle
• Product tagged E-Business Suite : Siebel related products from the Oracle Mix Social Network
• Ideas tagged E-Business Suite: Ideas about E-Business Suite via the Oracle Mix Social Network
• Oracle Mix E-Business Suite Groups: E-Business Suite groups via the Oracle Mix Social Network