My Oracle Support Banner

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 OCTOBER 05, 2020

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
*** checked for relevance on 07-FEB-2019 ***
*** checked for relevance on 05-OCT-2020 ***

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

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