Programming in MS Word

It is interesting to know that we can do some programming in Word. You can get more information in below link:
http://word.tips.net/T001045_Using_Last-page_Headers_and_Footers.html

I ave executed below example:

Hope it helps.

Error with BI Publisher: The macro cannot be found or has been disabled because of your macro security settings

I had issues with BI Publisher when using Word 2007 - specifically the following errors: "The macro cannot be found or has been disabled because of your macro security settings" and "Object library invalid or contains references to object definitions that could not be found"

Resolution:

The problem is cached EXD files.

1. Close Word,
2. Do a search on C drive *.EXD (include hidden files)
3. Rename them to .BAK
4. Go back into word and you should be able to Load Data

Hope this helps it worked for me

Dealing with Time Stamp in XML Files

If you are using Time Stamp in XML Files and XML file is being generated by Application Engine (AE), then you may probably get some issue with the time part of the timestamp. The output will show only 12 Hr insted of 24 Hr value. To nullify this issue, syntax like below.

Let us suppose the data in DB is: 01-jan-2011 14:20:23

DateTimeToLocalizedString(FIELD_TIMESTAMP,'hh:mm:ss'); will give output as : 02:20:23

DateTimeToLocalizedString(FIELD_TIMESTAMP,'HH:MM:SS'); will give output as : 14:20:23

Use upper case always to avoid surprises.

XML File Error

If you are getting any of the following errors:

"Warning! Report access is not set."

or

"Unsupported output format", Try the following.

When you run the report, give the output Type as Web. That should resolve the issue.

XML Error when '&' is encountered

If we have the following Characters in Data part of XML File, We will get the following errors: ‘whitespace is not allowed at this location’ or ‘a name was started with an invalid character’. To overcome this error, replace the character with the following strings.

Create XSD from XML file

In case you need the XSD file for bursting option within XML Publisher, you may like to use the below converter:

http://www.flame-ware.com/products/xml-2-xsd/default.aspx

Note: XML Publisher created using PS Query, we have build in option to create XML and XSD files. But if you are using Application engine to generate XML file you have to use the above given link.

Thanks to Murali for providing the above info.

Intro to XML/BI Publisher demo

For those who are not familiar with the XML/BI Publisher, you may find a simple demo that walks you through creating a simple XML Publisher report:

http://oukc.oracle.com/static09/opn/apps09/fusion/84690/020410_84690_DEMO.html