Web Adi setting 2007

Export To Excel: How To Activate Debugging? (Doc ID 464469.1)

In this Document
  Goal
  Solution
  References

APPLIES TO:

Oracle Application Object Library - Version: 11.5.10.2 to 12.1.3 - Release: 11.5.10 to 12.1
Information in this document applies to any platform.

GOAL

How to get information about the things happening during 'Export To Excel'?

SOLUTION

1. Navigate into the Form that shows the data to export

2. In Form Menu choose: Help -> Diagnostics -> Examine
3. A pop-up window occurs. Enter the fields:

Set Block = GLOBAL
Set Field = FND_EXPORT_DEBUG
Set Value = TRUE

4. Close pop-up window.
5. Do the export again

When activated it shows information about the exporting process in a lot of pop-up windows.
These information help you to find out at which stage 'Export To Excel' fails.

Don't forget to disable debugging at the end.

Set Block = GLOBAL
Set Field = FND_EXPORT_DEBUG
Set Value = FALSE

REFERENCES

NOTE:135444.1 - Attachments and Exports, a Troubleshooting Guide
NOTE:136074.1 - How To Setup Action Export Functionality in Release 11i

Web ADI Troubleshooting

I am sure you have gone through the basic Web ADI Tutorial Oracle Web Adi : Explained step by step with diagrams and case study to have some basic understanding about Web ADI. We also have second part of the above tutorial Oracle Web Adi : Explained step by step with diagrams and case study Part – 2 But nevertheless if you are facing any issue related to Web ADI or don’t know how to setup your Microsoft Excel for Web Adi, you are at the right place. This will solve all your problems like Run-time error ‘1004’: Method‘VBProject’ of object ‘_Workbook’ failed etc. Just blindly follow the steps given below and 99.99% of your problems are be resolved.

Internet explorer settings

http://iavinash.com/wp-content/uploads/2015/05/Trusted-Sites.png

For the Web ADI to work properly you will also need to do some settingsat internet explorer. First thing first, check whether the oracle application (Prod/DEV url) is selected as trusted website or not. To check the same open internet explorer » Tools » Internet Options » Security Tab » Click on Trusted Sites » Click on Sites » Add your application URL

Now do some more setting related to your internet explorer as follow

1. Navigate to Tools –> Internet Options –> Security –> Internet –> Custom Level –> And do settings as follow

» Click on the images to enlarge them or download

2. Navigate to Tools –> Internet Options –> Security –> Local Intranet–> Custom Level –> And do settings as follow

» Click on the images to enlarge them or download

3. Navigate to Tools –> Internet Options –> Security –> Trusted Sites –> Custom Level –> And do settings as follow

» Click on the images to enlarge them or download

Microsoft Excel Related Setups

Once you are done with the internet explorer settings its time to move on Excel. Setting below will help to resolve many issues including the most common error “Run-time error 91″. To do these settings just open any blank excel, remembersettings are same for Excel 2007, 2010 and 2013, and click on File » Option » Trust Center » You will see an image like below (screenshots are from excel 2013)

http://iavinash.com/wp-content/uploads/2015/05/TrustCenter-Settings.png

Once you click on Trust Center Settings you will see many sections at your left hand side. Most commonly they will be as follow. Just click on these tabs one by one and do the changes accordingly.

· Trusted Publishers

You need not to change any thing over here. Just leave it as is.

· Trusted Locations

You may wish to add a location for your Web ADI. Just create a folder “WebADI” in your C drive and select the same as your trusted Locations