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

Last updated on JULY 14, 2016

Applies to:

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

Symptoms


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


STEPS
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
Status_Text=
[04-DEC-06 09:29:58] INV_INTERCOMPANY_INVOICING: MTL_QP_PRICE.get_transfer_price: EXCEP G_EXC_ERROR
[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

 

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