Date format <?format-date:TRX_DATE;'MEDIUM' ?>
We are upgrading our systems from 11i and R12.
We use XML publisher to print AR invoice.
We have templates in different languages.
To format the date <?format-date:TRX_DATE;'MEDIUM' ?> we have used this feature of the it is working as expected in 11i, the XML is publishing the dates as per that country rules based on the combination of language and territory. Uploading the screen shot of the xml date format
But in R12, it is not giving the expected output, the date format by default is taken as American english, XML is ignoring the mask option.