Siebel Open UI, Tools, Scripting and EAI (MOSC)

MOSC Banner

How to convert the user_key for S_PARTY, S_CONTACT, S_ORG_EXT on Siebel 7.0.5

edited Dec 16, 2016 12:28AM in Siebel Open UI, Tools, Scripting and EAI (MOSC) 2 commentsAnswered
 Hi Sir,

         Currently we import the customer data from the legacy system to Siebel 7.0.5 using customer number(CIS, 14 digits) as a user key of S_PARTY, S_CONTACT, S_ORG_EXT. Now we plan to change the legacy system to the new platform. We will convert the customer number(CIS, 14 digits) to new customer number(CIF, 19 digits) on new legacy system.

           (1) Please help advice for the best practise to convert customer number(CIS, 14 digits) to new customer number(CIF, 19 digits) on Siebel.

My propose convert steps are :

1.1  Add new Contact/Company with the user key=CIF(19 digits) only the parent table S_PARTY, S_CONTACT, S_ORG_EXT. (Note. the number of records will duplicated.)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center