FND Lobs

Description

Categories
Enginatics
Repository
GitHub
Generic file manager lob data, such as attachments, help files, imported and exported Blitz Report files etc.

Template Summary by Program shows the space per program and whether the files have expired, which is what Purge Obsolete Generic File Manager Data removes.

SQL 22 lines

Parameters 8

ParameterTypeList of values SQL
File Name likeChar
lower(fl.file_name) like lower(:file_name)
File Content TypeLOV
fl.file_content_type=:file_content_type
Program NameLOV
fl.program_name=:program_name
File FormatLOV
fl.file_format=:file_format
LanguageLOV
fl.language in (select flv.language_code from fnd_languages_vl flv where flv.description=:language)
Include File DataLOV
xxen_util.blob_to_clob(fl.file_data) file_data,
Uploaded within x daysNumber
fl.upload_date>sysdate-:days
Non expiring onlyLOV
fl.expiration_date is null