My Oracle Support Banner

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 DECEMBER 03, 2019

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

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
References


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