الاخوة مديرى قواعد البيانات مطلوب مساعدة عاجلة فى Virtual Coloums

[asmaa123]

السلام عليكم 

وجدت  عدد من الجدوال وقد امتلئت بحقول تم اضافتها بواسطة اوركل بشكل تلقائى

ارجو معرفة السبب وكيفية  حل المشكلة 

 

مرفق جدول كمثال 
 

 

CREATE TABLE "DAMMAM1"."TRANS_DTL" 

   ( "SYS_STS0M2#S9K$STXC_LSNWTG0A9X" NUMBER GENERATED ALWAYS AS (SYS_OP_COMBINED_HASH("S_PRICE","INFO_CENTER_ID","INV_TYPE","ITEM_CODE","THE_YEAR","EXP_DATE","LIST_SEL_PRICE")) VIRTUAL HIDDEN,

"SYS_STS0RQPUNZUJHKZ6VBI5E#6ZNR" NUMBER GENERATED ALWAYS AS (SYS_OP_COMBINED_HASH("INFO_CENTER_ID","ITEM_CODE","THE_YEAR")) VIRTUAL HIDDEN,

"SYS_STS1OUYQCP0KKXN_MHD2MRSXXS" NUMBER GENERATED ALWAYS AS (SYS_OP_COMBINED_HASH("INFO_CENTER_ID","ITEM_CODE","THE_YEAR","EXP_DATE")) VIRTUAL HIDDEN,

"SYS_STS1RV88S3MW5AGLKBWHJ9AIQ2" NUMBER GENERATED ALWAYS AS (SYS_OP_COMBINED_HASH("S_PRICE","INFO_CENTER_ID","ITEM_CODE","THE_YEAR","EXP_DATE","BATCH_NO","LIST_SEL_PRICE")) VIRTUAL HIDDEN,

"SYS_STS5SM51$6TTVG_0$JCJTDDVYM" NUMBER GENERATED ALWAYS AS (SYS_OP_COMBINED_HASH("INV_TYPE","ITEM_CODE")) VIRTUAL HIDDEN,

"SYS_STSB166IJD0U9$8H$X_Y0YJLI#" NUMBER GENERATED ALWAYS AS (SYS_OP_COMBINED_HASH("INFO_CENTER_ID","THE_YEAR","EXP_DATE")) VIRTUAL HIDDEN,

"SYS_STSRFH$2X_IKDKRUQOZI#4Y6P#" NUMBER GENERATED ALWAYS AS (SYS_OP_COMBINED_HASH("INFO_CENTER_ID","ITEM_CODE","THE_YEAR","EXP_DATE","BATCH_NO")) VIRTUAL HIDDEN,

"SYS_STSRR09K5X3_F5ZG$BDB6$IFVL" NUMBER GENERATED ALWAYS AS (SYS_OP_COMBINED_HASH("ITEM_CODE","THE_YEAR")) VIRTUAL HIDDEN,

"INV_NO" VARCHAR2(10) NOT NULL ENABLE,

"S_PRICE" NUMBER(9,3),

"COST_PRICE" NUMBER(9,3),

"DTLNOTES" VARCHAR2(500),

"INFO_CENTER_ID" VARCHAR2(10) NOT NULL ENABLE,

"DISC_PERC" NUMBER(5,3),

"LINE_TOTAL" NUMBER,

"INV_TYPE" VARCHAR2(50) NOT NULL ENABLE,

"ITEM_CODE" VARCHAR2(10),

"QTY" NUMBER,

"SALES_DTL_ROW_ID" NUMBER NOT NULL ENABLE,

"UNIT_CODE" VARCHAR2(2),

"ITEM_BOUNS" VARCHAR2(1),

"THE_YEAR" NUMBER,

"V_ITEM_NAME" VARCHAR2(50),

"CURR_CODE" VARCHAR2(3),

"CONVERT_PRICE" NUMBER,

"LOCAL_AMOUNT" NUMBER,

"EXP_DATE" DATE,

"BATCH_NO" VARCHAR2(20),

"QTY_FLAG" NUMBER(1,0),

"REF_QTY" NUMBER,

"TRANS_M_ROW_ID" VARCHAR2(30),

"TRANS_M_PARENT" VARCHAR2(30),

"ITEM_BAR_CODE" VARCHAR2(15),

"QTY_FLAGX" NUMBER(1,0),

"PUR_PRICE_DISC" NUMBER(7,3),

"LIST_SEL_PRICE" NUMBER(8,2),

"BOUNS" NUMBER,

"DOSE_TYPE" NUMBER(1,0),

"MED_NOTES" VARCHAR2(100),

"DUR_LONG" NUMBER(5,2),

"DUR_TYPE" NUMBER(1,0),

"X1" VARCHAR2(10),

"X2" VARCHAR2(10),

"ITEM_NAME" VARCHAR2(50),

"FULL_DOSE_DESCRIPTION_EN" VARCHAR2(100),

"FULL_DOSE_DESCRIPTION" VARCHAR2(100),

"MED_NOTESEN" VARCHAR2(100),

"DUR_TYPE_EN" NUMBER(2,0),

"X2EN" VARCHAR2(10),

"INTERVAL_TYPE_EN" VARCHAR2(10),

"INTERVAL_TYPE" VARCHAR2(20),

"INTERVAL" NUMBER(8,2),

"X1EN" VARCHAR2(10),

"DOSE_TYPE_EN" NUMBER(3,0),

"DOSE_QTY" NUMBER(8,2),

"QTYX" NUMBER,

"LINE_NO" NUMBER(2,0),

"MY_DISC" NUMBER(7,2),

"MY_NET" NUMBER(8,2),

"MY_PRICE" NUMBER(8,2),

"PAYRATE" NUMBER(8,2),

"THE_COMP" NUMBER(8,2),

"THE_PAY" NUMBER(8,2),

"TRANSCATION_STATUS" VARCHAR2(2),

"OTHER_SALES_DTL_ROW_ID" NUMBER,

"ITEM_NOTES" VARCHAR2(25),

"UNIT_NAME" VARCHAR2(50),

"WEIGHT" NUMBER(10,3),

"WSDISC1" NUMBER(6,3),

"WSDISC2" NUMBER(6,3),

"WSDISC3" NUMBER(6,3),

"WSDISC4" NUMBER(6,3),

"UNIT2" VARCHAR2(2),

"UNIT2_FLAG" NUMBER,

"UNIT2_QTY" NUMBER(8,3),

"UNIT3" VARCHAR2(2),

"UNIT3_FLAG" NUMBER,

"UNIT3_QTY" NUMBER(8,3),

"APPROV_DATE" DATE,

"APPROV_REF_NO" VARCHAR2(20),

"APPROV_VALIDITY" NUMBER(3,0),

"REQ_NEED_A" NUMBER(1,0),

"THE_PAY_2" NUMBER(8,2),

"IS_EXPDATE" NUMBER(1,0),

"BOUNS_QTY2" NUMBER(8,3),

"CURR_QTY" NUMBER,

"CURR_QTY2" NUMBER,

"SYSTEM_QTY" NUMBER,

"SYSTEM_QTY2" NUMBER,

"C1" NUMBER(5,3),

"C2" NUMBER(7,3),

"SYS_STS8JLX$QKL1T1LCS6FT#I2A2K" NUMBER GENERATED ALWAYS AS (SYS_OP_COMBINED_HASH("INFO_CENTER_ID","THE_YEAR")) VIRTUAL,

"SYS_STSSMD66#268B06__VPUYOMA2M" NUMBER GENERATED ALWAYS AS (SYS_OP_COMBINED_HASH("INFO_CENTER_ID","ITEM_CODE")) VIRTUAL,

CONSTRAINT "TRANS_DTL_PK" PRIMARY KEY ("SALES_DTL_ROW_ID") ENABLE,

CONSTRAINT "TRANS_DTL_FK1" FOREIGN KEY ("ITEM_CODE")

REFERENCES "DAMMAM1"."ITEMS" ("ITEM_CODE") ENABLE

   )

 VIRTUAL COLUMNS ("SYS_STS0M2#S9K$STXC_LSNWTG0A9X" AS (SYS_OP_COMBINED_HASH("S_PRICE","INFO_CENTER_ID","INV_TYPE","ITEM_CODE","THE_YEAR","EXP_DATE","LIST_SEL_PRICE")),

"SYS_STS1OUYQCP0KKXN_MHD2MRSXXS" AS (SYS_OP_COMBINED_HASH("INFO_CENTER_ID","ITEM_CODE","THE_YEAR","EXP_DATE")),

"SYS_STSB166IJD0U9$8H$X_Y0YJLI#" AS (SYS_OP_COMBINED_HASH("INFO_CENTER_ID","THE_YEAR","EXP_DATE")),

"SYS_STS1RV88S3MW5AGLKBWHJ9AIQ2" AS (SYS_OP_COMBINED_HASH("S_PRICE","INFO_CENTER_ID","ITEM_CODE","THE_YEAR","EXP_DATE","BATCH_NO","LIST_SEL_PRICE")),

"SYS_STSRR09K5X3_F5ZG$BDB6$IFVL" AS (SYS_OP_COMBINED_HASH("ITEM_CODE","THE_YEAR")),

"SYS_STS5SM51$6TTVG_0$JCJTDDVYM" AS (SYS_OP_COMBINED_HASH("INV_TYPE","ITEM_CODE")),

"SYS_STS0RQPUNZUJHKZ6VBI5E#6ZNR" AS (SYS_OP_COMBINED_HASH("INFO_CENTER_ID","ITEM_CODE","THE_YEAR")),

"SYS_STSRFH$2X_IKDKRUQOZI#4Y6P#" AS (SYS_OP_COMBINED_HASH("INFO_CENTER_ID","ITEM_CODE","THE_YEAR","EXP_DATE","BATCH_NO")));