Oracle UCM 11g Access From ADF 11g Table Row

There is quite obvious requirement, to show how many documents are uploaded and assigned for every employee. While we can open employee details and check available document, its more user friendly to show number of attached documents directly inside table row.

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.