Thursday, 2 July 2020

How to enable microsoft excel template in oracle application R12

How to enable/add microsoft excel as a type to create template list of values in oracle application R12

Goto XML_PUBLISHER_RESPONSIBILITY > TEMPLATES > Trying Create Templates as "Microsoft Excel" But excel option is not showing.


To Enable Create template using "EXCEL"

1.Enable "XLS" options in XDO_TEMPLATE_TYPE lookup code:

Application Developer responsibility > Application > Lookups > Application Object Library > Query in Type "XDO_TEMPLATE_TYPE"

Check and enable checkbox in "XLS" and Enter "XDO_XLS_TEMPL_OUTPUTS" in Tag field and save.


2.Also Check the Enable option for EXCEL in "XDO_XLS_TEMPL_OUTPUTS" lookup codein Query Type.


Make sure Excel options is enabled.

3.Now goto XML_PUBLISHER_RESPONSIBILITY > TEMPLATES > Create Templates check "Microsoft Excel" is enabled.




No comments:

Post a Comment