Tuesday, September 10, 2013

asset genealogy in Oracle's eBusiness Suite's Asset Management web interface

Following this, I should note that when one removes an asset from a parent asset, what one does is set an end date for a history record kept at a genealogy table. One of the confusing things about the screen for asset swapping is that one may see assets no longer associated with their parents at a parent's lists of assets. One just has to know that child assets shown which have end dates are in fact notes of history and not records empowering an active association. When a new child asset is associated with a parent, the child will get a history/genealogy record that will have a start date but not an end date. Also note that as genealogy records change that a column in the genealogy table does get the "last date of update" column revisited, but the comparable column in the asset table itself is not revised. If a parent is removed or added to an asset, the asset record itself will in no way reflect the change. The metadata in the genealogy table carries this information.

No comments:

Post a Comment