ORA-12713 Running a Report on Unix Environment

(Doc ID 1627746.1)

Last updated on FEBRUARY 12, 2018

Applies to:

Oracle Reports Developer - Version and later
Information in this document applies to any platform.


On SQL*ReportWriter version, or higher

When attempting to run a particular report on a Unix environment using NLS_LANG as CANADIAN FRENCH_CANADA.WE8ISO8859P1 in reports.sh the following error occurs.

REP-771: Une erreur grave PL/SQL s'est produite dans l'unité de programme afterpform.
ORA-12713: Perte de caractères dans la conversion NCHAR/CHAR


The issue can be reproduced at will with the following steps:
1. Install Oracle Reports on Linux change in the reports.sh the NLS_LANG to CANADIAN FRENCH_CANADA.WE8ISO8859P1
2. run  your report using

   $INSTANCE_HOME/config/reports/bin/rwclient.sh server=rep_custom report=/path/tf5003.rdf userid=$HIDDEN desformat=PDF destype=file desname=/tmp/out.pdf


 Changed the NLS_LANG value in reports.sh


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms