My Oracle Support Banner

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

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.