My Oracle Support Banner

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.