BI publisher report is printing XML tags in the output instead of actual output.

User_36Q42

Summary

BI publisher report is printing XML tags in the output instead of actual output.

Content

Hi,

I am working on a new XML publisher report. Report is printing XML tags in the output instead of actual output. I have checked RTF file but not able to figure out what is missing. It is a single record and doesn't has group. Fields also looks having proper tag in Add help Text.

Please find attached RTF file and Data Template. Appreciate any hint on what I am missing here.

 

Thanks,

Mahendra

User_36Q42

Thank you for the reply. Please find attached sample data file.

YGUTTIKONDA

check the link provided earlier in this thread ..

there are three parts

1) Concurrent Program

2) Data Template / Definition

3) Template Definition

make sure that all the 3 are setup properly and are linked. ....

User_36Q42

I have used data template file name in the Data template code. Should it be data template code instead (LLKBRCVTKT_FG)?

<dataTemplate name="ABL_FG_KANBAN_RCV_TKT" description="ABL_FG_KANBAN_RCV_TKT" Version="1.0">

-----------

<?xml version="1.0"?>

<dataTemplate name="ABL_FG_KANBAN_RCV_TKT" description="ABL_FG_KANBAN_RCV_TKT" Version="1.0">

<parameters>

<parameter name="P_TRANS_ID" dataType="number" defaultValue=""></parameter>

<parameter name="P_TKT_NUM" dataType="number" defaultValue=""></parameter>

</parameters>

<dataQuery>

<sqlStatement name="Q1">

<![CDATA[

select msib.segment1 item

,      '!I/C'||replace(replace(msib.segment1, '/', '/O'), '*', '/J')||'!' ITEM_BAR

,      msib.description descr

,      mkc.kanban_card_number kanban_card

......

.......

User_36Q42

Please find attached concurrent program screen shot. sample data file attached in my earlier update is the output of the report.

Thank you ,

Mahendra

YGUTTIKONDA

ok can u check the Data definition setup and the template setup using the XML Publisher Admin responsibility and make sure they are linked properly .. I doubt that the template definition is not set properly ..

YGUTTIKONDA

can u send me screen shots of the output from apps ? Also screen shots of Concurrent Program , Data Definition and Template would be good ot take a look at

User_36Q42

Thank you for checking. We don't see XML tag when run from BI Publisher but giving XML Tags in the output when registered and running from Oracle Apps.

Dir_Pal

This might be of some help

https://apps2fusion.com/at/ps/262-xml-publisher-and-data-template-sql-query-to-develop-bi-publisher-reports

YGUTTIKONDA

I do not see any XML tags when i run the report.. attaching the output

YGUTTIKONDA

ignore my previous comment regarding the Data Template.. i misread

pl upload the sample data to check it out

YGUTTIKONDA

Mahendra,

The xml file you attached is your Data Template.. for checking your template issue a sample data file is required.. you may have to run your concurrent program and provide the sample data file

YG

Brajesh Shukla-95078

Can you provide exact XML file and pdf output what you are getting in Apps instance?

User_36Q42

It is giving some OPP error "state File Handle". Working with my DBAs to fix that. Will update you how it goes.

+---------
1) POST-PROCESSING  ---------+

Beginning
post-processing of request 147114150 on node CMORA2 at 03-APR-2018 16:30:14.

--
Publishing output

Post-processing
of request 147114150 failed at 03-APR-2018 16:30:15 with the error message:

One
or more post-processing actions failed. Consult the OPP service log for
details.

CONC-POST-PROCESSING
RESULTS

--
PUBLISH:

• oracle.apps.fnd.cp.opp.PostProcessorException:
  oracle.apps.fnd.cp.opp.PostProcessorException: oracle.apps.xdo.XDOException:
  Stale file handle

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

YGUTTIKONDA

were you able to check the listed ?

Brajesh Shukla-95078

Looks like you have spme junk characters in your XML. Save the XML and open in Mozila it will point the junk character