Editing a Commitment Allocation Record is Resulting in Error: ""IS_RECURRING" (actual: 5, maximum: 1)" (Doc ID 1347237.1)

Last updated on JULY 09, 2014

Applies to:

Oracle Transportation Management - Version: 6.1.4 and later   [Release: 6.1 and later ]
Information in this document applies to any platform.

Symptoms


Customer has made the ScreenSet: CAPACITY_COMMITMENT_ALLOC, editable by updating the Screen Set and selecting "Edit" on the "General" tab. Now, whenever editing an Commitment Allocation and clicking Finished, it fails with the following error:

update capacity_commitment_alloc set capacity_commitment_alloc_xid=?, effective_date=?, expiration_date=?, x_lane_gid=?, commitment_lane_object_type=?, allocation_type=?, equipment_group_profile_gid=?, time_period_type_gid=?, is_recurring=?, domain_name=? where capacity_commitment_alloc_gid=? at [6030071, 2006-12-01 00:00:00 UTC, 2006-12-31 00:00:00 UTC, 038-038-786-787, SHIPMENT, SHIPMENT, null, null, false, MCD, MCD.6030071]
java.sql.BatchUpdateException: ORA-12899: value too large for column "GLOGOWNER"."CAPACITY_COMMITMENT_ALLOC"."IS_RECURRING" (actual: 5, maximum: 1)

This is because it is trying to insert "false" into the "IS_RECURRING" field instead of "N".

Cause

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 hundreds of Community platforms