PC 9.2: PROJECTS_ALL SQL Error: 942 - ORA-00942: Table Or View Does Not Exist

(Doc ID 2132817.1)

Last updated on JULY 11, 2017

Applies to:

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

Symptoms

When clicking on Edit icon on dynamic leaf for PROJECT_ALL tree structure,  Receive the following error message:

Error:
A fatal peoplecode SQL error occurred.  Please consult your system log for details error
SQL error. Function:  Rowset.Fill
Error Position:  247
Return:  942 - ORA-00942: table or view does not exist
 Statement:  select
fill.business_unit,fill.project_id,fill.row_number_5,fill.wbs_id,fill.activity_id,fill.descr1,fill.descr,fill.activity_type,fill.eff_status,fill.pc_process_status,fill.pc_act_owner,fill.pc_milestone_flg,fill.summary_act,fill.tree_name
from PS_PC_ACTT_SRCH FILL  WHERE   FILL.PROJECT_ID =:1 ORDER BY
FILL.ACTIVITY_ID
  Original Statement:  %SelectAll(:2 FILL)
WHERE   FILL.PROJECT_ID =:1 ORDER BY FILL.ACTIVITY_ID

Replication steps:
1) Search for Tree that has PROJECTS_ALL tree structure
Click Search
2) Expand the nodes of the tree as shown in the screenshot below.
3) Click on the edit (pencil icon on the dynamic leaf.
A SQL error is displayed
 A fatal peoplecode SQL error occurred.  Please consult your system log for details error

 

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