Editing a Commitment Allocation Record is Resulting in Error: ""IS_RECURRING" (actual: 5, maximum: 1)"
Last updated on JULY 09, 2014
Applies to:Oracle Transportation Management - Version: 6.1.4
Information in this document applies to any platform.
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".
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