Cycle Count Not Prevented By Material Status On Locator / Subinventory Level (Doc ID 1492986.1)

Last updated on OCTOBER 03, 2024

Applies to:

Symptoms

Material Status at subinventory or locator level or any level is not working to prevent Cycle Count transctions.
The material status is setup to prevent Cycle Count transactions against a specific locator and subinventory but the same processes without exception for a cycle count.

For example, users can create a cycle count then schedule, enter counts and approve or reject counts. The adjustments process without error.

Disallowed Transactions

• Cycle Count
• Physical Inventory

Setup

• Disallowed Transactions:
  • Transaction Type - Cycle Count Adjustment is status controlled
  • Transaction Type - Physical Inventory Adjustment is also status controlled
• Profile option INV:MATERIAL STATUS SUPPORT set to Yes at site level

STEPS

1. Setup :
   a Material Status called Inactive and disallow all the transactions that have status control
   b. Setup a Subinventory and assign it status of Inactive
2. Assign items to the subinventory
3. Create a cycle count for the specific subinventory
4. Add items to the cycle count
5. Schedule the items
6. Perform Full Cycle Count
7. Enter Counts.
8. Adjustments process but expect them to fail as the status is inactive (which disallows all material transactions in this subinventory)

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.