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

MOSC Banner

Update Multi-Value Address attributes that differ by Account using web service call

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

Hello,

We're using Siebel 8.1.1.9 media application where addresses are stored in S_ADDR_PER. Also, address relationship to account is stored in S_CON_ADDR table. We've a need to store multiple practice area for address --> account relationship. For e.g. Address 140 PARK AVE is associated to account XYZ CORP and each address could have more than one practice area (immigration, divorce law, bankruptcy etc...) .

In a nutshell we have to create 1:M relationship for each S_CON_ADDR row. I'm using S_ORG_EXT_XM table to store this data. I've create multivalue link from CUT Address to Custom BC (which is created on top of S_ORG_EXT_XM) and its working fine from Siebel UI

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