SC_ARXAG_INV_SAMPLE.xml

3060918

3060918

Version
ARU-dbdrv
Extractor Version
Template Code
Template Type	TYPE_EXCEL_TEMPLATE
Preprocess XSLT File
Last Modified Date
Last Modified By
Data Constraints:
XDO_SKIPROW_?C_AMT_DUE_REMAINING_INV?	<xsl:for-each select="G_LAST[C_AMT_DUE_REMAINING_INV!=0]">

GeorgeConstantin-Oracle

Version
ARU-dbdrv
Extractor Version
Template Code
Template Type	TYPE_EXCEL_TEMPLATE
Preprocess XSLT File
Last Modified Date
Last Modified By
Data Constraints:
XDO_SKIPROW_?C_AMT_DUE_REMAINING_INV?	<xsl:for-each select="G_LAST[C_AMT_DUE_REMAINING_INV!=0]">

The right correct syntax is

<xsl:for-each select="G_LAST[C_AMT_DUE_REMAINING_INV != 0]"/>

For other examples of conditional code see:

http://docs.oracle.com/cd/E28280_01/bi.1111/e22254/create_excel_tmpl.htm#ext_skiprow

Please correct this tag and try again.

Regards,

George

3060918

The right correct syntax is

<xsl:for-each select="G_LAST[C_AMT_DUE_REMAINING_INV != 0]"/>

For other examples of conditional code see:

http://docs.oracle.com/cd/E28280_01/bi.1111/e22254/create_excel_tmpl.htm#ext_skiprow

Please correct this tag and try again.

Regards,

George

Hi George,

I tried with your syntax , still my output is not filter output base on condition. I also checked link which you provided. but it's skipping row base on element attribute instead of value.

Please advise.

Kevin M-Oracle

What application and version are you running the layout from?

Kevin

3060918

What application and version are you running the layout from?

Kevin

Hi Kevin,

I am using this template in Oracle Application version R 12.1.3.

Kevin M-Oracle

Hi Kevin,

I am using this template in Oracle Application version R 12.1.3.

We do not support Excel templates in EBS 12.1.3, we do not have all the libraries required to support these layouts until EBS version 12.2

Kevin

3060918

We do not support Excel templates in EBS 12.1.3, we do not have all the libraries required to support these layouts until EBS version 12.2

Kevin

Hi Kevin,

I am able to generate output in Excel format using excel template but only i am not about to skip row based on filter criteria in EBS 12.1.3.

Kindly advise.

Kevin M-Oracle

Hi Kevin,

I am able to generate output in Excel format using excel template but only i am not about to skip row based on filter criteria in EBS 12.1.3.

Kindly advise.

We do not support this template type in 12.1.3 because the libraries to support it are incomplete.

You need 12.2 for full functionality.

Kevin