Create Blanket Purchase Agreement Fails With The Error: JBO-26041

(Doc ID 2077700.1)

Last updated on AUGUST 17, 2017

Applies to:

Oracle Purchasing - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Purchase Order

Create Blanket Purchase Agreement fails with the error: JBO-26041

Error:
Error Page
Exception Details.
 oracle.apps.fnd.framework.OAException: oracle.jbo.DMLException: JBO-26041: Failed to post data to database during "Insert": SQL Statement "INSERT INTO PO_ATTRIBUTE_VALUES_TLP_DRAFT(ATTRIBUTE_VALUES_TLP_ID,PO_LINE_ID,REQ_TEMPLATE_NAME,REQ_TEMPLATE_LINE_NUM,IP_CATEGORY_ID,INVENTORY_ITEM_ID,ORG_ID,LANGUAGE,LAST_UPDATE_LOGIN,LAST_UPDATED_BY,LAST_UPDATE_DATE,CREATED_BY,CREATION_DATE,DRAFT_ID) VALUES (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14)".
at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:996)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:211)
at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:722)
at oracle.apps.po.common.webui.ClientUtil.executeServerCommand(ClientUtil.java:152)
at oracle.apps.po.document.common.webui.DocumentCO.processAction(DocumentCO.java:941)
at oracle.apps.po.document.common.webui.DocumentCO.processConvertCurrencyAndAction(DocumentCO.java:720)
at oracle.apps.po.document.common.webui.DocumentCO.processFormRequest(DocumentCO.java:275)
at oracle.apps.po.document.agreement.webui.BlanketCO.processFormRequest(BlanketCO.java:78)
at tnv.oracle.apps.po.document.agreement.webui.TNVBlanketCOExt.processFormRequest(TNVBlanketCOExt.java:73)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:827)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:385)
at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processFormRequest(OAPageLayoutHelper.java:1206)
at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processFormRequest(OAPageLayoutBean.java:1579)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1039)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1005)
at oracle.apps.fnd.f

Replication Steps:
The issue can be reproduced at will with the following steps:
1. In purchasing super user
2. trying to create a Blanket purchase agreement in BWC
3. BWC -> Agreements -> Create Blanket Purchase Agreement
4. Enter supplier, supplier site, email and amount agreed.
5. save. Error comes up



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