AR: Autoinvoice Import Program Ending With Error For Sales Return Credit Memo " PL/SQL: numeric or value error: character string buffer too small" (Doc ID 1562089.1)

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.

Symptoms

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
-----------------------
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'




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. run autoinvoice process

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot import credit memo transaction

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