EAM: Receiving Error when Trying to Run AMDPRET with Use Open Trans Flag Checked - Brazilian Localization (Doc ID 2005057.1)

Last updated on SEPTEMBER 15, 2016

Applies to:

PeopleSoft Enterprise FIN Asset Management Brazil - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.

Symptoms

On : 9.1 version, Depreciation

When attempting to run the AMDPRET with the Use Open Trans flag checked
the following error occurs.

ERROR
-----------------------
'AMDPREPT' Program Started (8800,7)

File: e:\pt85313c-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1625 Error Position: 1094 Return: 923 - ORA-00923: FROM keyword not found where expected
Failed SQL stmt: INSERT INTO PS_DEPR_RPABLTMP4 (PROCESS_INSTANCE , BUSINESS_UNIT , ASSET_ID , BOOK , DTTM_STAMP , CF_SEQNO , FISCAL_YEAR , START_PD , END_PD , ACTUAL_END_PD , ACTIVITY_ID, AFFILIATE, AFFILIATE_INTRA1, AFFILIATE_INTRA2, BUDGET_REF, BUSINESS_UNIT_PC, CHARTFIELD1, CHARTFIELD2, CHARTFIELD3, CLASS_FLD, DEPTID, FUND_CODE, OPERATING_UNIT, PRODUCT, PROGRAM_CODE, RESOURCE_CATEGORY, RESOURCE_SUB_CAT, RESOURCE_TYPE, CATEGORY , PROJECT_ID , COST_TYPE , TRANS_TYPE , TRANS_IN_OUT , TRANS_CODE , TRANS_DT , YTD_FLAG , ACTIVITY_SW , DEPR , DEPR_YTD , CURRENCY_CD , ARCHIVE_ID , MANUAL_DEPR_TYPE , SPEC_DEPR , INITIAL_DEPR , ACCEL_DEPR , INCREASE_DEPR , STANDARD_DEPR , FLAG_ABL , DEPRCTN_TP_ABL , TRANS_DT_ABL) SELECT 11763 , 'BGAM1' , A.ASSET_ID , 'BR_OFICIAL' , A.DTTM_STAMP , A.CF_SEQNO , A.FISCAL_YEAR , A.START_PD , A.END_PD , A.ACTUAL_END_PD , A.ACTIVITY_ID, A.AFFILIATE, A.AFFILIATE_INTRA1, A.AFFILIATE_INTRA2, A.BUDGET_REF, A.BUSINESS_UNIT_PC, A.CHARTFIELD1, A.CHARTFIELD2, A.CHARTFIELD3, A.CLASS_FLD, A.DEPTID, A.FUND_CODE, A.OPERATING_UNIT, A.PRODUCT, A.PROGRAM_CODE, A.RESOURCE_CATEGORY, A.RES A.CATEGORY , A.PROJECT_ID , A.COST_TYPE , A.TRANS_TYPE , A.TRANS_IN_OUT , A.TRANS_CODE , A.TRANS_DT , A.YTD_FLAG , A.ACTIVITY_SW , A.DEPR , A.DEPR_YTD , A.CURRENCY_CD , A.ARCHIVE_ID , A.MANUAL_DEPR_TYPE , A.SPEC_DEPR , A.INITIAL_DEPR , A.ACCEL_DEPR , A.INCREASE_DEPR , A.STANDARD_DEPR , A.FLAG_ABL , A.DEPRCTN_TP_ABL , A.TRANS_DT_ABL FROM PS_DEPRECIATION A , PS_ASSET_TMP4 B WHERE A.BUSINESS_UNIT = 'BGAM1' AND A.BOOK = 'BR_OFICIAL' AND A.FISCAL_YEAR ' '

Process 11763 ABENDED at Step AMDPREPT.DPRPT120.Step02_L (SQL) -- RC = 923 (108,524)

Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s

PSAESRV completed service request at 05.05.07 2014-10-31


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. go to Asset Management > Financial Reports > Load Reporting Tables > Depr Reporting Table
2. click in the Use Open Trans flag.


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