EAM: ASSET_ATR_FS_VW Field Order Don't Match View Order
(Doc ID 2393895.1)
Last updated on NOVEMBER 23, 2019
Applies to:
PeopleSoft Enterprise FIN Asset Management - Version 9.2 and laterInformation 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.
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |