My Oracle Support Banner

INCIAR - ORA-06502: PL/SQL: Numeric or Value Error: Character String Buffer Too Small (Doc ID 403565.1)

Last updated on MAY 29, 2021

Applies to:

Oracle Advanced Pricing - Version 11.5.10 and later
Information in this document applies to any platform.


When attempting to generate Create Intercompany AR Invoices with program "Create Intercompany AR Invoices" (INCIAR) the following error occurs in the log file:

Return Warning from inarcil.
Warning: Cannot create invoice line

The issue can be reproduced at will with the following steps:
Inventory Responsibility => Report/Intercompany
1. Run AR Intercompany Invoice program
2. Check the log file, some of the transactions finish with error with the following messages:

calling QP API...
returned from QP API...
QP API returnStatus=E

Return Warning from inarcil.

Warning: Cannot create invoice line

End Processing Transaction ID: XXXXXXXX
Transaction ID: XXXXXXXX Status = FAILURE

The debug file shows:

[04-DEC-06 09:29:55] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.Populate_Temp_Table: Calling QP:Bulk
insert routine...
[04-DEC-06 09:29:55] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.Populate_Temp_Table: No. of records
inserted in QP_PREQ_LINES_TMP=2
[04-DEC-06 09:29:55] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.get_transfer_price: Initializing
control record...
[04-DEC-06 09:29:55] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.get_transfer_price: Calling QP:Price
Request routine ...
[04-DEC-06 09:29:58] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.get_transfer_price: Populating QP
results ...
[04-DEC-06 09:29:58] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.Populate_Results: ORA-06502: PL/SQL:
numeric or value error: character string buffer too small
[04-DEC-06 09:29:58] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.Populate_Results: Status_Code=OER
[04-DEC-06 09:29:58] 9: opmItemFlg = 0
[04-DEC-06 09:29:58] 9: Getting the transaction flow header Id and trxDate from mmt
[04-DEC-06 09:29:58] 9: After getting transaction flow header id from mmt
[04-DEC-06 09:29:58] 9: l_trxFlowHeaderId = 2
[04-DEC-06 09:29:58] 9: l_logicalTrxTypeCode = 0



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.