My Oracle Support Banner

EAM: AMDPREPT Fails at Step DPREPT.DPRPT224.STEP10 With Brazil Localization and in SQL Server (Doc ID 2597294.1)

Last updated on NOVEMBER 27, 2019

Applies to:

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

Symptoms

AMDPREPT fails with the following error.
This is happening in SQL Server

ERROR
----------
Stmt #: 1725 Error Position: 0 Return: 8646 - [Microsoft][ODBC
Driver 13 for SQL Server][SQL Server]Incorrect syntax near the keyword
'SET'.

[Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Statement(s) could not
be prepared. (SQLSTATE 42000) 8180

Failed SQL stmt: UPDATE SET DEPR = DEPR + ((:1) * ( 1.000)), DEPR_YTD =
DEPR_YTD + ((:2) * ( 1.000)), DEPR_LTD = DEPR_LTD + ((:3) * ( 1.000)),
SPEC_DEPR = SPEC_DEPR + ((:4) * ( 1.000)), INITIAL_DEPR = INITIAL_DEPR +
((:5) * ( 1.000)), ACCEL_DEPR = ACCEL_DEPR + ((:6) * ( 1.000)),
INCREASE_DEPR = INCREASE_DEPR + ((:7) * ( 1.000)), STANDARD_DEPR =
STANDARD_DEPR + ((: 8) * ( 1.000)) WHERE PROCESS_INSTANCE = :9 AND ASSET_ID =
:10 AND BOOK = :11 AND BUSINESS_UNIT = :12 AND CF_SEQNO = :13 AND
FISCAL_YEAR = :14 AND ACCOUNTING_PERIOD = :15 AND CATEGORY = :16 AND
COST_TYPE = :17 AND ACTIVITY_ID = :18 AND AFFILIATE = :19 AND
AFFILIATE_INTRA1 = :20 AND AFFILIATE_INTRA2 = :21 AND BUDGET_REF = :22
AND BUSINESS_UNIT_PC = :23 AND SECAO = :24 AND CHARTFIELD2 = :25 AND
CHARTFIELD3 = :26 AND CLASS_FLD = :27 AND DEPTID = :28 AND FUND_CODE =
:29 AND OPERATING_UNIT = :30 AND PRODUCT = :31 AND PROGRAM_CODE = :32
AND PROJECT_ID = :33 AND RESOURCE_CATEGORY = :34 AND RESOURCE_SUB_CAT =
:35 AND RESOURCE_TYPE = :36

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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