Prc: Transaction Import errors ORA-06502 Character String Buffer Too Small (Doc ID 1448981.1)

Last updated on JULY 15, 2016

Applies to:

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

Symptoms

When attempting to run PRC: Transaction Import (PAXTRTRX)
the following error occurs.

ERROR
-----------------------
Output shows

No data found


Request Log shows the error :

MSG-20002: ORA-20002: pre_import:ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at "APPS.PA_TRX_IMPORT", line 9239.


FND Log shows:

per.plsql.Leaving hxc_generic_retrieval_pkg.parse_it.20 1 20
per.plsql.Processing hxc_generic_retrieval_pkg.execute_retrieval_process.60 1 60
per.plsql.hxc_generic_retrieval_pkg.line8802 1 "ORA-06512: at ""APPS.HXC_GENERIC_RETRIEVAL_PKG"", line 6842
ORA-06512: at ""APPS.HXC_GENERIC_RETRIEVAL_PKG"", line 8380
"
per.plsql.Entering hxc_generic_retrieval_pkg.audit_transaction.10 1 10
per.plsql.hxc_generic_retrieval_pkg.line2403 1 Audit Transaction Params
per.plsql.hxc_generic_retrieval_pkg.line2404 1 p_mode is I
per.plsql.hxc_generic_retrieval_pkg.line2405 1 p_transaction_process_id is 1
per.plsql.hxc_generic_retrieval_pkg.line2408 1 p_status is ERRORS
per.plsql.hxc_generic_retrieval_pkg.line2409 1 p_description is ORA-06502: PL/SQL: numeric or value error: character string buffer too small
per.plsql.hxc_generic_retrieval_pkg.line2410 1 Global Transaction ID is 5572075


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run PRC: Transaction Import

Changes

Installed patches :
Patch 12700547 POOR PERFORMANCE ON PA_OTC_API IN PRC TRANSACTION IMPORT
Patch 10199258:R12.HXT.B FWDPORT:9920313:12.1.3: XFER TIME FRM OTL BEE NOT XFERN HR APP
Patch 11797402:R12.HXT.B GSI : PERFORMANCE ISSUE WITH TRANSACTION IMPORT

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