Physical Inventory Adjustment 'SQL Error(Main-11a), Error Code = -1405' And Log File Shows INV_NO_OPEN_PERIOD (Doc ID 1533320.1)

Last updated on APRIL 10, 2017

Applies to:

Oracle Warehouse Management - Version 12.1.1 and later
Oracle Inventory Management - Version 12.1.1 and later
Information in this document applies to any platform.

Symptoms

In Oracle Warehouse Management, while performing the Launch Adjustment Concurrent program for Physical Inventory, User provides Adjustment Date as previous month date ( Adj date: 31-Dec-2013 - INV periods still open, but current date: 15-Jan-2013 - INV periods not yet opened), the program failed with error message as "No Inventory Open Periods"

ERROR

Log file Error  : INV_NO_OPEN_PERIOD

Changes

 

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