Purchase Order (ORDFIND) Search Screen Locks GTT_PROMO* Tables

(Doc ID 2327420.1)

Last updated on NOVEMBER 17, 2017

Applies to:

Oracle Retail Merchandising System - Version 14.1.1 and later
Information in this document applies to any platform.

Symptoms

GTT_PROMO_COMP_TEMP and GTT_PROMO_TEMP tables are locked by the application user even if there is no activity in ordfind screen.

Steps to Reproduce:

1. Login to RMS application.
2. Run the query to validate if any table is locked by the application user.
3. Navigate to Ordering -> Orders screen and open the order search (ordfind) screen.
4. Run the session lock query to validate if any table is locked by the application user.
5. Notice that GTT_PROMO_COMP_TEMP and GTT_PROMO_TEMP tables are locked by the application user even if there is no activity in ordfind screen.

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