EAM: AM_AMAEDIST (Accounting Entry Creation) Process Error ORA-00904 - Brazilian Localization (Doc ID 1998292.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 : 9.1 version, Depreciation

When attempting to run AM_AMAEDIST (Accounting Entry Creation) the following error occurs.

ERROR
-----------------------
File: e:\pt85311b-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1623 Error Position: 518 Return: 904 - ORA-00904: "DISC"."COST_TYPE": invalid identifier Failed SQL stmt: SELECT DIST.BUSINESS_UNIT ,DIST.ASSET_ID ,DIST.TRANS_CODE ,DIST.COST_TYPE ,DIST.CAT EGORY ,DIST.COMPLEMENT_TP_ABL ,DIST.DEPRCTN_TP_ABL ,TO_CHAR(DIST.ACCOUNTING_DT,'YYYY-MM-DD') ,ASSET_ INFO.DESCR ,ASSET_INFO.CIAP_NUM_ABL ,ASSET_ICQ.NF_BRL ,ASSET_ICQ.NF_BRL_SERIES ,ASSET_ICQ.VENDOR_ID ,CATEG.DESCR , ' ' , ' ' , ' ' , ' ' FROM PS_AM_DST_DL_TMP4 DIST , PS_ASSET ASSET_INFO , PS_ASSET_AC Q_DET ASSET_ICQ , PS_CATEGORY_TBL CATEG WHERE DIST.PROCESS_INSTANCE = 13364 AND DIST.TRANS_TYPE = 'A DD' AND DIST.CATEGORY = 'AUTO' AND DISC.COST_TYPE = 'N' AND ASSET_INFO.BUSINESS_UNIT = DIST.BUSINE SS_UNIT AND ASSET_INFO.ASSET_ID = DIST.ASSET_ID AND ASSET_ICQ.BUSINESS_UNIT = DIST.BUSINESS_UNIT AND


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Process Depreciation.
2. Process AM_AMAEDIST

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