My Oracle Support Banner

Fee Schedule Load Error: GEN-ORA-01400: "ELEMENT_ID" column is mandatory for table PRI$FEE_SCHE_LINES_ERRORS_TMP (Doc ID 2545399.1)

Last updated on JUNE 02, 2019

Applies to:

Oracle Health Insurance Claims Adjudication - Version 3.18.3.0.0 and later
Information in this document applies to any platform.

Symptoms

On :  3.18.3.0.0 version, Integration Points


While uploading a fee schedule through the fee schedule IP, we get an error telling us that an ELEMENT_ID is mandatory. However, this error relates to the fact it cannot insert an error message into the error table, thereby hiding the real issue with the fee schedule. Furthermore, once this error occurs it seems that any subsequent operations on the same fee schedule through the fee schedule IP results in the same error with the ELEMENT_ID.

This error is occurring when trying to update a fee schedule through the fee schedule IP.

ERROR
-----------------------
GEN-ORA-01400: "ELEMENT_ID" column is mandatory for table PRI$FEE_SCHE_LINES_ERRORS_TMP


The issue can be reproduced at will with the following steps:
1. Upload attached payload fee schedule through the fee schedule IP

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.