Multiple Errors in the BWC Demand Workbench When Using the Return Line Functionality (Doc ID 2099762.1)

Last updated on APRIL 20, 2023

Applies to:

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

Symptoms

Steps To Recreate The Issue

------------------------------------

Navigate to the Demand Workbench in the BWC
Select a Multi Line Requisiton with 3 or more lines
Select 2 lines from the Same requisition.
Click the Return Button
Enter a reason Code and uncheck the "return entire req" button and hit apply.

Error occurs

po.common.server.PoBaseAMImpl.executeServerCommand.EXCEPTION 2745247402 "Exception executing server command: AC_ReturnReqSvrCmd, returnReq (Exception stack trace follows.) java.lang.NullPointerException
at oracle.apps.po.autocreate.server.ReturnReqSvrCmd.returnReq(ReturnReqSvrCmd.java:704)
at oracle.apps.po.autocreate.server.ReturnReqSvrCmd.execute(ReturnReqSvrCmd.java:216)
at oracle.apps.po.common.server.PoBaseAMImpl.executeServerCommand(PoBaseAMImpl.java:110)

Customer applied patch 19702289 and then got errors:

Exception Details.

oracle.apps.fnd.framework.OAException: java.sql.SQLException:

ORA-6503:PL/SQL: Function returned without value

ORA-6512: at "APPS.POR_RETURNREQ_PROCESS", line 1289