Export of Expense Report Having PL/SQL: numeric or value error: character string buffer too small (Doc ID 2263346.1)

Last updated on MAY 26, 2017

Applies to:

Oracle Internet Expenses - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

 APXEXPER: Expense Report Export failed

Cause: FDPSTP failed due to ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "APPS.AP_WEB_EXPORT_ER", line 3039
ORA-06512: at line 1

Steps to reproduce



User A should create an I-expense on behalf of user B


1)The User A connect with his login
2)User A create an I-expense for himself and submit it
3)now the User A realize that he did a mistake and the I-expense should be with User B name
4)User A withdraw the generated I-expense and update it
5)Update the name to User B and re-enter again the I-expense then submit


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