How to Customize your dunning letters for a language change?

While dealing with customizations in different languages one of the frequently encountered problem is changing the headings of
the columns in the letter and changing the verbiage of the letter. Oracle provides the facility to change the verbiage via
external files that resides in $AR_TOP/srw location on the application.

The column name reside in the RDF file so one has to customize the rdf file to achieve that change.

For instance if you want to have the text in German or Dutch for the Dunning letter. The numeral part that is invoice amount etc  is same as roman but the verbiage of the letter and the column headings need to be changed. One of the problems with dunning
letters is that it prints the columns on the first page of the letter and then it does not on the subsequent pages and that can
be discombobulating. To overcome the aforesaid hurdle do the following.

1. Change the ardlxx.txt files according to your needs by changing the verbiage in a text editor.
2.Copy the ARDLP.rdf file and change its name.
3. Change the XXX_ARDLP.rdf file by opening it in the reports designer for the following
 a) In the before report trigger ascertain the country that you are running for.
 b) with that as a parameter introduce the boiler plate texts and flip the format trigger( return true or false)
     according to this parameters

4. Change the print condition to ALL on the boiler plate properties to print heading on all the pages.

Have a Oracle Question
Do you have an Oracle Question?

Oracle Books
Oracle Certification, Database Administration, SQL, Application, Programming Reference Books

Oracle Application
Oracle Application Hints and Tips

Oracle Home
Oracle Database, SQL, Application, Programming Tips

All the site contents are Copyright © www.erpgreat.com and the content authors. All rights reserved.
All product names are trademarks of their respective companies.
The site www.erpgreat.com is not affiliated with or endorsed by any company listed at this site.
Every effort is made to ensure the content integrity.  Information used on this site is at your own risk.
 The content on this site may not be reproduced or redistributed without the express written permission of
www.erpgreat.com or the content authors.