1 person found this helpful
The functinoality of searching, reporting and downloading files is all fine and super easy in APEX.
The actual search of your data is a bit more complicated depending on what the 'Documents' are. Oracle text allows you to search the text in PDF documents but if they need an OCR to be searched then I have no experience with this.
If you are searching on an employee name and ID that is in the database and linked to the documents, then this is again, really, really easy with APEX.
Thanks for the reply. That was my thinking as well. We won't need to search the text of the documents, but only search for the document itself based on a couple of criteria, like employee ID and document type.