My Oracle Support Banner

ECA: Contracts > Create and Amend > Contract Notes - Allow the Application to Hold More Than 999 Contract Notes. Enhance the Application to Make NOTE_SEQ_NUM Field Length to Be 5 Digit Long (Doc ID 2732443.1)

Last updated on DECEMBER 03, 2020

Applies to:

PeopleSoft Enterprise FIN Contracts - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.


Contract notes heavily utilized. Currently, the system can only take 999 notes as the field length for NOTE_SEQ_NUM is defined as 3 digits long. Please enhance the application to allow NOTE_SEQ_NUM to be defined as 5 digit length

Replication Steps:

  1. Customer Contracts > Create and Amend > Contract Notes
  2. Keep adding notes to increment NOTE_SEQ_NUM in CA_NOTE table.
  3. Currently, it can only hold 999 lines as the field length is 3 digits.
  4. The requirement to add more than 999 lines to accommodate business needs.


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

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