INVPCKLT - Security Rules NOT Restricting Stock Locators On Select Available Form [Video]

(Doc ID 1465834.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Inventory Management - Version 12.0.0 and later
Information in this document applies to any platform.
INVPCKLT.fmb: Select Available Form

Symptoms

The Available Inventory form (INVPCKLT) does NOT restrict availability by the security rules.

What is working

The miscellaneous transactions, move orders, and transact move order screens DO HONOR the restriction.  The restriction is ignored when using the available inventory (Button) off of transact move orders. The data can then be SENT BACK and incorrectly save in the transact move order form.

Steps

Video - Showing Select Available Screen With WRONG Locators (06:09)

1. Create value-set
* Navigate to System Administrator > Application > Validation > Sets
* Create a value set with specific independent values.
* Ensure security is enabled.

2. Create values
* Navigate to System Administrator > Application > Validation > Values
* Enter values like OSS1, OSS2, OSS3.

3. Add value-set to locator
* Navigate to System Administrator > Application > Flexfield > Key > Segments
* Setup the stock locators key flexfield with the value-set listed on one of the locator segments (ie., bin - segment3) and set security enabled = Yes, TRUE.

4. Receive quantity (BEFORE have rule)
* Navigate to Inventory > transactions > Miscellaneous Transactions
* Receive quantity into OSS1 and OSS3.

5. Create security rule:
* Navigate to System Administrator > Security > Responsibility > Valueset
* Query the value-set created and create a rule.
* Include OSS1 and OSS2.
* Exclude OSS3.

6. Try to receive MORE into OSS1 and OSS3.
* Navigate to Inventory > transactions > Miscellaneous Transactions
* Receive quantity into OSS1. Works fine.
* TRY to receive into OSS3. CANNOT. THIS IS CORRECT.
*** Security rule working.

7. Create a move order
* Navigate to Inventory > Move Orders > Move Orders
* Create a move order for a locator controlled item (prefer one from earlier with onhand)
* Note: In locator field, check list of values (but do NOT select locator). Just note that you CAN pick OSS1, but NOT OSS3.
*** Security rule working.

8. Transact move order
* Navigate to Inventory > Transact Move Order > View Allocations
* View allocations
* See can enter OSS1 but NOT OSS3.
*** Security rule working.

9. Choose "Select Available Quantity" Button.
* See ALL locators including OSS3.
* Choose OSS3.
* Value returns to transact move order form.
* Can transact INVALID OSS3 locator.
*** Security rule NOT working.

Business Impact

Users can select locator that are not usable.

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