exporting to excel from an oracle form
When I do file/export in a form to save the data, there is no prompt which comes up for the file name and location. Where is it saving to or is a profile for my userid not setup the way it needs to be?
from which instance...is it
from which instance...is it in your organization or some public test instance like solution becon.. There is no profile for this.Infact there is no easy way to disable this functionality in oracle. Now about your issue First check in your internet explorer if Prompt for File Downloads and File Download are enabled or not. if yes then run the below query SQL> select index_name, index_type, domidx_status, domidx_opstatus from dba_indexes where table_name='FND_LOBS' if you get DOMIDX as FAILED then follow the below steps 1. Run $FND_TOP/patch/115/sql/afupdlob.sql to drop the index. 2. Then run $FND_TOP/sql/aflobbld.sql to build the FND_LOBS table. 3. Retest for File > Export