My Oracle Support Banner

Physical Inventory Adjustment (INCAPA) Fails with Error 'Sql Error(Main-11b), Error Code = 0' (Doc ID 415537.1)

Last updated on AUGUST 08, 2023

Applies to:

Oracle Inventory Management - Version and later
Information in this document applies to any platform.
This document includes all versions of Oracle 11i and R12
INCAPA: Perform physical inventory Adjustments


When launching Physical Inventory Adjustments, it fails with the following error:

SQL Error(Main-11b), Error Code = 0

Due to this error, you are unable to post the physical inventory adjustments, and cannot continue with inventory activities.

1. Navigate to inventory > requests > run.
2. Run INCAPA: Perform physical inventory Adjustments.
3. The program ends with error in the log file.


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
 1. For case 1: Transactions after freeze
 2. For Case 2: Invalid Locator

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