My Oracle Support Banner

FRM-40831: Truncation Occurred: Value Too Long For Field APPLICATION_REF_NUM' (Doc ID 2375757.1)

Last updated on MARCH 23, 2018

Applies to:

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


On : 12.1.3 version, Collections

forms/US/ARXCOQIT.fmb 120.16.12010000.4

When 'Activities' button is clicked from Account Details form after selecting an Invoice that has receipts applied to it, the following error occurs.

  'FRM-40831: Truncation occurred: value too long for field APPLICATION_REF_NUM'. Refer screenshot

The issue can be reproduced at will with the following steps:
Open Account Details form
Query Customer Named "Jackie Org"
Invoice Number is listed there
Click on Activities button

The issue has the following business impact:
Due to this issue, users cannot view activities for this invoice.


Error only occurs when the data stores in INTERFACE_HEADER_ATTRIBUTE1 is over 30 characters


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.