Procurement - EBS (MOSC)

MOSC Banner

When I click on add to create, I see 'JBO-26041 : Failed to.. ' error.?

edited Aug 15, 2013 10:56AM in Procurement - EBS (MOSC) 2 commentsAnswered ✓
 Hello, Add to cart in buyers work center gives the below error. Please help me fixing this.

thanks
RG3



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_REQUISITION_LINES_ALL(REQUISITION_LINE_ID,REQUISITION_HEADER_ID,LINE_NUM,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN,CREATION_DATE,CREATED_BY,DELIVER_TO_LOCATION_ID,TO_PERSON_ID,ITEM_DESCRIPTION,CATEGORY_ID,UNIT_MEAS_LOOKUP_CODE,UNIT_PRICE,QUANTITY,LINE_TYPE_ID,SOURCE_TYPE_CODE,ITEM_ID,ITEM_REVISION,SUGGESTED_BUYER_ID,ENCUMBERED_FLAG,RFQ_REQUIRED_FLAG,NEED_BY_DATE,BLANKET_PO_HEADER_ID,BLANKET_PO_LINE_NUM,CURRENCY_CODE,RATE_TYPE,RATE_DATE,RATE,CURRENCY_UNIT_PRICE,SUGGESTED_VENDOR_NAME,SUGGESTED_VENDOR_LOCATION,SUGGESTED_VENDOR_CONTACT,SUGGESTED_VENDOR_PHONE,SUGGESTED_VENDOR_PRODUCT_CODE,UN_NUMBER_ID,HAZARD_CLASS_ID,URGENT_FLAG,SOURCE_ORGANIZATION_ID,SOURCE_SUBINVENTORY,DESTINATION_TYPE_CODE,DESTINATION_ORGANIZATION_ID,DESTINATION_SUBINVENTORY,VENDOR_ID,VENDOR_SITE_ID,VENDOR_CONTACT_ID,WIP_ENTITY_ID,WIP_OPERATION_SEQ_NUM,ATTRIBUTE_CATEGORY,DESTINATION_CONTEXT,TRANSACTION_REASON_CODE,ORG_ID,CATALOG_TYPE,CATALOG_SOURCE,MANUFACTURER_NAME,MANUFACTURER_PART_NUMBER,REQUESTER_EMAIL,REQUESTER_FAX,REQUESTER_PHONE,UNSPSC_CODE,SUPPLIER_DUNS,NEW_SUPPLIER_FLAG,ITEM_SOURCE_ID,SUPPLIER_REF_NUMBER,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,ATTRIBUTE11,ATTRIBUTE12,ATTRIBUTE13,ATTRIBUTE14,ATTRIBUTE15,CURRENCY_AMOUNT,NONCAT_TEMPLATE_ID,ASSIGNMENT_END_DATE,CONTRACTOR_REQUISITION_FLAG,LABOR_REQ_LINE_ID,SUGGESTED_VENDOR_CONTACT_FAX,SUGGESTED_VENDOR_CONTACT_EMAIL,ASSIGNMENT_START_DATE,ORDER_TYPE_LOOKUP_CODE,PURCHASE_BASIS,MATCHING_BASIS,NEGOTIATED_BY_PREPARER_FLAG,BASE_UNIT_PRICE,TAX_ATTRIBUTE_UPDATE_CODE) VALUES (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16,:17,:18,:19,:20,:21,:22,:23,:24,:25,:26,:27,:28,:29,:30,:31,:32,:33,:34,:35,:36,:37,:38,:39,:40,:41,:42,:43,:44,:45,:46,:47,:48,:49,:50,:51,:52,:53,:54,:55,:56,:57,:58,:59,:60,:61,:62,:63,:64,:65,:66,:67,:68,:69,:70,:71,:72,:73,:74,:75,:76,:77,:78,:79,:80,:81,:82,:83,:84,:85,:86,:87,:88,:89,:90,:91,:92,:93)". at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:980) at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:211) at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:720) at oracle.apps.icx.por.common.webui.ClientUtil.invokeMethod(ClientUtil.java:972) at oracle.apps.icx.icatalog.shopping.webui.NonCatalogRequestCO.executeServerCommand(NonCatalogRequestCO.java:1034) at oracle.apps.icx.icatalog.shopping.webui.NonCatalogRequestCO.handleAddToCart(NonCatalogRequestCO.java:670) at oracle.apps.icx.icatalog.shopping.webui.NonCatalogRequestCO.processFormRequest(NonCatalogRequestCO.java:316) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:815) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:382) at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processFormRequest(OAPageLayoutHelper.java:1189) at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processFormRequest(OAPageLayoutBean.java:1579) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1027) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:993) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:848) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:382) at oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processFormRequest(OAFormBean.java:395) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1027) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:993) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:848) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:382) at oracle.apps.fnd.framework.webui.beans.OABodyBean.processFormRequest(OABodyBean.java:363) at oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(OAPageBean.java:2863) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1840) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:538) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:426) at _OA._jspService(_OA.java:212) at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59) at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:379) at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594) at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518) at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64) at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26) at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15) at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:318) at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:621) at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370) at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:871) at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453) at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:313) at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:199) at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260) at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303) at java.lang.Thread.run(Thread.java:619) ## Detail 0 ## java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("PO"."PO_REQUISITION_LINES_ALL"."DELIVER_TO_LOCATION_ID") at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:205) at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1008) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1307) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3530) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1350) at oracle.jbo.server.OracleSQLBuilderImpl.doEntityDML(OracleSQLBuilderImpl.java:427) at oracle.jbo.server.EntityImpl.doDML(EntityImpl.java:5740) at oracle.apps.icx.por.schema.server.PorBaseEOImpl.doDML(PorBaseEOImpl.java:756) at oracle.jbo.server.EntityImpl.postChanges(EntityImpl.java:4539) at oracle.apps.fnd.framework.server.OAEntityImpl.postChanges(OAEntityImpl.java:1759) at oracle.jbo.server.DBTransactionImpl.doPostTransactionListeners(DBTransactionImpl.java:2996) at oracle.jbo.server.DBTransactionImpl.postChanges(DBTransactionImpl.java:2807) at oracle.jbo.server.DBTransactionImpl.commitInternal(DBTransactionImpl.java:1971) at oracle.jbo.server.DBTransactionImpl.commit(DBTransactionImpl.java:2173) at oracle.apps.fnd.framework.server.OADBTransactionImpl.commit(OADBTransactionImpl.java:690) at oracle.apps.icx.por.req.server.RequisitionSvrCmd.implicitSaveReq(RequisitionSvrCmd.java:301) at oracle.apps.icx.por.req.server.RequisitionAMImpl.implicitSaveReq(RequisitionAMImpl.java:895) at oracle.apps.icx.por.req.server.AddToCartSvrCmd.execute(AddToCartSvrCmd.java:188) at oracle.apps.icx.por.common.server.PorBaseAMImpl.executeServerCommand(PorBaseAMImpl.java:122) at oracle.apps.icx.icatalog.shopping.server.NoncatRequestSvrCmd.addToCart(NoncatRequestSvrCmd.java:405) at

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center