EAM: AMPI1000.SQR Goes To Error: Value Too Large For column 'SYSADM'.'PS_PI_SCAN'.MATCH_STATUS' (Doc ID 2126940.1)

Last updated on JUNE 14, 2016

Applies to:

PeopleSoft Enterprise FIN Asset Management - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

AMPI1000.SQR goes to error. Step 3 (Load Scan File) abends.

Error Message:

SQL Status = 12899, SQL Error = ORA-12899: value too large for column "SYSADM"."PS_PI_SCAN"."MATCH_STATUS" (actual: 2, maximum: 1)

Steps:
-------------
This issue can be replicated by performing the following steps:

Navigation: Asset Management>Physical Inventory>Load/Match/Reconcile PI Info

1. Extract Asset
2. Generate Asset File
3. Load Scan file

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms