EAM: BRAZIL - RECAT FROM NONDEPRECIABLE TO DEPRECIABLE - AMDPCALC ORA-00923 (Doc ID 2194363.1)

Last updated on OCTOBER 18, 2016

Applies to:

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

Symptoms

Recategorizing an asset from a Non-depreciable Profile to a Depreciable
profile causes AMDPCALC to Error with the following message:


ERROR
-----------------------

SQL Status = 923, SQL Error = ORA-00923: FROM keyword not found where
expected

Error on line 71:
(SQR 3301) Program stopped by user request.

SQR for PeopleSoft: Program Aborting.



Replication STEPS
-----------------------
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

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