If I understand correctly...you want Excel Output with multiple worksheet...in this case you can define your name manager accordingly in multiple sheet...data will populate in all the worksheet as per your name mapping provided.

Hi, 1. Create in single excel template. 2. Generate your XML in such a way that should group your data based on org e.g. <SAMPLEXML> <G_ORG> <Org_Name>AAA</Org_Name> <G_DETAIL> <detail1></detail1> <detail2></detail2> </G_DETAIL> <G_ORG> <G_ORG> <Org_Name>BBB</Org_Name> <G_DETAIL> <detail1></detail1> <detail2></detail2>…

Patch mentioned in the earlier document is required to see excel template type in R12.1.3

As per you explanation looks like problem is with date format can you print DISTINCT of b.start_timestamp , to_date(:para_start_date) in SELECT Statement with a.member_target_type ='host' and once a.member_target_type !='host' and see if there is any record for which format is different that can cause the issue. This issue…

https://docs.oracle.com/cd/E23943_01/bi.1111/e22258/add_event_trig.htm#BIPDM330 Above link explain very much about event triggers in BI...please go through it and let us know if you face any issue

Both the log file attached is pointing to two different error 1. First Log : (Calling XDO Data Engine... java.lang.NullPointerException at oracle.apps.xdo.dataengine.XMLPGEN.processSQLDataSource(XMLPGEN.java:480) a) In this issue XML data is not generated, please check the Code (e.g. Data Template code, Report Code or…

You can verify these three things 1. There is no template define for that XML in XML Administrator, you can verify this by checking the Option of the concurrent request, it will show the template name if it picked. If its blank it means template is not getting picked up. 2. Output Post Processor is Down : Output post…

Hi Rick, Strange behavior of BIP I have used same condition and tag as current-grouping-key() and giving me below output, which I believe is correct as per expected output you shared. Behavior of BIP should not different in the same version of the instance. This makes me to think that correct template is getting picked up?…

Hi Rick, Could you try instr() function instead of contains(). Please keep field tag as it is and put the below content Replace <?if: contains(current-grouping-key(),'/')?> with <xsl:if test="xdoxslt:instr(current-grouping-key(),string('/'),number(1),number(1)) != 0"> Replace <?end if?> with </xsl:if>

Looks like this is the problem while generating the XML file...please check the code which generates the XML file...

Can you put if condition as below and try. I just tried it worked for me for the rtf and data you have provided <?if:contains(CategoryName,'/')?>

Hi Rick...I used template viewer . My version is BI Desktop version is 10G which is supported by EBS. First I tried to preview the exact rtf which you have uploaded....it gave for the category i.e. category name which contains dot(.) and category name which contains forward slash ( / ). This behavior as same as EBS ? Then…

Just now I tried in my EBS env. 12.1.3. it worked

Nope....I am getting below output...There are two category name under same tag...one contains value with dot and second contains value with /. If you put condition <?if:contains(current-grouping-key(),'/')?> do you want to check both the tags? It will be easy if you can paste your expected output?

May I know what you are printing in CategoryName tag. For me its showing some reference not showing exact tag name

How you are generating your XML?

I think your requirement is to group the data based on G_PROD_HDR and PROD_NUMBER, you can create dynamic group in rtf for PROD_NUMBER as below to achieve your requirement.

If I understand correctly.... 1. Output of each new Product Number (e.g. Product Number: P5900) should start with new page? 2. Any one Prod Main Seq.(Prod Main Seq. 30) should not split into two pages in this case it should ideally come to one page?

Hi, Please add two change on your approach as mentioned in below snap 1. User <?for-each-group@section:G_PROD_HDR;PROD_NUMBER?> instead of <?for-each-group:G_PROD_HDR;PROD_NUMBER?> this will make sure that each new PROD_NUMBER should start with new page 2. Add Table in Word with one row and one column and put the Prod Main…

Yes...any excel sheet behaves like a excel template...only thing is give extension of excel as .xls(instead of 2016 excel extension .xlsx)