Service Request Form Errors due to Invalids after applying CS RUP Patches (Doc ID 2177873.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Teleservice - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Service Request Form


When making changes to an existing SR and trying to close and also opening and closing Task Notes field and when closing completed tasks after re-opening a completed task.


ERROR
-----------------------
When making changes to an existing SR and trying to close
See the error
FRM-40735: CLOSE_WINDOW trigger raised unhandled exception ORA-06508
Followed by ORA -01403:no data found
Error message when opening Task Notes field
FRM-40735: CLOSE_WINDOW trigger raised unhandled exception ORA-06508
Error when closing task notes box unable to close Task Notes, I have had to exit EPIC to continue
FRM-40735: CLOSE_WINDOW trigger raised unhandled exception ORA-06508
Error when closing completed tasks after re-opening a completed task.
ORA -01403:no data found


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Database Upgrade
2. Open Create Service Request form


While running Generate form files for JTF,CS,CSC  faced error for below mentioned forms .

cs forms/US CSXSRTSK.fmx
jtf forms/US JTFTKMAN.fmx
csc forms/US CSCCCTSK.fmx
cs forms/US CSXSRISR.fmx
csc forms/US CSCCCCRC.fmx

Manual Compililation shows errors in ad worker logs

JTFTKMAN.fmx failed with the following errors in the adwork log:

-----------------

Compiling KEY-LISTVAL trigger on ASSIGNEE_TYPE item in TASK_TEMPLATE data
block...
No compilation errors.

Compiling WHEN-VALIDATE-ITEM trigger on ASSIGNEE_TYPE item in TASK_TEMPLATE
data block...
Compilation error on WHEN-VALIDATE-ITEM trigger on ASSIGNEE_TYPE item in
TASK_TEMPLATE data block:
PL/SQL ERROR 302 at line 1, column 15
component 'ASSIGNEE_TYPE' must be declared
PL/SQL ERROR 0 at line 1, column 1
Statement ignored

Compiling WHEN-NEW-ITEM-INSTANCE trigger on ASSIGNEE item in TASK_TEMPLATE
data block...
Compilation error on WHEN-NEW-ITEM-INSTANCE trigger on ASSIGNEE item in
TASK_TEMPLATE data block:
PL/SQL ERROR 302 at line 5, column 15
component 'ASSIGNEE' must be declared
PL/SQL ERROR 0 at line 5, column 1
Statement ignored

Compiling KEY-LISTVAL trigger on ASSIGNEE item in TASK_TEMPLATE data block...

 

Similar error is seen while compiling other objects as well

cs forms/US CSXSRTSK.fmx
csc forms/US CSCCCTSK.fmx
cs forms/US CSXSRISR.fmx
csc forms/US CSCCCCRC.fmx

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