Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

XML Publisher Report Issue

Received Response
73
Views
8
Comments
Vidhey Shrivastava-92944
Vidhey Shrivastava-92944 Rank 2 - Community Beginner
in Oracle Analytics Cloud and Server

Summary

XML Publisher Report Issue

Content

Hi,

We are trying to run XML Publisher Based custom AR Statement which generates PDF Output. The program is finishing Normal but we get the following error when viewing the Output(for every customer, thus issue not specific to any particular customer):

The XML page cannot be displayed

Cannot view XML input using style sheet. Please correct the error and then click the Refresh button, or try again later.

Invalid at the top level of the document. Error processing resource

No particular errors in log file, as below:

Executing request completion options...

+------------- 1) PUBLISH -------------+

Beginning post-processing of request 95472780 on node DISVA422 at 04-MAY-2017 09:56:58.

Post-processing of request 95472780 completed at 04-MAY-2017 09:57:00.

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

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

Printing output file.

  Request ID : 95472780

  Number of copies : 0

  Printer : noprint

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

Finished executing request completion options.

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

Concurrent request completed successfully

Current system time is 04-MAY-2017 09:57:01

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

3 Other observations seen:

1) XML is fully formed and we are able to open the XML from internet explorer. Thus, no issues from XML generation point of view.

2) We could not see any Non-UTF Characters in the XML data.

3) "FND: Native Client Encoding" profile option value is set as "UTF-8" at site level.

We are not able to find any good reason as why this should fail.

Appreciate your help!

Thanks,

Vidhey

Answers

  • Brajesh Shukla-95078
    Brajesh Shukla-95078 Rank 7 - Analytics Coach

    Please check from below sql what encoding install at your database. Please set the same for profile option "FND: NATIVE CLIENT ENCODING" respective level.

    If you already set the FND: NATIVE CLIENT ENCODING to "UTF8"(Please verify its should be UTF8 not UTF-8) then please verify other level value e.g. responsibility or OU level value is not over ridding your site value .

    select value from nls_database_parameters where parameter = 'NLS_CHARACTERSET';

  • Rajesh123
    Rajesh123 Rank 6 - Analytics Lead

    hi ,looks like you XML Tag is not created correctly.

    Means, your parent group tag.

  • Rahul Bagul
    Rahul Bagul Rank 1 - Community Starter

    Hi All,

    We check and found that profile  FND: NATIVE CLIENT ENCODING  is set as  "UTF8"

    Thanks

    Rahul

  • Rajesh123
    Rajesh123 Rank 6 - Analytics Lead

    save the xml tag and try to run the report from desktop and let me know

  • Vidhey Shrivastava-92944
    Vidhey Shrivastava-92944 Rank 2 - Community Beginner

    XML is created fine, we have checked the same by accessing the View XML Button and opening the output through internet explorer.

  • Vidhey Shrivastava-92944
    Vidhey Shrivastava-92944 Rank 2 - Community Beginner

    Hi Rajesh,

    We have not yet been able to resolve this. Working on the same.

    It would be a great help if there are any further suggestions from your end that we can try in your system.

    Thanks,

    Vidhey

  • Rajesh123
    Rajesh123 Rank 6 - Analytics Lead

    Hi did you get the solution , can u please provide here?

  • Rajesh123
    Rajesh123 Rank 6 - Analytics Lead

    did you resolved issue?