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 OCTOBER 30, 2017

Applies to:

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

Goal

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:

 

Solution

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