My Oracle Support Banner

PROGRAM_LOOKUP_VARS Table Is Not Being Updated Properly. (Doc ID 2368206.1)

Last updated on MARCH 02, 2018

Applies to:

Oracle Insurance Insbridge Rating and Underwriting - Version 5.2.0.0.0 and later
Information in this document applies to any platform.

Symptoms

On : Insbridge 5.2.0.0.0 version, API

ACTUAL BEHAVIOR
---------------
PROGRAM_LOOKUP_VARS table is not being updated properly.

--CREATE VIEW [REPORTING].[LOCAL_TABLE_VARS_ACTIVE_USED] AS
SELECT DISTINCT LV.ID,PF.DOMAIN_TYPE_ID, PF.DOMAIN_TYPE_NAME, PF.DOMAIN_ID, PF.DOMAIN_NAME,
  PF.PROJECT_ID, PF.PRJ_MODEL_ID, PF.PRJ_MODEL_VER, PF.PROJECT_NAME,--PF.PROJECT_ITEM_KEY,
  PF.PRODUCT_ID, PF.PRODUCT_NAME,
  PF.FOLDER_ID,PF.FOLDER_NAME, PF.PROGRAM_FOLDER,
  PF.PROGRAM_ID, PF.PROGRAM_NAME,PF.PROGRAM_VERSION,PF.VERSION_NAME,--, PR.PROG_KEY
  LV.TABLE_VAR_ID, LV.TABLE_VAR_REVISION,LV.VAR_DESC AS TABLE_VAR_NAME,
  LV.ASSIGN_TYPE AS CATEGORY_ID, TA.VAR_DESCRIPTION AS CATEGORY_NAME,
  LV.TYPE AS DATA_TYPE_ID, TD.VAR_DESCRIPTION AS DATA_TYPE_NAME,VAR_INDEX,
  LV.DATE_LAST_MOD AS DATE_LAST_MODIFIED
,lv.PRJ_MODEL_ID
  ,lv.PROGRAM_ID
  ,lv.TABLE_VAR_ID
  ,lv.PROGRAM_ID
  ,pf.PROGRAM_VERSION
  ,lv.TABLE_VAR_REVISION
  --SELECT *
  FROM INTERNAL.LOCAL_TABLE_VARS2 LV
  JOIN REPORTING.PROGRAM_VERSIONS PF
  ON PF.PRJ_MODEL_ID = LV.PRJ_MODEL_ID
  AND PF.PRJ_MODEL_VER = LV.PRJ_MODEL_VER
  AND PF.PRODUCT_ID = LV.PRODUCT_ID
  AND PF.PROGRAM_ID = LV.PROGRAM_ID
  LEFT OUTER JOIN dbo.TYPES_ASSIGN TA
  ON TA.ID = LV.ASSIGN_TYPE
  AND TA.PRJ_MODEL_ID = LV.PRJ_MODEL_ID
  JOIN dbo.TYPES_DATA TD
  ON TD.ID = LV.TYPE
  JOIN PROGRAM_LOOKUP_VARS as plv
  ON 1=1--plv.USED = 1 ----<<<<<<<<<<< used is not being set
  AND plv.PRJ_MODEL_ID = LV.PRJ_MODEL_ID
  AND plv.PARENT_PROG_ID = LV.PROGRAM_ID
  AND plv.LKUP_ID = LV.TABLE_VAR_ID
  AND plv.PROG_ID = LV.PROGRAM_ID
  AND plv.PROG_VER = PF.PROGRAM_VERSION
  AND plv.LKUP_VER = LV.TABLE_VAR_REVISION
  where 1=1
   AND PROGRAM_NAME = 'MN_M_NMIC_ADF'
AND VAR_DESC LIKE 'AccidentPreventionCourseDiscFactor_LT'
and PROGRAM_VERSION = 6

EXPECTED BEHAVIOR
-----------------------
USED column should be set to 1.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, PROGRAM_LOOKUP_VARS table is not being updated properly.

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.