INCIAR - ORA-06502: PL/SQL: Numeric or Value Error: Character String Buffer Too Small

(Doc ID 403565.1)

Last updated on MARCH 12, 2018

Applies to:

Oracle Advanced Pricing - Version 11.5.10 to [Release 11.5]
Information in this document applies to any platform.


When attempting to generate AR Intercompany 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



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