EAM: AMPI1000.SQR Goes To Error: Value Too Large For column 'SYSADM'.'PS_PI_SCAN'.MATCH_STATUS'
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.
AMPI1000.SQR goes to error. Step 3 (Load Scan File) abends.
SQL Status = 12899, SQL Error = ORA-12899: value too large for column "SYSADM"."PS_PI_SCAN"."MATCH_STATUS" (actual: 2, maximum: 1)
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
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