AMSEC101.SQR Error Message "ORA-01722: invalid number" (Doc ID 1641780.1)

Last updated on APRIL 15, 2016

Applies to:

PeopleSoft Enterprise FIN Asset Management - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

AMSEC01 process runs to Error with the error message "ORA-01722: invalid number"

Error:

(SQR 5528) ORACLE OCIStmtFetch error 1722 in cursor 27:
    ORA-01722: invalid number
 
 Error on line 897:
    (SQR 3725) Bad return fetching row from database.
 
 SQR for PeopleSoft: Program Aborting.
 
Steps:
This issue can be verified by performing the following steps:

 1. Add a new asset with 'Depreciate When In Service'.
 2. Depreciate the asset.
 3. Transfer the asset to a different BU
 4. Depreciate the asset.
 5. Apply Depreciation Bonus to the asset using AMSEC01 process with 'Extract
 Only' option.
 6. Run AMSEC01 Process with option - 'Prepare for Depreciation'

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