September 9th, 2010

R12: Create dunning letters at delinquency level

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.

September 7th, 2010

Pay Slips as attachments in PeopleSoft

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.

September 1st, 2010

PeopleTools 8.51 Advisor Webcast

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

September 1st, 2010

Maintenance of objects in ARIS 7.1

During the use of ARIS, the designers and architects has sometimes unexpected problems using the objects and models. When they make models, a lot of different objects were used. Not only objects in their own domain, but also objects defined by other modelers and somewhere stored in the repository on the server. Even new objects were made beside the same objects, so the same object could stand more than once in the repository. Using these objects create sometimes smaller of bigger problems. In this article the most asked questions about the use of objects will be answered, like disappeared objects, disappeared text in objects, the use of objects in the repository and the consolidation of the objects.
July 30th, 2010

Ultimate Oracle source collection: part III, E-Business Suite

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