Is it possible to create and check in a document in a RMB in IEE

To add to what Amila linked to, and your last requirement: it's probably quite hard to "fill in" a document from PL/SQL. Plain text-based file formats would work, like text files, HTML files and XML-based files. Office documents are harder. Nowadays they are XML-based files, but they are zipped, which adds to the complexity. If you can find a way to decompress a template Word file, let's say, and keep that someplace, then update the right places in the XML, then compress it again, it might be possible. I think that's probably hard to do in PL/SQL in Oracle. You could use Java in Oracle to do it, for sure, but that might break some license agreement (IFS sell Oracle licenses under certain restrictions, and this could be one of them, but I'm just guessing now.)