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
Oracle Trading Community - Version 12.2.4 and later Information in this document applies to any platform.
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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!