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!


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