My Oracle Support Banner

Calculation Process Errors With ORA-04061, ORA-04065, ORA-06512, ORA-06502 (Doc ID 578910.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Incentive Compensation - Version 11.5.10.2 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.

Purpose

Calculation sometimes runs and errors with the error messages mentioned below. Re-running calculation resolves the error. The packages that show up as invalid in the process log actually are valid when checked at the database level.

Errors commonly seen are:

Exception in calculate_quota dispatcher ORA-04061: existing state of has been invalidated

ORA-04061: existing state of package "APPS.CN_FORMULA_10206_143_PKG" has been invalidated

ORA-04065: not executed, altered or dropped package "APPS.

raise

EXCEPTION in cn_commission_lines_pkg.calculate_batch : -4061ORA-04061: existing state of has
been invalidated

ORA-04061: existing state of package "APPS.CN_FORMULA_xxx_PKG" has been invalidated

ORA-04065: not executed, altered or d

EXCEPTION in SEQ_DISPATCH : -6502ORA-06502: PL/SQL: numeric or value error

ORA-06512: at "APPS.CN_PROC_BATCHES_PKG", line 2968

ORA-04061: existing state of has been invalidated

ORA-04061: existing state of package "APPS.CN_FORMULA_xxx

EXCEPTION in Main when others : -6502ORA-06502: PL/SQL: numeric or value error

ORA-06512: at "APPS.CN_PROC_BATCHES_PKG", line 3248

ORA-06502: PL/SQL: numeric or value error

ORA-06512: at "APPS.CN_PROC_BATCHES_PKG", line 2968

ORA-04061: ex

Process completed with errors


What is the explanation of the error or why does it happen?

Troubleshooting Steps

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
Purpose
Troubleshooting Steps
 Community Discussions

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