Customer Interface Concurrent Request Error After Applying Patch 19030202 - APP-AR-11526: ORA-01480: Trailing Null Missing from STR Bind Value (Doc ID 1994295.1)

Last updated on OCTOBER 20, 2016

Applies to:

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

Symptoms

Customer Interface failing after applying Patch 19030202

Error for location_id: 747327 orig_system_address_ref :XXXXX
racina: inside sqlca.sqlcode < 0 -1480
Current system time is 27-FEB-2015 14:41:46
APP-AR-11526: ORA-01480: trailing null missing from STR bind value


EVENTS TRACE SHOWS THE FOLLOWING:

dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x0, level=3,
mask=0x0)
----- Error Stack Dump -----
ORA-01480: trailing null missing from STR bind value
----- Current SQL Statement for this session (sql_id=c8u4fgryfpvxr) -----
BEGIN HZ_TAX_ASSIGNMENT_V2PUB.create_loc_assignment(p_init_msg_list
=> null,p_location_id => :loc_id,p_lock_flag =>
null,p_created_by_module => 'CUST_INTERFACE',p_application_id =>
:h_prog_appl_id,x_return_status => :h_return_status,x_msg_count
  => :h_msg_count,x_msg_data => :h_msg_data,x_loc_id
  => :x_loc_id); END;

Changes

 Applied patch 19030202 which upgraded file racina.lpc to 120.32.12010000.11

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