My Oracle Support Banner

EAM: AMIF_FIN_PHY 210154 Do Select Invalid Syntax Error (Doc ID 2462349.1)

Last updated on FEBRUARY 03, 2019

Applies to:

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

Symptoms

AMIF1000 GOING TO NO SUCCESS IN MSS DB

Replication Steps:

1. Create project. Enter activity name and save.

2. Add Transaction , enter chart-field details. process transaction

3. PC_WRAPPER should go to success

4. In express asset definition enter asset details.

5. Run PC_EXPRSS_AM

6. capture the interface id from review page

7. navigate to unitize asset component, unitize asset for 4 assets

8. With new run control id run AMIF1000 process

Note that AMIF1000 process going to No success.

Error in message log-

File: e:\pt85608b-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #:

1725 Error Position: 0 Return: 8672 - [Microsoft][ODBC Driver 13 for SQL

Server][SQL Server]Executing SQL directly; no c ursor. [Microsoft][ODBC

Driver 13 for SQL Server][SQL Server]Incorrect syntax near the keyword

'WHERE'. [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Statement(s) c

Failed SQL stmt: SELECT PROJECT_ID ,DEPTID ,CATEGORY ,COST_TYPE

,OPERATING_UNIT, PRODUCT, FUND_CODE, CLASS_FLD, PROGRAM_CODE, BUDGET_REF,

AFFILIATE, AFFILIATE_INTRA1, AFFILIATE_INTRA2, CHARTFIELD1, CH ARTFIELD2,

CHARTFIELD3 ,BUSINESS_UNIT_PC, ACTIVITY_ID, RESOURCE_TYPE, RESOURCE_CATEGORY,

RESOURCE_SU B_CAT, ANALYSIS_TYPE FROM ( SELECT PROJECT_ID ,DEPTID ,CATEGORY

,COST_TYPE ,OPERATING_UNIT, PRODUCT,

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
 AMIF1000 GOING TO NO SUCCESS IN MSS DB
 Replication Steps:
 Error in message log-
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.