My Oracle Support Banner

Dispute Specific Lines Errors with ORA-24347: Warning of a NULL column in an aggregate function (Doc ID 1536450.1)

Last updated on FEBRUARY 02, 2018

Applies to:

Oracle Advanced Collections - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Creating a Dispute for Specific Lines results in the following error:

ORA-24347: Warning of a NULL column in an aggregate function

2 lines on the invoice -
Line 1 - 0 Original Amount - Dispute Amount blank - Dispute Quantity blank
Line 2 - 18 Original Amount - Dispute Amount blank - Dispute Quantity 1

Dispute Reason Clock Count Error
Dispute Section Specific Invoice Lines
Dispute Percent is highlighted, although the value is blank
Dispute Amount is not highlight, and value is 18.00

ORA-24347: Warning of a NULL column in an aggregate function
FRM-40735: WHEN-BUTTON-PRESSED trigger raised unhandled exception ORQA-01403

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
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
References


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