EAM: AMDP2100 Report gives error ORA-00904: "ES"."EFFDT": invalid identifier

(Doc ID 1543927.1)

Last updated on SEPTEMBER 15, 2016

Applies to:

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

Symptoms

In release 9.1, demo, after running the AMDP2100 report (Asset Net book Value detail), by PC Business Unit, the process goes to error with this message:

  ORA-00904: "ES"."EFFDT": invalid identifier
SQL: SELECT ES.DESCR FROM PS_BUS_UNIT_PC_VW2 ES WHERE ES.BUSINESS_UNIT_PC =
  :1 AND ES.SETID = :2 AND ES.EFF_STATUS = 'A' AND ES.EFFDT = (SELECT
  MAX(EFFDT) FROM PS_BUS_UNIT_PC_VW2 EFF WHERE EFF.BUSINESS_UNIT_PC =
  :1 AND EFF.SETID = :2 AND EFF.EFFDT
Error on line 130:
  (SQR 3722) Could not set up cursor.

SQR for PeopleSoft: Program Aborting.

Business Impact:
Unable to run AMDP2100 by PC Business Unit

Steps to replicate:
1. Go to Asset Management>Financial Reports>Cost and Depreciation>Asset Net Book Value.
2. Select Report By PC Business Unit, CF Template id -- Click on the "Update/Add CF Template" hyperlink to create a CF template of any name, leaving all defaults. Title override: the CF Template id, Amount length: 19

BU DEU01, book ASSETS_DEM,
As of Fiscal year 2000, period 11

Type Of Report- Detail
 

3. Hit Run - Select AMDP2100, Web, PDF.

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