My Oracle Support Banner

Update Sequence Number For WIP_ENTITY_ID Field when upgrading from R12 to 12.2.x (Doc ID 2375080.1)

Last updated on MARCH 17, 2018

Applies to:

Oracle Enterprise Asset Management - Version 12.2.4 and later
Information in this document applies to any platform.

Goal

Updating  sequence WIP_ENTITIES_S  while upgrading from 12.0.6 to 12.2.x 

Test Case:

We are re-implementing Oracle E-Business suite on 12.2.4 version, our current version is 12.0.6.
There are involved several initial data loads on 12.2.4, one of them is on WIP_ENTITIES table.
 However, we have all history of this table 12.0.6 in another database for BI purpose.
 So, we are requiring before loading the WIP data on 12.2.4, altering the sequence WIP_ENTITIES_S 12.2.4 with the start value = the last value of history 12.0.6, then when we execute the initial data load on WIP_ENTITIES the WIP_ENTITY_ID column will have the next value.
 

Solution

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
Goal
Solution
References


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