Error In POR_AMENDMENT_PKG.CLM_REQ_MERGE_RESERVE During Creation of CLM Requisition Amendment (Doc ID 2175729.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Contract Lifecycle Management for Public Sector - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

In Oracle iProcurement, with Oracle Contract Lifecycle Management (CLM), Release 12.1.3, an error occurs during requisition amendment merge.



ERROR

The following error information is seen in the wfstat.sql output:

 

**** Errored Activities

Activity RESULT Error Name
--------------------------------------------- --------------- -----------------------------
Error Message
------------------------------------------------------------------------------------------------------------------------------------
Error Stack
------------------------------------------------------------------------------------------------------------------------------------
MERGE_RESERVE_CLM_REQUISITION #EXCEPTION -6502
ORA-06502: PL/SQL: numeric or value error: character string buffer too small

POR_AMENDMENT_PKG.MERGE_INTO_CONFORM_VERSION()
Wf_Engine_Util.Function_Call(POR_AMENDMENT_PKG.CLM_REQ_MERGE_RESERVE, REQAPPRV, 677348-177803, 258593, RUN)



Steps To Reproduce

The issue can be reproduced at will with the following steps, using a CLM iProcurement responsibility:
1. Create a new requisition and approve it.
2. Create an amendment, changing DFF and UDA values.
3. Submit the amendment for approval. The errors occur in the workflow and the document ends up in Pre-Approved status.



Changes

 

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