EAM: AMPI1000 INVALID COLUMN NAME 'AM_MPI_FLAG' AFTER AMCHARTS.SQC REBUILD (Doc ID 2257133.1)

Last updated on APRIL 20, 2017

Applies to:

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

Symptoms

On : 9.2 version 21, Physical Inventory

AMPI1000 Abending Due to Invalid column name AM_MPI_FLAG

Upgraded from PeopleTools 8.53 to 8.55.

AMPI1000 abended with the message in <Doc ID 2227343.1>. We had to rebuild the AMCHARTS.SQC.
 

ERROR
-----------------------
Error 207 & Error 11501

(SQR 5528) ODBC SQL dbdesc: SQLNumResultCols error 207 in cursor 47:
  [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Invalid column name 'AM_MPI_FLAG'.
(SQR 5528) ODBC SQL dbdesc: SQLNumResultCols error 11501 in cursor 47:
  [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]The batch could not be analyzed because of compile errors.

Error on line 597:
  (SQR 3716) Error in SQL statement.

Errors were found in the program file.

SQR for PeopleSoft: Program Aborting.



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Upgrade from PTools 8.53 to 8.55. Rebuild the AMCHARTS.SQC

Other upgrade scenarios might be relevant.



BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot begin our annual inventory until this is fixed!

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