Tuesday, December 24, 2013

How to add Microsoft Excel as Type to the Create Template List of Values in BI Publisher

1. Enable option 'XLS' in XDO_TEMPLATE_TYPE lookup code :

(Responsibility) Application Developer > Application > Lookups > Application Object Library > Query out Type 'XDO_TEMPLATE_TYPE'

Check 'Enable' checkbox of record 'XLS', and enter '
XDO_TEMPLATE_TYPE' in 'Tag' field of this record, Save.

2. Enable option 'EXCEL' in XDO_XLS_TEMPL_OUTPUTS lookup code :

(Responsibility) Application Developer > Application > Lookups > Application Object Library > Query out Type 'XDO_XLS_TEMPL_OUTPUTS'

Make sure option 'EXCEL' is enabled.

3. Go to responsibility 'XML Pulisher Administrator' > Templates > Create Template, make sure there is an option 'Microsoft Excel' in 'Type' list of value.


Sasank Kiran said...

Hi Raju, this is Sasank.
Thanks for this post. Can you change the tag name to be entered as XDO_XLS_TEMPL_OUTPUTS? Its been given as XDO_TEMPLATE_TYPE.
Pls check and update accordingly.

Also, I'm getting the following error while trying to save the record:

APP-FND-01023: The following required field does not have a value: Context Value

I have found Context value in DFF against the EXCEL record which is mandatory. But, other formats are working even they have this Context value as mandatory.
Can you suggest how to resolve this issue?
Thanks in advance,

Raju Ch said...

Hi Shashank

Please apply the below patch

For 12.0.x
Excel Templates are only partially supported on the Oracle E-Business Suite Release 12.0.x. There are no current plans to backport this feature to the Oracle E-Business Suite Release 11i, nor will it be fully supported in 12.1.x.

Oracle E-Business Suite Release 12.0:

Patch 7237006 R12.ATG_PF.A.DELTA.6

This patch includes some basic functionality for Excel templates. You can run a very basic spreadsheet.
For the full functionality associated with Excel layouts you have to license and install BI Publisher Enterprise, or later version.
We are not logging new defects for enhancements to this functionality in EBS at this time.
Refer to the Oracle Fusion Middleware Report Designer's Guide for Oracle Business Intelligence Publisher, chapter Creating Excel Templates.

For 12.1.3
Please apply Patch:12415414 - 1OFF:11873050:12.1.3:12.1.3:FRM-41830, FRM-40212 Submitting Program - Publisher FSG.

This patch updates the looktype ("XDO_XLS_TEMPL_OUTPUTS") and lookup code (Excel) to support the Excel templates for BI Publisher R12.1 release.

Post a Comment

Best Blogger TipsGet Flower Effect