SQL SCRIPT errors cause sequence number issues during Migration From 11.2 To 11.3 for table dcs_cat_chldcat
Last updated on OCTOBER 30, 2017
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:
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