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 AUGUST 28, 2017

Applies to:

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


If the customer is currently attempting to migrate from 11.2 to 11.3 and they are encountering a "logical" error in the migration scripts and are seeing sequence numbers getting migrated incorrectly, they may need to adjust some of the SQL scripts. Please ask them for the following scripts and review the contents 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 the customer encounters 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:



Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms