Releasing Locks on Inventory Tables

The Release Inventory Locks page is intended for system administrator use only. Administrators can use this page to release the soft locks placed on inventory tables by a process that ended abnormally. The tables are released by deleting the demand line rows from the demand lock table and resetting the status on process scheduler. The process status is automatically set to Canceled when the soft locks are released. This cancellation prevents potential data corruption that could occur without releasing the appropriate soft lock. Soft locks for processes that are currently running with a status of Processing cannot be released using this page. These processes must first be canceled from PeopleSoft Process Scheduler. Once they are in a Canceled, Deleted, or Not Successful status, then soft locks can be released using this page.

The Release Inventory Locks page works on the following tables:

  • IN_DEMAND_LOCK

  • BCT_CTL

  • STAGED_INF_INV

  • STAGED_ITEM_INV

Page Name

Definition Name

Usage

Release Inventory Locks Page

RELEASE_INV_LOCKS

Remove soft locks from some inventory tables by resetting the processing status (database administrators only).

Use the Release Inventory Locks page (RELEASE_INV_LOCKS) to remove soft locks from some inventory tables by resetting the processing status (database administrators only).

Navigation:

Inventory > Release Inventory Locks

Field or Control

Description

Business Unit

To display the locks applied to business units, enter a single Inventory business unit or leave blank to display all business units.

Process Instance

To display the locks applied by a specific process run, enter the instance number from the Process Monitor component. Leave this field blank to display all processes.

Release Option

Identify the locks that you want to display. Values are:

  • All: Display all locks in all tables.

  • BCT: Display locks in transaction staging table (BCT_CTL).

  • Demand: Display locks in demand table IN_DEMAND.

  • Putaway: Display locks in putaway tables; STAGED_INF_INV and STAGED_ITEM_INV.

Search

Click to initiate a search of all locked records based on the search criteria of business unit, process instance, and release option. The system returns rows of process instances where the process status is not set to Processing and the processing status of the inventory table is set to Process.

Select Lines to Release Soft Locks

This section displays the results of the search criteria. To release the locks on the inventory tables, locate the process that you want to unlock, select the check box and save this page.

Field or Control

Description

Rows Locked

Displays the number of rows locked by this process instance.

User ID

Displays the user that launched the process instance.

End Date/Time

Displays the date and time that the process ended.

Run Status

Displays the current status of the process instance. This page is intended to release soft locks placed on tables by a process that ended abnormally. Soft locks for processes that are currently running with a status of Processing cannot be released using this page. These processes must first be canceled from PeopleSoft Process Scheduler. Once they are in a Canceled, Deleted, or No Success status, then soft locks can be released using this page.

Save

Click to update the selected rows:

  • The row is deleted from IN_DEMAND_LOCK.

  • The BCT_STATUS process status of the BCT_CTL record changes from 3 (in process) to 4 (reprocess).

  • The PROCESS_FLAG of the STAGED_INF_INV record changes from Y (yes) to N (no).

  • The PROCESS_FLAG of the STAGED_ITEM_INV record changes from Y (yes) to N (no).