FSCM Upgrade 9.2 Image 19 - ChartField Display Templates Data Issue (script: dlupsyse_u.dms) (records: CF_DSP_TMPL_HDR, CF_DSP_TEMPLATE) (Doc ID 2210189.1)

Last updated on DECEMBER 02, 2016

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 and later
Information in this document applies to any platform.

Goal

FSCM Upgrade 9.2 Image 19 - ChartField Display Templates Data Issue (script: dlupsyse_u.dms) (records: CF_DSP_TMPL_HDR, CF_DSP_TEMPLATE)

Get the following error when going to new component in upgrade 9.2 environment: Setup Financials/Supply Chain > Common Definitions > Design ChartFields > ChartField Display Templates > Define CF Display Templates
No matching buffer found for level (15,26)

Traced issue to no data in PS_CF_DSP_TMPL_HDR while there is data in PS_CF_DSP_TEMPLATE - data appears fine in 9.2 FSCM Demo

Found issue in dlupsyse_u.dms script and logs where zero rows were exported to invalid SQL where clause on PS_CF_DSP_TMPL_HDR while data was exported/imported for PS_CF_DSP_TEMPLATE

export CF_DSP_TEMPLATE where
  CF_DSP_TEMPLATE = 'ALLCFS';
export CF_DSP_TEMPLATE where
  CF_DSP_TEMPLATE = 'MIN_EXPR_ISSUE';
export CF_DSP_TMPL_HDR where
  SYSTEM_TEMPLATE > 'Y';

Will there be a Required at Upgrade fix for this issue found in dlupsyse_u.dms script for FSCM 9.2 Upgrade Image 19?

Solution

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