R12: Exception Error Generated When Try to Apply Post Award Request for Admin Changes (Doc ID 2259511.1)

Last updated on APRIL 26, 2017

Applies to:

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

Symptoms

On :  12.2.4 version, Award/PO

When attempting to apply a PAR to a Modification in which only header level changes were made an exception error is being thrown and the PAR can not be incorporated in the PAR,
the following error occurs.

ERROR

Error Page
Exception Details.
 oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: NULL index table key value
ORA-06512: at "APPS.PO_AUTOCREATE_GROUPING_PVT", line 1598
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:741)
at oracle.apps.po.common.webui.ClientUtil.executeServerCommand(ClientUtil.java:156)
at oracle.apps.po.autocreate.webui.ReqSearchCO.processFormRequest(ReqSearchCO.java:912)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:854)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:423)
at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processFormRequest(OAPageLayoutHelper.java:1422)
at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processFormRequest(OAPageLayoutBean.java:1579)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1066)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1032)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:887)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:423)
at oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processFormRequest(Unknown Source)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1066)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1032)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:887)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:423)
at oracle.apps.fnd.framework.webui.beans.OABodyBean.processFormRequest(OABodyBean.java:363)
at oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(OAPageBean.java:3303)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1994)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:585)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:473)
at _pages.__oa._jspService(__oa.java:233)
at weblogic.servlet.jsp.JspBase.service(JspBase.java:34)
.
.
at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: NULL index table key value
ORA-06512: at "APPS.PO_AUTOCREATE_GROUPING_PVT", line 1598
ORA-06512: at line 1


Steps to reproduce:

1.  Responsibility:  CLM iProcurement
     Navigate to: Post Award Request Tab
2. Locate the Award in which the Modification is required.
3. Select the Award and choose to create a new PAR.
4. In the PAR enter comments at the header and then change a header field only.
5. Save the PAR, Validate it, and submit it for approval
6. Once approved, log in as the buyer (ensure that a draft mod has been started for the Award), go to the Buyer Work Center, PAR Demand Workbench
7. Under My PARs note that the PAR appears as an info line.
8. Select the PAR and in the Doc Builder ensure it says Add to Modification
9. Click the Add button to add the PAR to the Doc Builder

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