Autoinvoice Error: ORA-01458: invalid length inside variable character string

(Doc ID 1207934.1)

Last updated on JULY 28, 2017

Applies to:

Oracle Receivables - Version 12.0.0 to 12.0.0 [Release 12.0]
Oracle Latin American Localization - Version 12.0.0 and later
Information in this document applies to any platform.

EXECUTABLE:RAXTRX - Autoinvoice Import Program


Symptoms

Oracle Receivables (AR): AutoInvoice Information Center > Troubleshooting AutoInvoice for Oracle Receivables Release 11.5 Through 12 >Troubleshooting Autoinvoice Failure Issues (Request Status = Error) > Note 1207934.1

When attempting to run Autoinvoice, the following error is displayed in the log file captured as instructed from <Note 1079666.1>

APP-AR-11526: ORA-01458: invalid length inside variable character string

This note may contain additional error statements in the log as shown in the example below:


APP-AR-11526: ORA-01458: invalid length inside variable character string

delete from AR_DISTRIBUTIONS where (SOURCE_ID in (select ADJUSTMENT_
APP-AR-11526: 8393427/ar/lib/raarrt.lpc 1694
Error calling raarrt3()
Error calling raapic()

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