Insert Statements Generated By ConfigLab Are Incorrrect (Doc ID 878193.1)

Last updated on OCTOBER 18, 2016

Applies to:

Oracle Utilities Framework - Version: 2.2.0 to 2.2.0
This problem can occur on any platform.

Symptoms

INSERT Statements generated by ConfigLab are incorrect.

Some DB processes are creating incorrect insert commands - instead of a list of fields being provided to insert, the SQL statement which selects these fields is itself being included in the Insert statement.

Following is an example:
INSERT INTO CI_ACCT
(ACCT_ID,BILL_CYC_CD,SETUP_DT,CURRENCY_CD,ACCT_MGMT_GRP_CD,ALERT_INFO,BILL_AFTER_DT,PROTECT_CYC_SW,C
IS_DIVISION,MAILING_PREM_ID,PROTECT_PREM_SW,COLL_CL_CD,CR_REVIEW_DT,POSTPONE_CR_RVW_DT,INT_CR_REVIEW
_SW,CUST_CL_CD,BILL_PRT_INTERCEPT,NO_DEP_RVW_SW,BUD_PLAN_CD,PROTECT_DIV_SW,ACCESS_GRP_CD,ACCT_DATA_A
REA) SELECT
ACCTX.ACCT_ID,ACCTX.BILL_CYC_CD,ACCTX.SETUP_DT,ACCTX.CURRENCY_CD,ACCTX.ACCT_MGMT_GRP_CD,ACCTX.ALERT_
INFO,ACCTX.BILL_AFTER_DT,ACCTX.PROTECT_CYC_SW,ACCTX.CIS_DIVISION,ACCTX.MAILING_PREM_ID,ACCTX.PROTECT
_PREM_SW,ACCTX.COLL_CL_CD,ACCTX.CR_REVIEW_DT,ACCTX.POSTPONE_CR_RVW_DT,ACCTX.INT_CR_REVIEW_SW,ACCTX.C
UST_CL_CD,ACCTX.BILL_PRT_INTERCEPT,ACCTX.NO_DEP_RVW_SW,ACCTX.BUD_PLAN_CD,ACCTX.PROTECT_DIV_SW,ACCTX.
ACCESS_GRP_CD,ACCTX.ACCT_DATA_AREA FROM CI_ACCT ACCTX WHERE ACCTX.ACCT_ID='6754071260'



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