My Oracle Support Banner

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 OCTOBER 12, 2022

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.


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"


Log file Error  : INV_NO_OPEN_PERIOD


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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