For different kind of processes, in various screens users attach files to the Oracle EBS (Purchasing orders screen etc). And Oracle EBS keeps these attachments as binary files in database, because keeping them in their original format requires keeping them in file server and this means these files should exist in every file server and causes massive file storage (Probably there are much more reasons and debates about the subject).
These attachments and concurrent outputs are kept in "fnd_lobs" table, furthermore they are accessible via database. Attached documents can be in various formats like text, image etc. and any of these can be downloaded from the database.
This information was exciting for me though i think this feature also creates a security risk.
No comments:
Post a Comment