Code Loading Into Code And Description After Upgrade To 12.2.4

(Doc ID 2381535.1)

Last updated on MAY 24, 2018

Applies to:

Oracle Demantra Demand Management - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

Having issue with Code loading into Code and Description after upgrade to 12.2.4
Issue that happened during last upgrade as well.

Cannot update the data through SQL because the data in the SYNTAX column is greater than 4000 characters.
Need a fix to get the EP_MODEL_SYNTAX table updated so that the data load will load the correct values.
One of the affected records has table_name = 't_ep_p2a1'


The issue can be reproduced at will with the following steps:
----------------
a. Perform an Application and Platform Upgrade from 7.3.1.4 to 12.2.4.

b. Load data using the EP_LOAD_MAIN procedure.

c. See that some records in the table EP_MODEL_SYNTAX now have the code being put into the code and description fields when executing the SYNTAX.

d. Records that appear to be affected can be retrieved as follows:
select * from ep_model_syntax
where table_name in ('t_ep_p2a1'
  ,'t_ep_e1_it_br_cat_2'
  ,'t_ep_e1_it_br_cat_3'
  ,'t_ep_e1_it_br_cat_4'
  ,'t_ep_e1_it_br_cat_5'
  ,'t_ep_e1_item_cat_1'
  ,'t_ep_e1_item_cat_2'
  ,'t_ep_e1_item_cat_3'
  ,'t_ep_p2a2');

c. Check the SYNTAX column. Will use t_ep_p2a1 as an example. The fourth line of the SYNTAX is

DECODE(t_src_item_tmpl.t_ep_p2a1,NULL,t_src_item_tmpl.t_ep_p2a1,t_src_item_tmpl.t_ep_p2a1) p2a1_desc

when it should be

DECODE(t_src_item_tmpl.t_ep_p2a1_desc,NULL,t_src_item_tmpl.t_ep_p2a1,t_src_item_tmpl.t_ep_p2a1_desc) p2a1_desc

Notice how it is using t_src_item_tmpl.t_ep_p2a1 when it should be using t_src_item_tmpl.t_ep_p2a1_desc in the SELECT statement.



Changes

 

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