Apache POI to load files to Oracle EBS

[Laurel]

Hi Erman!
How are you ? Hope all is OK.
Quick question: Have you used Apache POI to load exels to Oracle dbs.? Customzations I mean
Any "-"(minuses) or problems why we should not do it ?
Thx for advice,Laurel  

[ErmanArslansOracleBlog]

Hi Laurel,

no, I didn't.
However , Apache POI related documentation is even available on Oracle Support. So it seems, using it is logical in this case.
I would be appreciated if you share your experience about it. (after your implementation)

Also, if you encounter any problems on the way; you can ask them in here.. I will try to help..

[Laurel]

Hi Erman!
Thx :)
And another question - FND_LOBs  
Attaching files in EBS like excel files and then processing  in db.
I understand that we need expire those, so the standard purge pogram then will purge those + limit attachment size ( fnd profile option) that user can attach to db.

So, 2 ways we can implement the processing of excel files for EBS:
FND_LOBS
Apache POI

I starting to think that Apache POI is better way .. FND_LOBS - LOB segment maintenance, PGA usage probably be bigger..

Do you agree ? Thx!
Br,Laurel

[ErmanArslansOracleBlog]

PGA memory will be allocated to the LOBs when there will be an operation on them. It is also related with the management of these lobs.. IF the sessions can not free it properly, then you may be in throuble.
However, we also need to explore the tech. that Apache POI uses to do the same thing...