Install Base and Asset Tracking - EBS (MOSC)

MOSC Banner

External Reference Changes Tracked in Transaction History?

edited Sep 28, 2017 5:00AM in Install Base and Asset Tracking - EBS (MOSC) 1 commentAnswered

Are additions and changes of the External Reference field in Install Base tracked in the Transaction Histories of Instances?

I see that the field is available in the historical table, but I cannot see a record of the change.

How is it that the query "select external_reference from csi_item_instances where instance_id = 4241895;" produces a value, but the query "select old_external_reference, new_external_reference from csi_item_instances_H where instance_id = 4241895;" produces nothing but rows of 'null' values for the instance?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center