Export Data Getting Ora-01733 On View FND_LOBS -Db Vault Policies (Doc ID 800875.1)

Last updated on APRIL 17, 2025

Applies to:

Goal

1.When trying to export data from the form, looks like the data couldn't be written into a file.
SQL>SELECT FILE_DATA, ORACLE_CHARSET FROM FND_LOBS WHERE FILE_ID = :B1 FOR UPDATE OF FILE_DAT

Error encountered: ORA-01733
--------------------------------------------------------------------------------
select file_data, oracle_charset from fnd_lobs
where file_id= XXXXX for update of file_data

2.It seems like FND_LOBS in the failing sql is considered to be a view.

SQL> set serveroutput on;
declare
db_file number;
mime_type varchar2(255) :='text/plain' ;
out_string varchar2(32767) :='Just some plain text that is stored' ;
web_server_prefix varchar2(500);
url varchar2(500);
begin
db_file :=fnd_gfm.file_create(content_type =>mime_type,program_name=>
'export');
fnd_gfm.file_write_line(db_file,out_string);
db_file :=fnd_gfm.file_close(db_file);
url:=fnd_gfm.construct_download_url(fnd_web_config.gfm_agent,db_file,TRUE)
SQL>
dbms_output.put_line(url); 
end; 

declare
*
ERROR at line 1:
ORA-01733: virtual column not allowed here
ORA-06512: at "APPS.FND_GFM", line 743
ORA-06512: at "APPS.FND_GFM", line 767
ORA-06512: at line 10

3.SQL> select file_data, oracle_charset from fnd_lobs
where file_id= 5243092 for update of file_data ; 2
where file_id= 5243092 for update of file_data
*
ERROR at line 2:
ORA-01733: virtual column not allowed here

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.