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 11.5.10.2 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



Symptoms

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.

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

Cause

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

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