Users with Name More Than 25 Characters are Unable to Authorize the Stock Count (Doc ID 2748331.1)

Last updated on AUGUST 16, 2022

Applies to:

Symptoms

During Stock Count Authorization, when user name length is more than 25 characters then the below mentioned error is reported and the status of the stock count child remains in 'Processing' status.

Error:
 Error executing statement: update STOCK_COUNT set STORE_ID = ?, STATUS = ?, PHASE = ?, UPDATE_DATE_TIME = ?, EXPORT_USER = ?, BEFORE_STORE_OPEN = ? WHERE STOCK_COUNT.ID = ? AND STOCK_COUNT.STORE_ID = ?
java.sql.SQLException: ORA-12899: value too large for column "XXX"."STOCK_COUNT"."EXPORT_USER" (actual: 25, maximum: 20)

Steps To Recreate

1. Login to SIM PC and make sure the username length is greater than 25
2. Navigate to Admin -> Product Group > Create a Unit and Amount Product Group and Schedule it.
3. Take Snapshot an upload the stock count file.
4. Verify the quantities and proceed to authorize the stock count.
5. Notice, the above mentioned error is reported.

Changes

Cause

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