R12:Format Payment Instructions with Text Output(IBY_FD_PAYMENT_FORMAT_TEXT) Errors with SQL Exception ORA-06502

(Doc ID 2215485.1)

Last updated on DECEMBER 23, 2016

Applies to:

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

Symptoms

The Format Payment Instructions with Text Output completed with error.

Concurrent program log file shows below messages:
---------------
SQLException occurred: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "APPS.IBY_EXTRACTGEN_PVT", line 380
ORA-06512: at line 1

FND log file shows below messages:

----------------
Enter: iby.plsql.IBY_FD_EXTRACT_GEN_PVT.Get_Payer_Denorm
sid:3012313: Enter: iby.plsql.IBY_FD_EXTRACT_GEN_PVT.Get_Payer_Denorm
Get_Payer_Denorm() entered. count: 1
sid:3012313: Get_Payer_Denorm() entered. count: 1
p_payment_id: 4001
sid:3012313: p_payment_id: 4001
Get_Hr_Address() entered. count: 1
sid:3012313: Get_Hr_Address() entered. count: 1
p_location_id: 142
sid:3012313: p_location_id: 142
format_hr_address() entered. count: 1
sid:3012313: format_hr_address() entered. count: 1
p_hr_location_id: 142
sid:3012313: p_hr_location_id: 142
HZ_FORMAT_PUB.get_default_ref_territory, Profile option HZ_REF_TERRITORY = US
format_hr_address() entered. count: 2
sid:3012313: format_hr_address() entered. count: 2
p_hr_location_id: 142
sid:3012313: p_hr_location_id: 142
HZ_FORMAT_PUB.get_default_ref_territory, Profile option HZ_REF_TERRITORY = US
An exception has occurred when creating extract..

 


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot crate the payment

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