One of your ideas has been delivered from your suggestion.Increase Data Type of Column PERIOD_SEQ_NUM from Number(3) to Number(5) for Usage Transaction Tables

Customer usage transaction’s period sequence number (PERIOD_SEQ_NUM is Number(3)) is exceeding the limit of three digits. This fix increases the data type size of column PERIOD_SEQ_NUM from Number(3) to Number(5).

The USAGE Transaction tables impacted are:

  • D1_USAGE_PERIOD
  • D1_USAGE_PERIOD_ITEM_DET
  • D1_USAGE_PERIOD_SQ
  • D1_USAGE_PERIOD_SQ_DATA

Customers can now have more usage transaction’s period sequence numbers.

Steps to enable and configure

Refer to the Product Fix Document attached to Bug 38331599 for more information.

Tips and considerations

The functionality documented here was delivered in version 25.4 through Maintenance Pack 8­.8.2 (Bug 38331595).