How to Read Files Ordered by Timestamp with FTP and FILE Adapter ?

Here is metalink note for this.
Subject:
How to Read Files Ordered by Timestamp with FTP and FILE Adapter ?

Doc ID:
779136.1
Type:
HOWTO

Modified Date :
02-MAR-2009
Status:
PUBLISHED
In this Document Goal Solution References
Applies to:
Oracle SOA Platform - Version: 10.1.3.3.1 to 10.1.3.4Oracle(R) BPEL Process Manager - Version: 10.1.3.3.1 to 10.1.3.4Oracle(R) BPEL Process Manager - Version: 10.1.3.3.1 to 10.1.3.4Oracle ESB - Version: 10.1.3.3.1 to 10.1.3.4Information in this document applies to any platform.
Goal
This document explains how to configure the FTP or FILE adapter in the following scenario :
1. you have several files in the Inbound directory waiting for pooling2. you want to process the files ordered by timestamp ascending or descending
Solution
There is no setting out-of-the box to do this ordering with FTP or FILE adapter. This feature was introduced from 10.1.3.3.1 MLR#14 (Patch 7253921) and 10.1.3.4 MLR#1 (Patch 7375086)
To implement it please perform following steps :
1. Model the BPEL process as a synchronous one
2. In the Inbound activation specification (the WSDL file for inbound FTP/FILE adapter) add the the following:
Sorter="oracle.tip.adapter.file.inbound.listing.TimestampSorterDescending"
OR
Sorter="oracle.tip.adapter.file.inbound.listing.TimestampSorterAscending"
This line will provide Descending or Ascending sorting of filenames.
3. If you use FTP Adapter you also need to add in Inbound activation :
useNlst="true"
This parameter tells the adapter to use LIST command to get filenames as opposed to NLST. The advantage with the LIST command is that the adapter can capture the tiemstamp, size information during the inbound listing. Below is a sample setting for FTP Adapter Inbound :

4. Edit file SOA_HOME\bpel\system\services\config\pc.properties and change
oracle.tip.adapter.file.numProcessorThreads=1
If you use ESB you need to edit file SOA_HOME\integration\esb\config\pc.properties (rename pc.properties.esb to pc.properties if you don't have this file)
References
Keywords
TIMESTAMP ; INBOUND

Oracle Alternative to TOAD

Oracle Alternative to TOAD

Just wanted to share with you all an Oracle tool, which is very fast and efficient particularly for Oracle Database.

Oracle SQL Developer
Oracle SQL Developer is a free and fully supported graphical tool for database development. With SQL Developer, you can browse database objects, run SQL statements and SQL scripts, and edit and debug PL/SQL statements. You can also run any number of provided reports, as well as create and save your own. SQL Developer enhances productivity and simplifies your database development tasks.

http://www.oracle.com/technology/products/database/sql_developer/index.html

It have additional plug-in for Data Modeling as well

Oracle SQL Developer Data Modeling - Early Adopter Release 2
Oracle SQL Developer Data Modeling is the latest product offering to join the Oracle Database Tools. SQL Developer Data Modeling offers a full spectrum of data and database modeling tools and utilities, including Entity Relationship modeling, Relational (Database Design), Data Type and Multidimensional modeling, full forward and reverse engineering and code generation. It includes importing from and exporting to a variety of sources and targets, provides a variety of formatting options and validates the models through a predefined set of Design Rules.
SQL Developer Data Modeling can connect to any Oracle Database version 9.2.0.1 and later, and is platform independent. Initially available as a standalone product, with future releases available as an extension to Oracle SQL Developer. The second Early Adopter release is stand alone and file-based only.
http://www.oracle.com/technology/products/database/sql_developer/files/Modeling.html

Fusion Integration with Portal 10g

Fusion Integration with Portal 10g
BPEL Process Manager Integration

Oracle Application Server 10g R2 includes a portlet provider as part of Oracle BPEL Process Manager. This provider primarily exposes the Oracle BPEL Worklist Application in the form of Task Listing and Task Analysis portlets that may be seamlessly deployed onto an Oracle Portal page to enable users to participate in a BPEL process by performing tasks that require manual intervention.

Fusion Conceptual Architecture

The following diagram provides high-level view of Fusion Conceptual Architecture