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 FEBRUARY 11, 2020
Applies to:Oracle Health Insurance Claims Adjudication - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
On : 18.104.22.168.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.
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
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