Upgrade on prod mode fails with error ORA-00904: "LOCKED_FLG": invalid identifier (Doc ID 1916427.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel CRM - Version 8.1.1.11 [23030] and later
Information in this document applies to any platform.

Symptoms

On : 8.1.1.11 SIA [23030] version, when attempting to run upgrep+upgphys on Production mode
the following error occurs.

ERROR
-----------------------
  insert into S_SRC_PAYMENT (ROW_ID , CREATED , CREATED_BY , LAST_UPD , LAST_UPD_BY , MODIFICATION_NUM , CONFLICT_ID , DB_LAST_UPD , DB_LAST_UPD_SRC , PAYMENT_REQ_NUM , TYPE_CD , BNFT_PLAN_ITM_ID , SEQ_NUM , PAY_AMT , ACTL_PAY_DT , PAY_STAT_CD , LOCKED_FLG , PAYEE_CON_ID ) select ROW_ID , BPIP.CREATED , BPIP.CREATED_BY , BPIP.LAST_UPD , BPIP.LAST_UPD_BY , BPIP.MODIFICATION_NUM , BPIP.CONFLICT_ID , BPIP.DB_LAST_UPD , BPIP.DB_LAST_UPD_SRC , ROW_ID , 'Disbursement' , BPIP.BNFT_PLAN_ITM_ID , BPIP.SEQ_NUM , BPIP.PAYMENT_AMT , BPIP.PAYMENT_TS , BPIP.STATUS_CD , 'N' , (select BNFT_RECIPIENT_ID from S_BNFT_PLAN_ITM BPI where BPI.ROW_ID = BPIP.BNFT_PLAN_ITM_ID) from S_BNFPLNITM_PAY BPIP
DBCLog DBCLogError 1 0000000253e405a8:0 2014-08-08 10:55:44 [DataDirect][ODBC Oracle driver][Oracle]ORA-00904: "LOCKED_FLG": invalid identifier


STEPS
-----------------------
The following steps have been followed by customer:
1. regenerate custrep.dat and schema.ddl from development
2. copy the files to the Test environment
3. run upgrep+upgphys in production mode, it fails with mentioned error

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