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

Excel Template in XML Publisher

Question
21
Views
0
Comments
Richa Choudhary-95143
Richa Choudhary-95143 Rank 1 - Community Starter
in Oracle Analytics Cloud and Server

Summary

Excel Template in XML Publisher

Content

I am using patch/integrated version of XML Publisher i.e. not an Enterprise/Standalone edition.

Designed an Excel Template.

Its working fine when i preview it after loading the data in template for testing purpose.

However, when i attach the same template in Templates tab of Oracle apps and export the excel output, i have observed one strange behavior.

Say, i have written XDO_?<field_name>? rule on 10th row of excel template. First 9 row contains header details.

A10 has XDO_?ASSET_NUMBER?

B10 has XDO_?DESCRIPTION?

And group function XDO_?<group_name>? on 10th row record.

After i run and do the data export and try to write the vlookup on 10th record of excel file which is the starting position of records, i find this issue.

Instead of showing =vlookup(A10,.....)

It shows =vlookup(XDO_?ASSET_NUMBER?,....)

Can anybody help me out is this a known issue or a bug or is there a way to rectify it.

Thanks.