My Oracle Support Banner

ARCHIVE_Siebel Deletes Child Assets Via Transaction Process (Doc ID 2006586.1)

Last updated on JULY 21, 2020

Applies to:

Siebel Field Service - Version [21238] and later
Information in this document applies to any platform.


On : [21238] version, Field Service, Siebel SEA


Siebel deletes child assets via transaction process

There are some custom automation in the application.  There were missing Assets in Siebel and to troubleshoot a runtime event was added to send an email when an Asset is deleted. Audit trail also shows the delete action. Today a user was adding an Transaction record of type Install to a parent asset. When the user saved the record emails were sent out for five deleted assets.

Later the behavior can be reproduced  in vanilla. You can reproduce this in your environment by creating an Asset under the Account Business Object - Account Business Component and pick a product that has attributes when creating the Asset. Notice after doing this you will not see the Attributes at the Asset level. Use the Transaction view to Install any asset as a child to the newly created asset. Once this is done edit and save a change to the parent Asset. The child asset will be deleted.

You can reproduce in Sample database using certain product data in Sample database.


Five child assets are not deleted.


The issue can be reproduced at will with the following steps:

1. Log into Siebel Call Center using SADMIN/SADMIN connecting to Sample database. This is SEA using siebel.srf.
2. In Accounts > Assets, the product is updatable there. Both parent and child assets are there.
3. Create 2 new assets for the account, set Product = InMotion 130XL for both, one asset is meant to be as parent and one as child.
4. Go to Assets > Transactions, add the child asset to the parent.
5. Go back to Accounts > Assets, can see both assets there. Change parent's product to InMotion 170XL, the product is updated but the child asset is delted.
6. Go back to Assets > Transactions, the child asset is not here anymore.

screenshots saved in SampleDBRepro.pdf

When detail tracing is enabled, there are a lot of delete statements can be seen in client session log, siebel.log.


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.