Oracle Analytics Cloud and Server

BI publisher report is printing XML tags in the output instead of actual output.
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
Answers
-
Thank you for the reply. Please find attached sample data file.
-
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. ....
-
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
......
.......
-
Please find attached concurrent program screen shot. sample data file attached in my earlier update is the output of the report.
Thank you ,
Mahendra
-
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 ..
-
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
-
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.
-
-
I do not see any XML tags when i run the report.. attaching the output
-
ignore my previous comment regarding the Data Template.. i misread
pl upload the sample data to check it out
-
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
-
Can you provide exact XML file and pdf output what you are getting in Apps instance?
-
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 outputPost-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
+---------------------------------------+
- oracle.apps.fnd.cp.opp.PostProcessorException:
-
were you able to check the listed ?
-
Looks like you have spme junk characters in your XML. Save the XML and open in Mozila it will point the junk character