AMDPCALC- (SQR 5402) String Cannot Be Placed On Page: LINES.PROJECT_ID,LINES.RESOURCE_CATEGORY,LINES.RESOURCE_SUB_CAT,LINES.A (Doc ID 2160226.1)

Last updated on OCTOBER 28, 2016

Applies to:

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

Symptoms

On :  9.2 version, Depreciation

AM_DEPR_CALC abended when processing range of Retirement Rows that got created via Mass Transaction Manager (MTM). However, if running the process for only 1 asset, it will run to success.

ERROR
-----------------------
Process 760293 ABENDED at Step AM_DEPR_DATE.911021.Step20 (PeopleCode) -- RC = 4 (108,524)

Error on line 475:
 (SQR 5402) String cannot be placed on page: ORDER BY LINES.PROJECT_ID,LINES.RESOURCE_CATEGORY,LINES.RESOURCE_SUB_CAT,LINES.A
-- placement specified is out of range.  (0,1,0)

SQR for PeopleSoft: Program Aborting.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run Mass Transaction Manager to retire some assets
2. Run AMIF1000
3. Run AM_DEPR_CALC with Range of assets that need to be Retire (Run for 1 asset will run to sucess)

Changes

 

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