EAM: Mass Change - AMDPCALC Error: ORA-00936: Missing Expression - Brazilian Localization
(Doc ID 1911609.1)
Last updated on JUNE 17, 2022
Applies to:PeopleSoft Enterprise FIN Asset Management Brazil - Version 9.1 and later
Information in this document applies to any platform.
On : Brazil 9.1 version, Depreciation
When attempting to run Depreciation process for a asset that was transferred by the Mass Change process, the following error occurs.
(SQR 5528) ORACLE OCIStmtExecute error 936 in cursor 107:
ORA-00936: missing expression
The issue can be reproduced at will with the following steps:
1- Choose a asset, the asset must have depreciation for periods ahead the current one.
2- Set up a Mass Change Definition to transfer the chosen asset
Inform the asset to transfer
Inform the Business Unit
Inform the Transaction Date and Accouting Date
Generate the SQL and Save
3- Execute the Mass Change
4- Execute the process to load the assets into AM
5- Check if there is a open transaction for the asset loaded
6- Run the depreciation process
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document