Install Base and Asset Tracking - EBS (MOSC)

MOSC Banner

How to set the Enable Auto Update flag (FA_SYNC_FLAG) to Yes after loading the interface tables and

edited Apr 1, 2012 3:02PM in Install Base and Asset Tracking - EBS (MOSC) 2 commentsAnswered
Hi Experts,
We need your help. We are testing the initial loading of trackable assets which are currently in the field.

To this end, we load the 4 interface tables with the assets' information:

  1. CSI_INSTANCE_INTERFACE
  2. CSI_I_ASSET_INTERFACE
  3. CSI_INTERFACE_SOURCES
  4. CSI_I_PARTY_INTERFACE
We have tested loading these tables with the required information, executing the Install Base Open Interface concurrent and the outcomes are:

  1. For assets located in HZ_LOCATIONS (LOCATION_TYPE_CODE=HZ_LOCATIONS), the Enable Auto Update flag gets set correctly with value Y when locations match (both instance and asset)
  2. For assets located in HZ_PARTY_SITES or INTERNAL_SITES (LOCATION_TYPE_CODE=INTERNAL_SITE or HZ_PARTY_SITES), the flag does not get checked with value Y, even though the locations are correctly mapped.

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