EAM: ASSET_ATR_FS_VW Field Order Don't Match View Order
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.
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.
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