Siebel Order Management Guide Addendum for Financial Services > Setting Up Siebel Financial Services Customer Order Management for Banking > Modeling the Financial Product >

Using the Existing Contact and Financial Account Relationships with Siebel Financial Services Customer Order Management for Banking

In Siebel Finance, the relationship between a contact and a financial account is stored in the S_ASSET_CON intersection table. Siebel Financial Services Customer Order Management for Banking stores the contact and financial account relationship in the S_ASSET table. If you have existing data in the S_ASSET_CON table, then it must be migrated to the S_ASSET table in order for it to be usable in Siebel Financial Services Customer Order Management. At this time, Oracle does not provide a migration script.

It is strongly recommended that you use only the S_ASSET table. There are a number of vertical applications and customers that have added functionality that leverage the S_ASSET_CON table to represent contact relationships to an asset as well as drive business component logic that leverages this association to display the results to the user in a number of views throughout the application.

Because of this use of the S_ASSET_CON table in legacy configurations, Oracle provides a business service that you can use with runtime events, which can update the S_ASSET_CON table whenever assets in the S_ASSET table are modified. Figure 1 shows the S_ASSET_CON business service.

Figure 1. S_ASSET_CON Business Service

For more information about owner records, see Modeling the Financial Product.