My Oracle Support Banner

Calculation Errors With ORA-38104: Columns Referenced In The ON Clause Cannot Be Updated: "STATUS" In Package CN_CALC_POPULATE_PVT Procedure Populate_batch (Doc ID 945444.1)

Last updated on AUGUST 23, 2020

Applies to:

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

Symptoms

When running calculation, the following error is encountered:

ORA-38104: Columns referenced in the ON Clause cannot be updated: "STATUS"
Exception occurs in population phase:
ORA-38104: Columns referenced in the ON Clause cannot be updated: "STATUS" in Package
CN_CALC_POPULATE_PVT Procedure Populate_batch
Exception occurs in batch runner (ID=62) : 1User-Defined Exception


This issue can be reproduced with the following steps:

(R) Compensation Manager
(N) Tasks
Calculate Compensation

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.