Trailing Spaces Being Passed To AR Interface Tables (Claim Reason) (Doc ID 2138548.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Trade Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Trade Management > Claims>

Due to the code in file ozfvarib.pls, when the claim reason is passed to Receivables (AR)
Transaction the Claim Reason gets truncated to 30 characters. In customer
case, the 30th char is a SPACE. When User goes to the AR Transaction
created from settled claim, they click on Incomplete button to make change
and get following error. "FRM-40654: Records has been updated. Requery block
to see change."

File ozfvarib.pls has the truncate command

ex: SELECT SUBSTRB('Softside Errors - Order Entry Error',1,30) name from
dual;
-outcome = 'Softside Errors - Order Entry ' <--leaves a space as the 30th
char.



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