Missing Parameters In EAM_LAM_ENTITIES_PUB Api To Create EAM Linear Assets
(Doc ID 2212661.1)
Last updated on FEBRUARY 19, 2019
Applies to:Oracle Enterprise Asset Management - Version 12.2.5 and later
Information in this document applies to any platform.
Trying the api EAM_LAM_ENTITIES_PUB to create the LAM entry in Oracle for a sample record, to insert in tables EAM_LAM_ENTITIES and EAM_LAM_LR_DETAILS using the call INSERT_LAM_ENTITIES and INSERT_LAM_LR_DETAILS in the package EAM_LAM_ENTITIES_PUB.
It was noticed that there are few columns in the table EAM_LAM_ENTITIES and EAM_LAM_LR_DETAILS that is not covered by the api EAM_LAM_ENTITIES_PUB.
For the table, EAM_LAM_ENTITIES, it is needed to insert values for the column SPATIAL_ROUTE_ID and SEGMENT_CODE. These two columns are not available in the api EAM_LAM_ENTITIES_PUB for create or update.
For the table, EAM_LAM_LR_DETAILS, there many missing columns in the package. They are SCH_FROM_MEASURE, SCH_TO_MEASURE,INTERNAL_ATT1 to INTERNAL_ATT5, SEG_ENTITY_ID, ROUTE_LAYER_ID.
It is needed the ROUTE_LAYER_ID column to be populated as it is critical for business requirement. These columns are not available in the api EAM_LAM_ENTITIES_PUB for create or update.
Include these new columns in the package EAM_LAM_ENTITIES_PUB.
The issue can be reproduced at will with the following steps:
1. This is provided using the EAM_LAM_ENTITIES_PUB API.
2. Find missing columns: SCH_FROM_MEASURE, SCH_TO_MEASURE,INTERNAL_ATT1 to INTERNAL_ATT5, SEG_ENTITY_ID, ROUTE_LAYER_ID.
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