My Oracle Support Banner

DISP_TMPL_FAM_CD Field Value Is Blank When Rollback the CRM Data Archival Process (Doc ID 2569964.1)

Last updated on JULY 28, 2019

Applies to:

PeopleSoft Enterprise CRM HelpDesk - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Data Import

ISSUE 
---------------
DISP_TMPL_FAM_CD field value is blank when we rollback the CRM data archival process

EXPECTED BEHAVIOR
-----------------------
Rollback from data archival process should be rollbacked properly.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1) Run the Selection process (Main table to history table). Data copied from main to table to history table.
2) Run the Delete process (Delete main table data which was copied in to history table).
3) Run the Rollback process (Copied history table data in to main table). Process to run to success but "DISP_TMPL_FAM_CD" fields in RC_CASE was empty.

Have verified the fields between RC_CASE and RC_CASE_HST. Noticed that "DISP_TMPL_FAM_CD" was not there in RC_CASE_HST table. There is one more fields as "DISP_TMPL_ID". But value in that one is empty.

 

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
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.