Member Avatar for haria_kishore

Hi guys

I am new to workflow but i have a task ahead of designing a workflow management for an organisation

We have Windows 2003 Server installed on one system which acts as Oracle application server

I want lots of details

1) How to go about creating a workflow from scratch(A sample demo would be of great help)

2) Aparts from Windows 2003 server, what other software or things are required to implement workflow

Please help me out on this

  • 3 Contributors
  • 2 Replies
  • 132 Views
  • 6 Years Discussion Span
  • Latest Post Latest Post by AdrianChestnut

Dani AI

Generated

A concise plan that complements the thread: has the common constraint of an Oracle stack on Windows Server, rightly flagged diagramming as useful, and correctly cautioned that workflow design is not trivial. Diagramming (BPMN or simple flowcharts) is a necessary first step but not a runtime. The design below turns process maps into an implementable, testable workflow system.

Core implementation choices and typical prerequisites:

  • Use Oracle Workflow (if the organisation runs Oracle E-Business Suite) for tight app-server/DB integration.
  • Use Windows Workflow Foundation (.NET) if the solution will run on Windows and integrate with Oracle via ODP.NET or web services.
  • Consider a dedicated BPM engine (commercial or open source: Camunda/jBPM/Activiti) for advanced human-task, monitoring and versioning features.
  • Minimum infrastructure: database, app/web server, SMTP for notifications, authentication (AD or LDAP), monitoring/logging, backup strategy.

Practical step-by-step approach:

  1. Model processes in BPMN or simple flowcharts and define roles, SLAs, and exception paths. Diagram tools help here (as @Bob_180_Bob suggested).
  2. Choose engine based on existing skillset, licensing, and integration needs.
  3. Build a small pilot (example: single “document approval” flow) that exercises integration points (DB, web services, email).
  4. Implement audit, retries, escalation rules, and idempotent integrations.
  5. Thorough functional and load testing, then phased rollout.

Troubleshooting and cautions:

  • Windows Server 2003 and old OracleAS versions are end-of-life; plan platform upgrades for security and future support.
  • Ensure transactional boundaries and error handling for asynchronous steps; use queues for long-running tasks.
  • Instrument workflows for tracing, SLA alerts and audits from day one.
  • For Oracle-specific details, consult the vendor documentation and an Oracle workflow specialist when using Oracle Workflow.

Recommended Answers

All 2 Replies

Member Avatar for Bob_180_Bob

Easy Workflow Software
Create Workflows Fast See Examples. Free Download!
www.SmartDraw.com

Member Avatar for AdrianChestnut

Well no one can deny the importance of workflow management in any working atmosphere. Making right kind of workflow is helpful to streamline the entire process as everyone will know the sequence of work and exact time to maintain the assignments. Although, there are many companies that offer software to organization, but as you are looking to design it personally, you have to understand that it is not an easy task to do. However, you can read the whole process to create workflow from scratch at that will be of help for you. Design of good workflow meets the entire requirement of any organization to improve task’s efficiency and meet the goals in a timely manner.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.