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.

Return to : Oracle Database, SQL, Application, Programming Tips