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.
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.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms