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_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:
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:
|
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:
|