ZRG3076S: ORA-06502: PL/SQL: Numeric Error

(Doc ID 2083472.1)

Last updated on NOVEMBER 30, 2015

Applies to:

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


On acceptance: version, Usage

Testing M-3511

When attempting to run ZRG3076S,
the following error occurs.

ORA-06502: PL/SQL: numerieke fout of fout in waarde . ORA-06512: in "OZG_OWNER.ZRG3076S_CUST_PCK", regel 1380. ORA-06512: in "OZG_OWNER.ZRG3076S_PCK", regel 282.
ORA-06512: in "OZG_OWNER.ZRG3076S_PCK", regel 338
ORA-06512: in "OZG_OWNER.ZRG3076S_PCK", regel 715

The issue can be reproduced at will with the following steps:
1. ZRG3013F: Correct a claim line for which yearly deductible is applicable
2. ZRG3004F: Change claimed number to 0 and process claim
3. ZRG3012S: Finalize claim
4. ZRG3076S: Ru this batch for this insured member and see the error

The issue has the following business impact:
Due to this issue, users cannot use this batch.


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