When creating a Microsoft SQL Server database for use as a repository, ensure that you set these options:
Set READ_COMMITTED_SNAPSHOT = ON
Set ALLOW_SNAPSHOT_ISOLATION = ON
Select the SQL Server and Windows authentication option when you set the security properties for the database.
All products support Latin Collation for the SQL Server database. Use this statement: SQL_Latin1_General_CP1_CI_AS, However, if you are using Oracle SOA Suite (required as part of a Financial Close Management deployment), then Oracle recommends that the Financial Close Management database be kept separate and set it to SQL_Latin1_General_CP1_CS_AS.