Language Issue in Oracle EBS .pdf reports

Language Changed in Oracle E Business Suite Release 12 .pdf reports after applying patch:


In Oracle E Business Suite Release 12 after applying few patches the report in pdf format show different language.

To resolve the issue see workaround mentioned below:

Login Application Server through putty or VNC Viewer.

Edit Enviornment file in Application Server
vi PROD_erpapps.env

Find NLS_LANG

THIS SHOULD BE CHANGED TO AS PER BELOW:
NLS_LANG="American_America.US7ASCII"
export NLS_LANG


Find the word as per below:

/test

Press N to find next till reached the place something like [ if test "UTF8" = "UTF8"; then ] change to below mentioned line:

if test "US7ASCII" = "US7ASCII"; then

Bounce the Instance

Generate Oracle Trace Files

To generate oracle trace files Use the following below commands:

alter session set sql_trace=TRUE;

Above command will turn the trace session ON

ALTER SESSION SET TRACEFILE_IDENTIFIER='39337675761' EVENTS '10046 TRACE NAME CONTEXT FOREVER, LEVEL 12';

Above command will generate the trace file with the number 39337675761.trc file with prefix of  sid_ora_pid_traceid.trc

@ c:\sql_file.sql

Execute the above command.

alter session set sql_trace= false ;

Turn Tracing off with above command.

To find out the location of trace file generated query V$DIAG_INFO. 

For Example:

SELECT VALUE FROM V$DIAG_INFO WHERE NAME = 'Default Trace File';

OR

select value
from v$parameter
where name = 'user_dump_dest';