My Oracle Support Banner

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 and later
Information in this document applies to any platform.


On : version, Technology

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

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.

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.

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


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

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