R12.2 RACUST ends in APP-AR-11526: ORA-01480: trailing null missing from STR bind value error (Doc ID 2140823.1)

Last updated on AUGUST 29, 2017

Applies to:

Oracle Trading Community - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.4 version, Customers Module
While trying to import customers via Customer Interface Program, the request ends in error and the log file shows the following error:

ERROR
-----------------------
>>racuda: updating addresses.
Current system time is 07-MAR-2016 09:16:06
racuda: updated 1 addresses
Error for location_id: 12345678 orig_system_address_ref : BILL_TO/12345_12345678 123-45
racuda: inside sqlca.sqlcode < 0
-1480
Current system time is 07-MAR-2016 09:16:07
APP-AR-11526: ORA-01480: trailing null missing from STR bind value

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Insert data in interface tables RA_CUTOMERS_INTERFACE_ALL and RA_CUSTOMER_PROFILES_INT_ALL
2. Responsibility: Receivables Manager
3. Navigation: Requests > Run the Customer Interface Program
4. Review the log and notice the error message

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