My Oracle Support Banner

Error: Transactions have a Calculation Status of Unprocessed after Calculation (Doc ID 241517.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Incentive Compensation - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

A transaction that has a Calculation Status of 'Unprocessed' has failed to classify due to an invalid Classification Rules package

Error:
Package Body "APPS.CN_CLSFN_XXXX_X_XX" has errors


Running the following query shows that the package is invalid:

select object_name,owner,object_type
from dba_objects
where status like 'INVALID'
and object_name like 'CN_CLSFN_%';


Attempting to manually recompile using the following command results in errors:

alter package CN_CLSFN_XXXX_X_XX compile body;


Warning: Package Body altered with compilation errors.

SQL> show error
Errors for PACKAGE BODY CN_CLSFN_XXXX_X_XX:

LINE/COL ERROR
-------- -----------------------------------------------------------------
928/121 PLS-00103: Encountered the symbol "x" when expecting one of the
following:
. ( ) , * @ % & - + / at mod rem and or ||

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.