My Oracle Support Banner

EAM: MTM BKS Template Abends When PC Chartfields are used in Selection (Doc ID 2462374.1)

Last updated on AUGUST 10, 2021

Applies to:

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


Project Costing Chartfields that were accessed in MTM Transaction Templates prior to the upgrade from PUM 23 to 26 are no longer working. When entering a project_id in the selection criteria section of MTM Template BKS - Asset Book Change, the MTM Tool abends.

Abend/Error Message

Executing Mass Transaction: BKS - Asset Book Change Sequence: 10 - Asset Book Change (8800,23)

SQL error. Stmt #: 1725 Error Position: 6300 Return: 904 - ORA-00904: "COST_BAL_VW"."PROJECT_ID": invalid identifier

Process 149981 ABENDED at Step MTM_LIB_AM.00000110.Step10 (SQL) -- RC = 904 (108,524)

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

PSAESRV completed service request at 00.24.10 2018-04-11

Expected Behavior
The expectation is that the Project Costing Chartfields would be available as selection criteria for the MTM Templates.

1) Select the MTM Template BKS - Asset Book change
2) Enter a value for Project ID in the selection criteria section of the template.
3) Submit the template.

Business Impact
Currently MTM Templates that used PC Chartfields as selection criteria are abending. Without the availability of PC Chartfields as selection criteria, the ability to select asset objects for mass change operations is limited.




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

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