Recurring Invoice Program Ends With Error "autoaccounting failed to generate dists" in NLS Environment.
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:
Inserting into Salesreps
0 row(s) inserted
Inserting into GL_DIST - REV
REV (and SUSPENSE) 1 row(s) inserted
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
ORA-06512: at "APPS.ARP_AUTO_ACCOUNTING"
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