Reporting - EBS (MOSC)

MOSC Banner

how to locate LOBS file for each module?

hi there,

After running the SQL, I have found there are many files at these top 6 areas. Please advise how I can know they are related to which module because program tag is null or even which PO PR.

I aim to ask user to remove them to trim down the DB size. Thanks

SQL

select program_name, FILE_CONTENT_TYPE, substr(program_tag, 1, 10) as program_tag, count(1)
From fnd_lobs
where program_name not in ('FND_HELP')
and program_name = 'FNDATTCH'
group by program_name, FILE_CONTENT_TYPE, substr(program_tag, 1, 10)
order by 4 desc, 1, 3
;

PROGRAM_NAME

FILE_CONTENT_TYPE

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center