Hi @XitUviniG ,

Usually this error comes when there is an issue in the exisiting custom fields. Could you try disabling each and find the exact custom field which issue is coming from. Could i also know whether all the 36 custom attributes are created in App10 UPD 7 or is it migrated from a previous track. I have noticed similar errors for migrated custom attributes where there is a inconsistancy in current track/version.

Nilushi-

​
Hi @Nilushi Silva ,

I've tried disabling each field but that didn't fix the issue.  This is due to the newly added field. Adding a new field to only this LU will give this error .This is not migrated  from a previous track and this is only coming in one environment .(Same copy is available in Dev environment and this issue is does not exist there).

Uvini

Hi @XitUviniG,

Could you please share us some screen shots of the custom field configuration which you are newly adding and also could you please follow below steps and provide the screenshot generated objects. 

(similar to above screenshot)

Nilushi - 

If it’s only happening in one environment, I recommend you refresh that environment from PROD and start over. This will save you time troubleshooting, but there’s a bigger issue at stake. Whatever is making that environment broken in this situation might also make other things work, and you want to be absolutely sure that whatever you develop there will still work when you deploy it to PROD.

Hi @Nilushi Silva ,

Please find the below attachments .

/* \ABC_VAN_SALES_LINE_CLT.CRE\TABLE: [dml] */
DECLARE
   columns_    Database_SYS.ColumnTabType;
   column_     Database_SYS.ColRec;
   table_name_ VARCHAR2(30) := 'ABC_VAN_SALES_LINE_CLT';
BEGIN
   Database_SYS.Reset_Column_Table(columns_);
   Database_SYS.Set_Table_Column(columns_, 'ROWKEY', 'VARCHAR2(50)', 'N', ' SYS_GUID()');
   
   Database_SYS.Set_Table_Column(columns_, 'CF$_ADDITIONAL_DISCOUNT', 'NUMBER', 'Y');
   Database_SYS.Set_Table_Column(columns_, 'CF$_ARE_CODE', 'VARCHAR2(100)', 'Y');
   Database_SYS.Set_Table_Column(columns_, 'CF$_BATCH', 'VARCHAR2(50)', 'Y');
   Database_SYS.Set_Table_Column(columns_, 'CF$_BRANCH_CODE', 'VARCHAR2(100)', 'Y');
   Database_SYS.Set_Table_Column(columns_, 'CF$_CASES', 'NUMBER', 'Y');
   Database_SYS.Set_Table_Column(columns_, 'CF$_CASH_INCENTIVE', 'NUMBER', 'Y');
   Database_SYS.Set_Table_Column(columns_, 'CF$_COPIES', 'NUMBER', 'Y');
   Database_SYS.Set_Table_Column(columns_, 'CF$_CREDIT_INCENTIVE', 'NUMBER', 'Y');
   Database_SYS.Set_Table_Column(columns_, 'CF$_DISCOUNT', 'NUMBER', 'Y');
   Database_SYS.Set_Table_Column(columns_, 'CF$_DISC_FLG', 'NUMBER', 'Y');
   Database_SYS.Set_Table_Column(columns_, 'CF$_EXCISE_TAX', 'NUMBER', 'Y');
   Database_SYS.Set_Table_Column(columns_, 'CF$_EXP_DATE', 'DATE', 'Y');
   Database_SYS.Set_Table_Column(columns_, 'CF$_EXTYPE', 'VARCHAR2(100)', 'Y');
   Database_SYS.Set_Table_Column(columns_, 'CF$_IFS_FLAG', 'VARCHAR2(100)', 'Y');
   Database_SYS.Set_Table_Column(columns_, 'CF$_INCENTIVE_DISCOUNT', 'NUMBER', 'Y');
   Database_SYS.Set_Table_Column(columns_, 'CF$_ITM_CODE', 'VARCHAR2(100)', 'Y');
   Database_SYS.Set_Table_Column(columns_, 'CF$_LOCATION_NO', 'VARCHAR2(100)', 'Y');
   Database_SYS.Set_Table_Column(columns_, 'CF$_PCS', 'NUMBER', 'Y');
   Database_SYS.Set_Table_Column(columns_, 'CF$_PLAN_NUMBER', 'NUMBER', 'Y');
   Database_SYS.Set_Table_Column(columns_, 'CF$_POSTED', 'VARCHAR2(100)', 'Y');
   Database_SYS.Set_Table_Column(columns_, 'CF$_POST_DATE', 'DATE', 'Y');
   Database_SYS.Set_Table_Column(columns_, 'CF$_PRICE', 'NUMBER', 'Y');
   Database_SYS.Set_Table_Column(columns_, 'CF$_PROD_DISC', 'NUMBER', 'Y');
   Database_SYS.Set_Table_Column(columns_, 'CF$_PROMOTIONAL_DISCOUNT', 'NUMBER', 'Y');
   Database_SYS.Set_Table_Column(columns_, 'CF$_PROM_CODE', 'VARCHAR2(20)', 'Y');
   Database_SYS.Set_Table_Column(columns_, 'CF$_PRO_DATE', 'DATE', 'Y');
   Database_SYS.Set_Table_Column(columns_, 'CF$_REGION_CODE', 'VARCHAR2(100)', 'Y');
   Database_SYS.Set_Table_Column(columns_, 'CF$_RET_RES', 'VARCHAR2(100)', 'Y');
   Database_SYS.Set_Table_Column(columns_, 'CF$_ROWVERSION', 'DATE', 'Y');
   Database_SYS.Set_Table_Column(columns_, 'CF$_SERIAL', 'NUMBER', 'Y');
   Database_SYS.Set_Table_Column(columns_, 'CF$_TRANSACTION_NO', 'NUMBER', 'Y');
   Database_SYS.Set_Table_Column(columns_, 'CF$_TRS_CODE', 'VARCHAR2(10)', 'Y');
   Database_SYS.Set_Table_Column(columns_, 'CF$_VAT_PERC', 'VARCHAR2(100)', 'Y');
   Database_SYS.Set_Table_Column(columns_, 'CF$_VAT_VALUE', 'NUMBER', 'Y');
   Database_SYS.Set_Table_Column(columns_, 'CF$_VS_HEADER_ID', 'VARCHAR2(200)', 'Y');
   Database_SYS.Set_Table_Column(columns_, 'CF$_VS_LINE_ID', 'VARCHAR2(200)', 'Y');
   Database_SYS.Set_Table_Column(columns_, 'CF$_VS_SESSION', 'NUMBER', 'Y');
   Database_SYS.Set_Table_Column(columns_, 'ROWVERSION', 'DATE', 'N');
   Database_SYS.Create_Or_Replace_Table(table_name_, columns_, 'IFSAPP_DATA', NULL, FALSE);
   
END;
/

/* \ABC_VAN_SALES_LINE_CLT.CRE\PRIMARY_KEY: ADML] */
DECLARE
   columns_    Database_SYS.ColumnTabType;
   table_name_ VARCHAR2(30) := 'ABC_VAN_SALES_LINE_CLT';
   index_name_ VARCHAR2(30) := 'ABC_VAN_SALES_LINE_CPK';
BEGIN
   Database_SYS.Reset_Column_Table(columns_);
   Database_SYS.Set_Table_Column(columns_, 'ROWKEY');
   Database_SYS.Create_Constraint(table_name_, index_name_, columns_, 'P', 'IFSAPP_INDEX', NULL, TRUE, FALSE);
END;
/

/* \ABC_VAN_SALES_LINE_CLT.CRE\REF_CONSTRAINTS\NO_REF_CONSTRAINT: NO CODE] */

/* \ABC_VAN_SALES_LINE_CLT.CRE\REMOVE_INDEX\NO_INDEX_TO_REMOVE: TNO CODE] */

/* \ABC_VAN_SALES_LINE_CLT.CRE\ALTERNATE_KEY: INO CODE] */

/* \ABC_VAN_SALES_LINE_CLT.CRE\CREATE_INDEX\CF$_ABC_VAN_SALES_3250540548_IX: LDML] */

Hi @Nilushi Silva  & @durette ,

This issue was due to table was locked by some sessions in this database. Killing all the sessions resolved the issue.

Thank you for your support .​​​​

/Uvini

Hi @XitUviniG ,
Thanks for the update and information passed.
/Nilushi