Oracle Openworld Directory Index

Special Thanks
Dave Stoney
Oracle France
Technip
Joyce Peng
Vijayanth Devadhar
Agenda
Why the requirement
How did we do it
Structure of the IFS Document Class
Status
How will IFS communicate with Workflow
Start and Stop the workflow
How will Workflow communicate with IFS
Process Calls
Update IFS Workflow Status
How will Workflow send Notifications for IFS Documents
Why
Internet File System is a great tool for storing documents into a database structure
Allows multiple ways to manage and maintain documents
Explorer, Browser, FTP
IFS can be used as a document management system
Check In, Check Out, Versioning
However, there is no Document Lifecycle
Draft, review, completed, processing, approval, rejected
Solution
Get Workflow and IFS to talk to each other
IFS to Workflow
Start workflow
Stop Workflow
Workflow to IFS
Issue IFS commands like lock document, check out
Update Document Status
From Draft to Approved
Problem
Workflow and IFS does not work together
IFS uses a Java API
Workflow uses a PL/SQL API
Only true in WF 2.5
WF 2.6 introduced a WF Java API
How many PL/SQL programmers know Java?
Solution
From the User’s Point of View
Upload a Document
Upload Document
Maintain The Document
Submit the Document
Submit A Document
Start the Workflow
The WF Process
The WF Process
Notification
During the Process
Final Result
Solution
From The Programmer’s Point
The Design
The Design
WF Document Class
Value Default
Name:
WFDefaultStatus
Datatype:
String
Value:
Draft
Subclass
Name: WFDocument
Superclass: Document
Add Attribute
Name: WFStatus
Datatype: String
Length: 25
Is Settable: Yes
Read Only: Yes
Value Default:
WFDefaultStatus
WF Doc Agent
Purpose
To reassign all uploaded documents to the new WF Document sub-class
Design
Use the Event Based IFS Agent Template
Capture “Create Instance” IFS Event
WF Doc Agent Code
public void processEvent(IfsEvent event) throws IfsException
{
LibrarySession session = getSession();
try {
Long id = event.getId();
PublicObject po = session.getPublicObject(id);
log("Event type: " + event.getEventType());
log("Object: " + po.getClassname());
if (event.getEventType() == IfsEvent.EVENTTYPE_CREATEINSTANCE) {
if (po != null) {
if (po instanceof Document) newInstanceOfDocumentEvent((Document)po);
}
}
}
public void newInstanceOfDocumentEvent(Document document) {
try {
log("");
if(document.getClassname().equalsIgnoreCase("DOCUMENT")){
//create a temp document using new class name
String tempName = document.getName().concat("_temp");
Document tempDoc = copyDocumentShareContent(document,tempName);
//Add it to same folder
String directoryPath = document.getAnyFolderPath().substring(0,(document.getAnyFolderPath().indexOf(document.getLabel())-1));
LibrarySession session = getSession();
FolderPathResolver folderpathresolver =
new FolderPathResolver(session);
PublicObject publicobject =
folderpathresolver.findPublicObjectByPath(directoryPath);
Folder newFolder = null;
if ( publicobject instanceof Folder)
newFolder = (Folder) publicobject;
newFolder.addItem(tempDoc);

//remove old document
String docName = document.getName();
removeItemFromFolder(document,newFolder);

//rename temp doc to old document
tempDoc.setName(docName);

Submit to Workflow
Modified showdocprops.jsp
// Change 016 KJB WF Process
else if (attributes[i].getLabel().equalsIgnoreCase("WFSTATUS")) {
<%=attVal%>


<%if (attVal.equalsIgnoreCase("DRAFT")) %>
onClick="submitWF();">
<%else if (! attVal.equalsIgnoreCase("APPROVED"))%>

<%
}
Submit Workflow
When the Submit Button is pressed, it will call submitWF.jsp

function submitWF() {
document.docPropertiesForm.wfbutton.value="Working...";
location="startWF.jsp?actn=start" +
"&id=" + document.docPropertiesForm.wfDocId.value +
"&path=" + document.docPropertiesForm.wfPath.value;
}
Submit WF JSP
<%@ page contentType = "text/html; charset=UTF-8" %>
<%@ page import = "java.sql.*;" %>
 

Calling Workflow...

=================================================

=================================================