'Export' Function Has Stopped Working In All Modules (Doc ID 272526.1)

Last updated on AUGUST 26, 2015

Applies to:

Oracle Application Object Library - Version 11.5.10.0 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.
This problem can occur on any platform.
Checked for relevance on 23-JUL-2013

Symptoms

The export function appears to work as normal, gathering the table data and progresses through the red export-status bar, but then terminates with no output.

In order to debug the issue and see actual error message do the following steps:
a- Turn on export debug by going to (Help -> Diagnostics -> Examine) menu option.
b- Set Block = GLOBAL, Set Field = FND_EXPORT_DEBUG, Set Value = TRUE
c- Retest the issue and it will fail after the message:
   Export: Writing prompts for type WEB
   Export: Exception OTHERS

As well when you generate FRD log file, the following error will be shown there:
Unhandled Exception ORA-100501

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms