Siebel Database Upgrade Guide > Preparing Siebel Application Data for Upgrade >

Setting the Value of Siebel S_SRC_PAYMENT.TYPE_CD for Upgrade

Upgrades from: Siebel 7.0.x.

All environments. This topic applies to all Siebel environments.

Databases: All databases.

Platforms: Windows, UNIX, IBM z/OS.

At Siebel 7.5, S_SRC_PAYMENT.TYPE_CD became a required (NOT NULL) column. If TYPE_CD is null, the value is set to Payment during the upgrade.

Payment indicates that this is a payment from your organization to an external organization. For example, this might denote a payment of marketing funds to your customer.

Before the upgrade, review records where TYPE_CD is null. For those where you do not want the upgrade to set the value of TYPE_CD to Payment, set the value of TYPE_CD.

To set the value of TYPE_CD

  1. In S_SRC_PAYMENT, query for records where TYPE_CD is null.
  2. For the desired records, use Siebel EIM to set a value for TYPE_CD.

    Use the values in the field's LOV.

Siebel Database Upgrade Guide Copyright © 2008, Oracle. All rights reserved.