EAM: BRAZIL - RECAT FROM NONDEPRECIABLE TO DEPRECIABLE - AMDPCALC ORA-00923
Last updated on JANUARY 10, 2018
Applies to:PeopleSoft Enterprise FIN Asset Management Brazil - Version 9.1 and later
Information in this document applies to any platform.
Recategorizing an asset from a Non-depreciable Profile to a Depreciable
profile causes AMDPCALC to Error with the following message:
SQL Status = 923, SQL Error = ORA-00923: FROM keyword not found where
Error on line 71:
(SQR 3301) Program stopped by user request.
SQR for PeopleSoft: Program Aborting.
The issue can be reproduced at will with the following steps:
1. Basic ADD > Non Depreciable > Land Profile
2. Run Depreciation and Create Accounting Entries
3. Recategorize to a depreciable Profile - BLDG Profile
4. Run 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