FIN7002R Reports ORA-24381, ORA-01400, ORA-06512 Error Messages. (Doc ID 1932199.1)

Last updated on AUGUST 14, 2017

Applies to:

Oracle Health Insurance Disbursements and Collections - Version 10.14.1.2 and later
Information in this document applies to any platform.

Symptoms

On : 10.14.1.2 version, Technology

When attempting to execute the FIN7002R - Current Account Overview Script, the following error occurs.

ERROR
-----------------------
ORA-24381: Error in array-DML
ORA-01400: Cannot insert null into ("OZG_OWNER"." ALG#SAV_VERWERKINGSEENHEDEN"."RECORD_ID).
ORA-06512: in "OZG_OWNER.ALG_BATCH_PCK", regel 1062.
ORA-06512: in "OZG_OWNER.FIN7002R_CUST_PCK", regel 652.
ORA-06512: in "OZG_OWNER.FIN7002R_PCK", regel 596.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to the SYSS003F - Submit Batch Request screen.
2. Fill in the Batch: FIN7002R along with the parameters.
3. Submit Batch.
4. Navigate to the SYS1001F - Maintain Batch Request screen.
5. Review the FIN7002R script results.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Unable to use the report to notify the broker in the question of balancing.

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