My Oracle Support Banner

Formula Packages Getting Dropped For One Operating Unit When Generated For Another Operating Unit (Doc ID 2490197.1)

Last updated on FEBRUARY 25, 2019

Applies to:

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

Symptoms

On : 12.2.5 version, Compensation Plan

ACTUAL BEHAVIOR
---------------
Upon running "Generate Formula Packages" is run for one Operating Unit Formula packages for other operating unit getting dropped and the program 'Transaction Batch Runner' errors with below reason.

ERROR
--------

ORA-06550: line 1, column 7:
PLS-00201: identifier 'CN_FORMULA_10052_317_PKG.CALCULATE_QUOTA' must be
declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored




EXPECTED BEHAVIOR
-----------------------
When "Generate Formula Packages" is run for one Operating Unit formula packages of other operating Unit should not be affected


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Log in to Applications
2. Go to Plan Administrator responsibility
3.Navigate to Requests >Schedule >
Program Name Generate Formula Packages
Provide Operating Unit X as parameter

Observe it will drop all other Formula Packages.



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!


In this Document
Symptoms
Cause
Solution
References


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