My Oracle Support Banner

R12: AP: When Attempting To Import A New Invoice, The Payables Open Interface Import Program (APXIIMPT) Raises Error ORA-6502 (Doc ID 2742083.1)

Last updated on JANUARY 06, 2021

Applies to:

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


Payables Open Interface Import Program Completes In Error "ORA-06502: PL/SQL: numeric or value error: character string buffer too small". 

Concurrent Request Log file shows the following:

Start of log messages from FND_FILE
(Get_info 9) Get system tolerances
------------------>  p_org_id = 15779 p_set_of_books_id = 5575 l_multi_currency_
flag  = Y l_make_rate_mANDatory_flag  = Y l_default_exchange_rate_type  = Corpor
ate l_base_currency_code  = INR l_batch_control_flag  = No l_payment_cross_rate
=  l_base_min_acct_unit  =  l_base_precision  = 2 l_sequence_numbering  = P l_a
wt_include_tax_amt  = N l_gl_date_from_get_info = 29-DEC-20 l_gl_date_from_recei
pt_flag = S l_purch_encumbrance_flag = N l_chart_of_accounts_id  = 50270 l_pa_in
stalled  = Y l_positive_price_tolerance =  l_negative_price_tolerance  =  l_qty_
tolerance  =  l_max_qty_ord_tolerance =  l_inv_doc_cat_override  = N l_allow_int
erest_invoices = N
------------------>  l_transfer_desc_flex_flag  = Y l_retainage_ccid  =  l_calc_
user_xrate  = N l_approval_workflow_flag  = Y l_freight_code_combination_id  =  
l_add_days_settlement_date  = 0 l_disc_is_inv_less_tax_flag  = Y l_asset_book_ty
pe  =
gl_date_from_receipt_flag : S
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
End of log messages from FND_FILE
Program exited with status 1

Steps To Reproduce
The issue can be reproduced at will with the following steps:

  1. Populate the Payables Open Interface table(s) AP_INVOICES_INTERFACE and AP_INVOICE_LINES_INTERFACE with a new Invoice record to import.
  2. Log into the Application using a Payables responsibility.
  3. Go to the Standard Request Submission screen:: (N)Other > Requests > Run
  4. Submit concurrent "Payables Open Interface Import"




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.