BI Publisher Desktop Problem after Upgrading Office 2007 to 2010

I've recently upgraded Microsoft office 2007 to 2010 & BI publisher stopped working by saying the below error.

"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".

I googled  for the solution, to fix this followed the below steps:

1.Open Regedit
HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Word\Security\Trusted Locations :

follow the video:-  (http://www.youtube.com/watch?v=mWN9_L8tt54)

HCM 9.1 :Bulk Insert into long fields (CLOB)

when you have enable the rich text editor for long fields you can format the text in different styles & font.

If it is bulk data,

Use SQL insert statments to load and append the html tags (related to formatting) for the long text.


It works!!

:-)

SQL Optimization

Use this hints to write efficient SQL's in AE

using Optimizer Hints :

http://download.oracle.com/docs/cd/B14117_01/server.101/b10752/hintsref.htm#4894

SQL Tuning:

http://download.oracle.com/docs/cd/B14117_01/server.101/b10752/sql_1016.htm#35171

Source:
Oracle