My Oracle Support Banner

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.


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


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


**** Errored Activities

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

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.




To view full details, 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 a vibrant support community of peers and Oracle experts.