Cannot Override Commitment Allocation Usage Records (Doc ID 759797.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

Oracle Freight Payment, Billing, and Claims - Version: 5.5.05 to 5.5.05.04
This problem can occur on any platform.

Symptoms

-- Problem Statement:
On 5.5.05, When attempting to override commitment allocation the following errors occur:

ERROR
Duplicate Row cannot be saved
or
Write_Record_Failure

-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Edit an existing commitment allocation record and set the usage percentage of an existing
service provider to zero and set the active flag to inactive by unchecking it
2. Add couple of other service providers with allocation percentages, when saving the second
record, the error "Duplicate Row cannot be saved" is shown
3. Then edit the allocation record by changing the percentage on the original commitment
allocation record followed by adding another record with a percentage that adds up to 100%. When
saving,see the error, Write_Record_Failure

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