PC_EXPRSS_AM Abends At Step PC_AM.SUMROWS.SUM10000 With ORA-00904: "RESOURCE_SUB_CAT": Invalid Identifier (Doc ID 1595206.1)

Last updated on MARCH 09, 2017

Applies to:

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

Symptoms

On : Project Costing 9.1, Project Assets

After applying ESA 9.1 Bundle #26 (patch 15895005), when attempting to run the Express Capitalization process, PC_EXPRSS_AM, the process fails with the following error:

ERROR
-----------------------
SQL error. Stmt #: 1623 Error Position: 199 Return: 904 - ORA-00904: "RESOURCE_SUB_CAT": invalid identifier
Failed SQL stmt: INSERT INTO PS_PC_AM1_TAO (PROCESS_INSTANCE , BUSINESS_UNIT

Process 22011 ABENDED at Step PC_AM.SUMROWS.SUM10000 (SQL) -- RC = 904 (108,524)

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to Project Costing > Assets > Express Capitalization
2. Run the PC_EXPRSS_AM process

Changes

 Applied ESA 9.1 Bundle #26 (patch 13456554) but not ESA 9.1 Bundle #27 (patch 15895005)

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