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

MOSC Banner

Replace association of old Address with new to an Account without creating a new intersection record

edited Dec 16, 2016 12:26AM in Siebel Open UI, Tools, Scripting and EAI (MOSC) 6 commentsAnswered

Using an EAI Data Map and the EAI Siebel Adapter business service, I'm trying to:

  1. Create a new Address record (S_ADDR_PER)
  2. Associate this to an Account via an existing intersection record (S_CON_ADDR), replacing the ADD_PER_ID that's already there.

In essence, I want to simply update the S_CON_ADDR.ADDR_PER_ID of the existing intersection record, without creating a whole new S_CON_ADDR record. We store a lot of data on the intersection and the S_CON_ADDR.ROW_ID is referred to via many foreign keys. Our master data system dictates that we cannot simply update S_ADDR_PER to modify an address, forcing us to create a new one.

Tagged:

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