Contract Lifecycle Management : Unable To Delete A Modification Containing 2 PAR Documents Associated. (Doc ID 2229531.1)

Last updated on FEBRUARY 01, 2017

Applies to:

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

Symptoms

On : 12.2.4 version, Modifications

Unable to Delete a Modification containing 2 PAR Documents Associated.

User is attempting to create a MOD using two PARs listed below:
 
HSHQDN16C00018- RDTR-0001 and HSHQDN16C00018- RDTR-0001
Award Number: HSHQDN-16-C-00018


Due to the Award being in an incomplete status the user attempted to delete the MOD followed by using using one PAR at a time.
As a result the user is not able to delete the MOD and is getting System exception error.
 


ERROR
-----------------------

User receives the error: “No supplier site found” as an error message against the MOD.


Exception Details.
 oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "APPS.PO_MOD_CONTROL_PVT", line 545
ORA-01427: single-row subquery returns more than one row
ORA-06512: at line 1

at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:996)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(Unknown Source)
at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:735)
at oracle.apps.po.common.webui.ClientUtil.executeServerCommand(ClientUtil.java:156)
at oracle.apps.po.document.common.webui.DocumentActionsUtil.handleDeleteModAction(DocumentActionsUtil.java:7574)
at oracle.apps.po.document.common.webui.DocumentActionsUtil.doControlAction(DocumentActionsUtil.java:1477)
at oracle.apps.po.document.common.webui.ControlsPoplistCO.processFormRequest(ControlsPoplistCO.java:211)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:854)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:407)
at oracle.apps.fnd.framework.webui.beans.layout.OARowLayoutBean.processFormRequest(Unknown Source)
...



STEPS TO REPRODUCE
-----------------------
The issue can be reproduced at will with the following steps:
1. Create an Award. Approve the Award.
2. Create 2 different Post Award Requests (PAR) for just admin changes on the Award header.
    Approved these 2 PARs.
3. Auto create these 2 PARs on to the same Modification for the above Award.
4. Try to delete the Modification. See whether it is failing with same exception.


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