During Requisition Approval - Editing The Requisition Causes Blocking Sessions When Submitted

(Doc ID 2269908.1)

Last updated on OCTOBER 17, 2017

Applies to:

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

Symptoms

Problem Summary
---------------------------------------------------
During requisition approval - editing the requisition causes blocking sessions when submitted

Problem Description
---------------------------------------------------
A requisition approver is attempting to submit a requisition after making a change. However after clicking the submit button the requisition just hangs and then there are blocking sessions occurring.


It was discovered the code is hanging at the following point:
/* Formatted on 4/26/2017 2:45:26 PM (QP5 v5.240.12305.39446) */
UPDATE ZX_LINES_DET_FACTORS
  SET TRX_LINE_ID = :B1
WHERE TRX_LINE_ID = :B2
  AND ENTITY_CODE = 'REQUISITION'
  AND EVENT_CLASS_CODE = 'REQUISITION'
  AND APPLICATION_ID = 201

However, tax applicability is unchecked for requisitions and purchase orders.


STEPS
-------------------
1. Receive notification
2. log into Application
3. click on notification
4. update quantity
5. follow check out path
6. click submit
this is where the application hangs and eventually times out.


BUSINESS IMPACT
-----------------------
Due to this issue, users cannot complete their change to Requisition

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