Monday, May 26, 2008

Enable Export Feature in Custom Forms

In Order to Enable Export option, available in Oracle Application forms to export the data into Excel file.
In the custom form at form level trigger write the below code in When-New-Form-Instance trigger.
APP_SPECIAL.ENABLE('FILE.EXPORT', PROPERTY_ON);

4 comments:

Sirius said...

Hi Sridevi,


I have created a custom form ( tabular, data block based on a table ), and when I open the form I can see the option File-Export enabled, but when I try to export the data It doesn't do anything, I put the instruction that you mention on WHEN-NEW-FORM-INSTANCE, WHEN-NEW-BLOCK-INSTANCE, PRE-FORM, but it's not working, any idea?

Thanks
Daniel P.

Unknown said...

Hi All,

We are trying to extract data via the Export option from the File menu. The form which we are trying to upload the data is custom form.
Not able to export the block data from oracle form for Read Only fields .

I tried with setting the profile option "FND_EXPORT_ALL_BLOCK_DATA " at user level , Even though all the data is not exporting.

Please help us , if there is any other profile or possible ways to resolve this issue.

Sirius said...

Hi Sayi,

there is a export trigger at form level, it should have this instruction inside

app_standard.event('EXPORT');

check if you have this on your custom form

Unknown said...

Thank you. app_standard.event('EXPORT') is present in my custom form, even though not working.

Initially, I mentioned in Blog as Read only form values. Sorry it is Enabled Property set as NO.

I want to export all items in custom form including those whose fields property set as enabled “No” in form level.