Orders Not Processed After Upgrade: OWNER_ACCOUNT_ID in S_ORDER_ITEM Not Initialized (Doc ID 2243686.1)

Last updated on APRIL 03, 2017

Applies to:

Siebel CRM - Version 16.5 [IP2016] and later
Information in this document applies to any platform.

Symptoms

The migration from 8.1 to IP2016 introduced the new column OWNER_ACCOUNT_ID on the table S_ORDER_ITEM.

Before the migration, when an order was processed, the "order to asset" procedure copied the "Owner Account Id" field value of the line item business component (column joined S_ORDER.ACCNT_ID) into the field "Owner Account Id" of the asset bc column (S_ASSET.OWNER_ACCNT_ID).
Now, when an order is processed, the "order to asset" procedure copies the "Owner Accnt Id" new field value of the line item business component (column S_ORDER_ITEM.OWNER_ACCOUNT_ID) into the field "Owner Account Id" of the asset bc (column S_ASSET.OWNER_ACCNT_ID).
But the Siebel migration didn't initialize the new column S_ORDER_ITEM.OWNER_ACCOUNT_ID, so if an old order (created before the upgrade) is processed, the column S_ASSET.OWNER_ACCNT_ID will be empty, because the order line items have that column empty.
Why hasn't the new column been initialized by the upgrade process?

Changes

 The application was upgraded from 8.1.1.x to IP2016.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms