My Oracle Support Banner

EMM: WM_TSK_SRCH_SBR Missing The UNASSIGNED Field In PUM 32. (Doc ID 2585303.1)

Last updated on MARCH 12, 2021

Applies to:

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

Symptoms



When attempting to apply FSCM 9.2 PUM 32 
the following error occurs.

ERROR
-----------------------
View created.

14:56:02 SQL> DROP VIEW PS_WM_RPT_SRCH_VW
14:56:02 2 /

View dropped.

14:56:02 SQL> CREATE VIEW PS_WM_RPT_SRCH_VW (OPRID, RUN_CNTL_ID, TSK_SRCH_CD, EMPLID
14:56:02 2 , BUSINESS_UNIT, WO_ID, WO_TASK_ID, BUSINESS_UNIT_WR, WR_ID, WO_TYPE,
14:56:02 3 TASK_ACTION, ACTL_START_DT, ACTL_END_DT, ACTL_SRCH_CD, ACTL_DT_CD,
14:56:02 4 SCHED_START_DT, SCHED_END_DT, SCHED_SRCH_CD, SCHED_DT_CD,
14:56:02 5 REQ_START_DT, REQ_END_DT, REQ_SRCH_CD, REQ_DT_CD, LOCATION,
14:56:02 6 LOCATION_IN_LIST, ENTERED_DT_FROM, ENTERED_DT_TO, SHOP_ID, ENTERED_BY
14:56:02 7 , BUSINESS_UNIT_PC, PROJECT_ID, ACTIVITY_ID, BUSINESS_UNIT_AM,
14:56:02 8 ASSET_ID, PROBLEM_GROUP, PROBLEM_CD, CAUSE_CD, RESOLUTION_CD,
14:56:02 9 SRVC_GRP_ID, WO_APPROVAL_STATUS, BASIS_DT_CD, STANDING_WO_FLG,
14:56:02 10 PM_SCHD_ID, PM_SRCH_CD, AREA_ID, ASSET_LOCATION, ASSET_TYPE,
14:56:02 11 ASSET_SUBTYPE, MFG_ID, MODEL, CRAFT_ID, CREW_BU, CREW_SHOP, CREW_ID,
14:56:02 12 CREW_FLG, MAINT_TYPE, TOOLS_REQ_FLG, TOOLS_ASSET_TYPE,
14:56:02 13 TOOLS_ASSET_SUBTYP, SCHEDULING_STATUS, SCHED_PERIOD, PERIOD_START_DT,
14:56:02 14 SRCH_OPR_1, SRCH_OPR_2, SRCH_OPR_3, SRCH_OPR_4, LAST_VIEW_SW,
14:56:02 15 PUBLIC_SW, VIEW_MODE, ASSET_CRITICALITY, WM_CUR_EMPLID_SW, TASK_DESCR
14:56:02 16 , ASSET_DESCR, UNASSIGNED) AS SELECT OPRID ,TSK_SRCH_VIEW ,TSK_SRCH_CD
14:56:02 17 ,EMPLID ,BUSINESS_UNIT ,WO_ID ,WO_TASK_ID ,BUSINESS_UNIT_WR ,WR_ID
14:56:02 18 ,WO_TYPE ,TASK_ACTION ,ACTL_START_DT ,ACTL_END_DT ,ACTL_SRCH_CD
14:56:02 19 ,ACTL_DT_CD ,SCHED_START_DT ,SCHED_END_DT ,SCHED_SRCH_CD ,SCHED_DT_CD
14:56:02 20 ,REQ_START_DT ,REQ_END_DT ,REQ_SRCH_CD ,REQ_DT_CD ,LOCATION
14:56:02 21 ,LOCATION_IN_LIST ,ENTERED_DT_FROM ,ENTERED_DT_TO ,SHOP_ID ,ENTERED_BY
14:56:02 22 ,BUSINESS_UNIT_PC ,PROJECT_ID ,ACTIVITY_ID ,BUSINESS_UNIT_AM
14:56:02 23 ,ASSET_ID ,PROBLEM_GROUP ,PROBLEM_CD ,CAUSE_CD ,RESOLUTION_CD
14:56:02 24 ,SRVC_GRP_ID ,WO_APPROVAL_STATUS ,BASIS_DT_CD ,STANDING_WO_FLG
14:56:02 25 ,PM_SCHD_ID ,PM_SRCH_CD ,AREA_ID ,ASSET_LOCATION ,ASSET_TYPE
14:56:02 26 ,ASSET_SUBTYPE ,MFG_ID ,MODEL ,CRAFT_ID ,CREW_BU ,CREW_SHOP ,CREW_ID
14:56:02 27 ,CREW_FLG ,MAINT_TYPE ,TOOLS_REQ_FLG ,TOOLS_ASSET_TYPE
14:56:02 28 ,TOOLS_ASSET_SUBTYP ,SCHEDULING_STATUS ,SCHED_PERIOD ,PERIOD_START_DT
14:56:02 29 ,SRCH_OPR_1 ,SRCH_OPR_2 ,SRCH_OPR_3 ,SRCH_OPR_4 ,LAST_VIEW_SW
14:56:02 30 ,PUBLIC_SW ,VIEW_MODE ,ASSET_CRITICALITY ,WM_CUR_EMPLID_SW ,TASK_DESCR
14:56:02 31 ,ASSET_DESCR ,UNASSIGNED FROM PS_WM_TSK_SRCH WHERE TSK_SRCH_CD = 'RP'
14:56:02 32 /
 ,ASSET_DESCR ,UNASSIGNED FROM PS_WM_TSK_SRCH WHERE TSK_SRCH_CD = 'RP'
  *
ERROR at line 31:
ORA-00904: "UNASSIGNED": invalid identifier




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run Creat View Step Via CA



Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.