My Oracle Support Banner

SQL SCRIPT errors cause sequence number issues during Migration From 11.2 To 11.3 for table dcs_cat_chldcat (Doc ID 2299575.1)

Last updated on DECEMBER 26, 2019

Applies to:

Oracle Commerce Platform - Version 11.3 and later
Information in this document applies to any platform.


If you are currently attempting to migrate from 11.2 to 11.3 and you are encountering a "logical" error in the migration scripts and are seeing sequence numbers getting migrated incorrectly, you may need to adjust some of the SQL scripts. Please review the contents of the following scripts to confirm that they are correct. Some changes may need to be made. I have indicated the changes needed below. The migration kit will be corrected in a future release to avoid this scenario in the future, but if you encounter sequence number issues during migration, this may be the issue.


Scripts in Question:

1. <ATG_HOME>/migration/11.2to11.3/DCS/Versioned/sql/db_components/oracle/versioned_product_catalog_ddl.sql

2. \OCPlatform113MigrationKit1.0\migration\11.2to11.3\Pre-Verification\DCS\Versioned\sql\db_components\oracle\versioned_product_catalog_ddl_verification.sql


SQL in Question:



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.