Recurring Invoice Program Ends With Error "autoaccounting failed to generate dists" in NLS Environment.

(Doc ID 1549318.1)

Last updated on JUNE 20, 2016

Applies to:

Oracle Receivables - Version 12.1.1 and later
Information in this document applies to any platform.


When you attempt to copy a transation, ARXREC module: Recurring Invoice Program fails with the following error occurs:

 Processing Autotax
Inserting into Salesreps
0 row(s) inserted
Inserting into GL_DIST - REV
REV (and SUSPENSE) 1 row(s) inserted
Fetching orig_line_cursor
 Inserting into GL_DIST - REC/ROUND
DIST - REC - ROUND 1 row(s) inserted
Inv trx_number = 3283

Inv. level Salescredits 0 row(s) inserted
arxrec - Returned from arreci. Return Value 1
Calling etax interfaceReturning from etax interfacearxrec - autoaccounting failed to generate dists.
arxrec - Warning: incomplete accounting dists
Current system time is 19-NOV-2012 10:19:55
APP-AR-11526: ORA-00936: missing expression

APP-AR-11526: 0
arxrec: Error in Declaring Cursor - ps_cursor

FND Debug Log shows :


arxrec - autoaccounting failed to generate dists
arxrec: arxvtd returns FALSE





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