Buyer Work Center Error ORA-06510 ORA-06512 APPS.PO_LINE_LOCATIONS_DRAFT_PKG LINE 675 ORA-01400: cannot insert NULL into (Doc ID 2702583.1)

Last updated on APRIL 04, 2025

Applies to:

Symptoms

Using Purchasing, Version 12.2


Actual:
Updating the purchase order lines in the buyer work center has errors.

Expected:
Updating  the purchase order lines should be successful without any errors.

Error:
Error Page
Exception Details.
oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-06510: PL/SQL: unhandled user-
defined exception
ORA-06512: at "APPS.PO_LINE_LOCATIONS_DRAFT_PKG", line 675
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "APPS.PO_LINE_LOCATIONS_DRAFT_PKG", line 603
ORA-01400: cannot insert NULL into
("PO"."PO_LINE_LOCATIONS_DRAFT_ALL"."OUTSOURCED_ASSEMBLY")
ORA-06512: at line 1
  at
oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:998)
  at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(Unknown Source)
  at
oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.jav
a:741)
  at oracle.apps.po.common.webui.ClientUtil.executeServerCommand(ClientUtil.java:156)
  at oracle.apps.po.document.common.webui.DocumentCO.processAction(DocumentCO.java:1957)
  at
oracle.apps.po.document.common.webui.DocumentCO.processConvertCurrencyAndAction(DocumentC
O.java:1646)
  at
oracle.apps.po.document.common.webui.DocumentCO.processFormRequest(DocumentCO.java:556)
  at oracle.apps.po.document.order.webui.OrderCO.processFormRequest(OrderCO.java:124)
  at
oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:952
)
  at
oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanConta
inerHelper.java:424)
  at
oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processFormRequest(OAPageLayoutHelper.java
:1884)
  at
oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processFormRequest(OAPageLayou
tBean.java:1598)
  at
oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.
java:1164)
  at
oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.
java:1130)
  at
oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:985
)
  at
oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanConta
inerHelper.java:424)
  at oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processFormRequest(Unknown
Source)
  at
oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.
java:1164)
  at
oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.
java:1130)
  at
oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:985
)
  at
oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanConta
inerHelper.java:424)
  at
oracle.apps.fnd.framework.webui.beans.OABodyBean.processFormRequest(OABodyBean.java:363)
  at oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(OAPageBean.java:3797)
  at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:2250)
  at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:607)
  at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:487)
  at _pages.__oa._jspService(__oa.java:233)
  at weblogic.servlet.jsp.JspBase.service(JspBase.java:34)
  at
weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
  at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
  at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)
  at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
  at oracle.apps.fnd.security.csrf.GuardFilter.doFilter(GuardFilter.java:276)
  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
  at oracle.apps.fnd.security.WLFilter.doFilter(WLFilter.java:161)
  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
  at oracle.apps.jtf.cabo.interceptor.JTFWrapperFilter.doFilter(JTFWrapperFilter.java:151)
  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
  at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(Unknown Source)
  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
  at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:501)
  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
  at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:138)
  at java.security.AccessController.doPrivileged(Native Method)
  at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:324)
  at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:464)
  at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:121)
  at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:211)
  at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)
  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
  at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:163)
  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
  at
weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletConte
xt.java:3748)
  at
weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.jav
a:3714)
  at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
  at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
  at
weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2283)
  at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2182)
  at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1499)
  at weblogic.work.ExecuteThread.execute(ExecuteThread.java:263)
  at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
## Detail 0 ##
java.sql.SQLException: ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "APPS.PO_LINE_LOCATIONS_DRAFT_PKG", line 675
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "APPS.PO_LINE_LOCATIONS_DRAFT_PKG", line 603
ORA-01400: cannot insert NULL into
("PO"."PO_LINE_LOCATIONS_DRAFT_ALL"."OUTSOURCED_ASSEMBLY")
ORA-06512: at line 1
  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
  at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
  at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
  at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
  at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
  at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:213)
  at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1111)
  at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)
  at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)
  at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3954)
  at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:9353)
  at
oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:15
39)
  at weblogic.jdbc.wrapper.PreparedStatement.execute(PreparedStatement.java:99)
  at oracle.apps.po.common.server.PoCallableStatement.execute(PoCallableStatement.java:297)
  at
oracle.apps.po.schema.server.PoLineLocationMergeEOImpl.synchronizeDraftTable(PoLineLocationMerg
eEOImpl.java:490)
  at oracle.apps.po.schema.server.PoMergeBaseEOImpl.doDML(PoMergeBaseEOImpl.java:205)
  at
oracle.apps.po.schema.server.PoLineLocationMergeEOImpl.doDML(PoLineLocationMergeEOImpl.java:9
71)
  at oracle.jbo.server.EntityImpl.postChanges(EntityImpl.java:4542)
  at oracle.apps.fnd.framework.server.OAEntityImpl.postChanges(OAEntityImpl.java:1770)
  at
oracle.apps.po.schema.server.PoMergeBaseEOImpl.postChanges(PoMergeBaseEOImpl.java:725)
  at
oracle.apps.po.schema.server.PoLineLocationMergeEOImpl.postChanges(PoLineLocationMergeEOImpl.j
ava:5112)
  at oracle.jbo.server.DBTransactionImpl.doPostTransactionListeners(DB


Replication:
The issue can be reproduced at will with the following steps:
1. Purchasing - Buyer Work Center
2. Choose the purchasing document
3. Navigate to the Lines
4. Update the line
5. Error

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.