Unable To Cancel Requisition Line. Process Completes But Line Does Not Show As Cancelled (Doc ID 1583244.1)

Last updated on JUNE 01, 2016

Applies to:

Oracle iProcurement - Version 12.1.3 to 12.2.3 [Release 12.1 to 12.2]
Oracle Services Procurement - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
---------------
Unable to cancel requisition line, Line does not show as cancelled

FND Log shows:

PO.PLSQL.POR_UTIL_PKGwithdraw_req 1 Leaving withdraw_req...
icx.por.cancelreq.server.CancelRequisitionUtil 1 withdrawReq: after calling
por_util_pkg.withdraw_req
java.lang.String 4 "Fatal OAException:java.sql.SQLException: ORA-01403: no
data found
ORA-06512: at ""APPS.POR_UTIL_PKG"", line 1464
ORA-06512: at line 1

EXPECTED BEHAVIOR
-----------------------
Expect line to be cancelled

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Log into iProcurement.
2. Submit requisition containing multiple items.
3. Requisition tab - Cancel Requisition.
4. Select a line and proceed.
5. On Cancel Confirmation details no line appears
6. Check Requisition.  Line is not cancelled

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot cancel a requisition line

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