Monday, 23 April 2012

reprte NLS_NUMERIC_CHARACTERS error

+---------------------------------------------------------------------------+
NSORO Custom Application: Version : UNKNOWN

Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

MASNSPMVEN module: Nsoro List of Project Managers By Vendors Report
+---------------------------------------------------------------------------+

Current system time is 23-APR-2012 02:18:15

+---------------------------------------------------------------------------+


+-----------------------------
| Starting concurrent program execution...
+-----------------------------

Arguments
------------
P_MANAGER_NAMR='AARON'
------------

Environment will now switch to UTF-8 code-set.
Parts of this log file may not display correctly
as a result.  This is an expected behavior.     

 XML_REPORTS_XENVIRONMENT is : 
/u01/nsd01/nsd01ora/8.0.6/guicommon6/tk60/admin/Tk2Motif_UTF8.rgb

 XENVIRONMENT is set to  /u01/nsd01/nsd01ora/8.0.6/guicommon6/tk60/admin/Tk2Motif_UTF8.rgb


 Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are :
American_America.UTF8

'.,'


Report Builder: Release 6.0.8.28.0 - Production on Mon Apr 23 02:18:15 2012

(c) Copyright 1999 Oracle Corporation.  All rights reserved.

Enter Username: 
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+


+---------------------------------------------------------------------------+
Executing request completion options...

+------------- 1) PUBLISH -------------+
Beginning post-processing of request 6361621 on node NSD01 at 23-APR-2012 02:18:24.
Post-processing of request 6361621 failed at 23-APR-2012 02:18:24 with the error message:
One or more post-processing actions failed. Consult the OPP service log for details.
+--------------------------------------+

+------------- 2) PRINT   -------------+
Not printing the output of this request because post-processing failed.
+--------------------------------------+


Finished executing request completion options.

+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 23-APR-2012 02:18:24

+---------------------------------------------------------------------------+
 
 
 =========================

Solution

======================

Applies to:

BI Publisher (formerly XML Publisher) - Version: 9.2.0.8 - Release: 9.2
Information in this document applies to any platform.

Symptoms


Using XML Publisher to generate a custom report.
You created an RDF report, configured it as a concurrent program,
changed output to XML and created a .rtf template in XML Publisher in order to have output in .pdf
When run, no output is generated.
The OPP log contains errors Caused by: java.io.UnsupportedEncodingException: &Encoding

Cause


Incorrect encoding value in the report's prolog

Solution



To resolve the issue:

1.Open the custom report in the Report Builder

2.Go to the property pallette of the Report

3.Remove the xml prologue value

4.Save the changes

5.Retest the issue.

6 comments:

  1. I tried applying your solution to the same problem i am facing but the problem still persist. find here the error message:

    Forcing NLS_NUMERIC_CHARACTERS to '.,' for XDO processing
    Current NLS_LANG and NLS_CHARACTERS Environment Variables are:
    American_America.US7ASCII

    '.,'

    Enter Password:
    REP-0004: Warning: Unable to open user preference file.

    ReplyDelete
    Replies
    1. Hey. Did you get the solution of it?
      I am getting the same error.

      Delete
  2. Forcing NLS_NUMERIC_CHARACTERS to: '.,' for XDO processing
    Plz any solution ?

    ReplyDelete
  3. +---------------------------------------------------------------------------+
    Purchasing: Version : 12.0.0

    Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

    XX_EMP module: xx_emp
    +---------------------------------------------------------------------------+

    Current system time is 06-DEC-2019 19:42:49

    +---------------------------------------------------------------------------+


    +-----------------------------
    | Starting concurrent program execution...
    +-----------------------------


    Forcing NLS_NUMERIC_CHARACTERS to: '.,' for XDO processing

    APPLLCSP Environment Variable set to :

    Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are :
    American_America.AL32UTF8

    '.,'

    Enter Password:

    Report Builder: Release 10.1.2.3.0 - Production on Fri Dec 6 19:42:50 2019

    Copyright (c) 1982, 2005, Oracle. All rights reserved.


    +---------------------------------------------------------------------------+
    Start of log messages from FND_FILE
    +---------------------------------------------------------------------------+
    +---------------------------------------------------------------------------+
    End of log messages from FND_FILE
    +---------------------------------------------------------------------------+


    +---------------------------------------------------------------------------+
    Executing request completion options...

    Output file size:
    3430


    Output is not being printed because:
    The print option has been disabled for this report.

    +------------- 1) PUBLISH -------------+
    Beginning post-processing of request 5846575 on node APPS at 06-DEC-2019 19:42:52.
    Post-processing of request 5846575 failed at 06-DEC-2019 19:44:52 with the error message:
    The Output Post-processor is running but has not picked up this request.
    No further attempts will be made to post-process this request, and the request will be marked
    with Warning status.
    Setting the profile option Concurrent: OPP Response Timeout to a higher value may be necessary.
    +--------------------------------------+

    +------------- 2) PRINT -------------+
    +--------------------------------------+


    Finished executing request completion options.

    +---------------------------------------------------------------------------+
    Concurrent request completed
    Current system time is 06-DEC-2019 19:44:52

    +---------------------------------------------------------------------------+



    i am getting error could please any one help me

    ReplyDelete
    Replies
    1. Hello,

      Did you have solution, i have the same error.

      Thanks in advance,

      Delete