EAM: ASSET_ATR_FS_VW Field Order Don't Match View Order

(Doc ID 2393895.1)

Last updated on MAY 02, 2018

Applies to:

PeopleSoft Enterprise FIN Asset Management - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

ASSET_ATR_FS_VW field order don't match view order

 

The ASSET_ATR_FS_VW record lists the field order as  BUSINESS_UNIT, ASSET_ID, EFFDT, ASSET_COLOR, ASSET_WEIGHT, WEIGHT_UM, ASSET_HEIGHT, HEIGHT_UM, ASSET_WIDTH, WIDTH_UM, ASSET_LENGTH, LENGTH_UM...

In the underlying view, the columns read are in the following order: 
BUSINESS_UNIT, ASSET_ID, EFFDT, ASSET_COLOR, ASSET_HEIGHT, HEIGHT_UM, ASSET_WIDTH, WIDTH_UM, ASSET_LENGTH, LENGTH_UM, ASSET_WEIGHT, WEIGHT_UM...  (Note that the WEIGHT columns moved from positions 5/6 to 11/12) 

This causes problems when the ASSET_ATR_FS_VW is used to help populate other tables, like INTFC_PHY_B, which results in those values rotating around.

Cause

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