Error When Loading Feeschedule: ORA-06512, ORA-01400

(Doc ID 2349267.1)

Last updated on JANUARY 17, 2018

Applies to:

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

Symptoms

When attempting to load a feeschedule through SOAP IP, the following error occurs.

ERROR
-----------------------
GEN-PROC-ERR: Se produjo un error en el procesamiento de la solicitud; para obtener más información sobre el error busca en el registro de sucesos de "java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("OHI_CLAIMS_OWNER"."PRI$FEE_SCHE_LINES_ERRORS_TMP"."ELEMENT_ID")
ORA-06512: at "OHI_CLAIMS_OWNER.PRI_FSLI_PROCESS_PKG", line 634
ORA-06512: at line 1
"
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.load xml with soap
2. results in it erroring out

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