Missing Parameters In EAM_LAM_ENTITIES_PUB Api To Create EAM Linear Assets (Doc ID 2212661.1)

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.

Symptoms

ACTUAL BEHAVIOR

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.


EXPECTED BEHAVIOR

Include these new columns in the package EAM_LAM_ENTITIES_PUB.


STEPS

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.

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