AMSEC101.SQR Error Message "ORA-01722: invalid number"
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.
AMSEC01 process runs to Error with the error message "ORA-01722: invalid number"
(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.
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
6. Run AMSEC01 Process with option - 'Prepare for Depreciation'
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