EAM: Mass Change - AMDPCALC Error: ORA-00936: Missing Expression - Brazilian Localization (Doc ID 1911609.1)

Last updated on SEPTEMBER 15, 2016

Applies to:

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

Symptoms

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.

ERROR
-----------------------
(SQR 5528) ORACLE OCIStmtExecute error 936 in cursor 107:
  ORA-00936: missing expression

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


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