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

Last updated on JULY 20, 2024

Applies to:

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, XXX, XXX.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

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