ORA-12713 Running a Report on Unix Environment

(Doc ID 1627746.1)

Last updated on FEBRUARY 01, 2016

Applies to:

Oracle Reports Developer - Version 11.1.2.1.0 and later
Information in this document applies to any platform.
Checked for relevance on 01-FEB-2016

Symptoms

On SQL*ReportWriter version, 11.1.2.1.0 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.

ERROR
-----------------------
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

 

STEPS
-----------------------
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


Changes

 Changed the NLS_LANG value in reports.sh

Cause

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