Last updated on MARCH 08, 2017
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms