Orders Not Processed After Upgrade: OWNER_ACCOUNT_ID in S_ORDER_ITEM Not Initialized
Last updated on APRIL 03, 2017
Applies to:Siebel CRM - Version 16.5 [IP2016] and later
Information in this document applies to any platform.
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?
The application was upgraded from 8.1.1.x to IP2016.
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