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