AR: Autoinvoice Import Program Ending With Error For Sales Return Credit Memo " PL/SQL: numeric or value error: character string buffer too small"
Last updated on MARCH 08, 2017
Applies to:Oracle Financials for India - Version 12.1.3 and later
Information in this document applies to any platform.
On : 12.1.3 version, Transactions Related
AR: Autoinvoice Import Program ending with Error for Sales Return Credit Memo
We have created a Sales return in OM and trying to create Credit Memo for the same but when we run Autoinvoice Master Program, Autoinvoice Import Program is completing in error and not processing any data.
But when we create Manual Credit Memo with same transaction Type, Customer, Item and Taxes it works fine.
Uploading the output and log files of both programs and table extract of interface for the source which we are using
Error in insert_vat_repository_entry. Stmt:5
15:04:57 :raaudn: Call to FND_SEQNUM.GET_SEQ_VAL failed.ORA-20001: APP--20001: Encountered an error in JAI_AR_RCTA_TRIGGER_PKG.ARU_T8ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "APPS.APP_EXCEPTION", line 72
ORA-06512: at "APPS.JAI_AR_RCTA_ARIUD_T1", line 1006
ORA-04088: error during execution of trigger 'APPS.JAI_AR_RCTA_ARIUD_T1'
The issue can be reproduced at will with the following steps:
1. run autoinvoice process
The issue has the following business impact:
Due to this issue, users cannot import credit memo transaction
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms