Dispute Specific Lines Errors with ORA-24347: Warning of a NULL column in an aggregate function

(Doc ID 1536450.1)

Last updated on JULY 25, 2016

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

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 hundreds of Community platforms