JBO-26041:Exception When Requester Is Added To Edit And Submit Requisition Page

(Doc ID 2351760.1)

Last updated on FEBRUARY 04, 2018

Applies to:

Oracle iProcurement - Version 12.2.6 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.6 version, Requisition Management

When attempting to edit and submit the requisition,
the following error occurs.

ERROR
-----------------------
oracle.apps.fnd.framework.OAException: oracle.jbo.DMLException: JBO-26041: Failed to post data to database during "Update": SQL Statement "BEGIN UPDATE PO_REQUISITION_LINES_ALL hhsPoRequisitionLineEO SET LAST_UPDATE_DATE=?,LAST_UPDATED_BY=?,LAST_UPDATE_LOGIN=?,TO_PERSON_ID=?,NOTE_TO_AGENT=?,NOTE_TO_RECEIVER=?,WIP_RESOURCE_SEQ_NUM=?,REQUESTER_EMAIL=?,NOTE_TO_VENDOR=? WHERE REQUISITION_LINE_ID=? RETURNING CLM_FUNDED_FLAG, CLM_INFO_FLAG, CLM_OPTION_INDICATOR INTO ?, ?, ?; END;".
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.icx.por.common.webui.ClientUtil.invokeMethod(ClientUtil.java:1050)
at oracle.apps.icx.por.common.webui.PorBaseCOImpl.invokeMethod(PorBaseCOImpl.java:258)
at oracle.apps.icx.por.common.webui.PorBaseCOImpl.executeServerCommand(PorBaseCOImpl.java:176)
at oracle.apps.icx.por.req.webui.CheckoutInfoBaseCO.pushNotes(CheckoutInfoBaseCO.java:2205)

## Detail 0 ##
java.sql.SQLException: ORA-01407: cannot update ("PO"."PO_REQUISITION_LINES_ALL"."TO_PERSON_ID") to NULL
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)

java.sql.SQLException: ORA-01407: cannot update ("PO"."PO_REQUISITION_LINES_ALL"."TO_PERSON_ID") to NULL
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)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Responsibility: I procurement.
2. Navigate to requisition: requisition.
3. Click on the requisition number and click on the update icon.


Changes

 

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