We are uploading new document for employee #200:
When document is uploaded, user can refresh employees table and see updated number of attachments for employee #200:
Sample application highlights record in green, if there are more than 0 documents attached.
We can upload more documents for employee #206, attachment status will be updated accordingly:
This allows to get information in advance and user can select only those records, he needs to select. For example, when Attachments indicated 0 documents, WebCenter 11g Document Management task flow is empty - without documents:
ADF 11g table contains column to indicate number of documents stored in Oracle UCM 11g per each employee #id:
If needed, employees table refresh is done manually, by calling Execute operation:
Employees VO contains one transient attribute - this attribute (UcmDocStatus) is referenced from ADF 11g table to show number of attached documents:
I have overridden prepareSession() method for AM, Oracle UCM 11g connection is established here and stored into session scope, to share it across requests:
Transient attribute getter method is overridden - getUcmDocStatus(), to retrieve number of documents per each employee #id:
On the side note, I recommend to use ADF logger, instead of external log4j library. You will avoid external library dependency by using built-in ADF logger class:
Download sample application - UCMNewFolderStatus.zip.