Error "FRM-4081: Truncation Occurred: Value Too Long For Field COMMENTS" when exporting data in Bills Receivable Portofolio Management (Doc ID 2756445.1)

Last updated on JANUARY 04, 2023

Applies to:

Symptoms

On : 12.1.3 version, Bills Receivable

In Portfolio Management, exporting data containing comments over 240 characters will show error FRM-40831: Truncation occurred: value too long for field COMMENTS.

The export will still be successful but customer has to click ok for every row where the error happens. If customer data has 100 rows with comments over 240 characters, they have to clicked 100 times to proceed with the export.

ERROR

-----------------------

FRM-4081: Truncation occurred: value too long for field COMMENTS

STEPS

-----------------------

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

1. Receivables Manager
2.  Go to Portfolio Management form
3. Query Customer name with comments exceeding 240 characters
4. Click File and then Export
5. Error will show (FRM-40831: Truncation occurred: value too long for field COMMENTS) for every row containing comments over 240 characters
6. Click ok each time error appears
7. Export will happen successfully

Changes

Cause

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