12.2 Concurrent Request FTP Delivery Option Fails With Error ORA-06502: PL/SQL: numeric or value error, ORA-06512: at "APPS.FND_VAULT", ORA-06512: at "APPS.FND_DELIVERY" When the USERNAME Greater Than 30 Characters (Doc ID 2171227.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

Oracle Concurrent Processing - Version 12.2 to 12.2.5 [Release 12.2]
Information in this document applies to any platform.

Symptoms

E-Business Suite 12.2.5 Concurrent Processing, Request Processing issues

 


When submitting a concurrent program and defining the FTP delivery options, if the length of the username field is greater than 30 characters the below error occurs:


ERROR
-----------------------
ORA-06502: PL/SQL: numeric or value error ORA-06512: at "APPS.FND_VAULT", line 904 ORA-06512: at "APPS.FND_VAULT", line 715 ORA-06512: at "APPS.FND_DELIVERY", line 423 ORA-06512: at "APPS.FND_DELIVERY", line 223 ORA-06512: at line 1


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
For any concurrent program perform the following:

1. In the Delivery Options tab, go to FTP Delivery Options Table
2. Enter "User Name" which is greater than 30 characters
3. Hit Submit button.
4. Request results in error.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot run scheduled reports as required, resulting in management not having information required to run the business.


Changes

 Upgraded from E-Business Suite 12.1.3 to 12.2.x.

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