I run this query :
SELECT COLUMN_NAME, UPDATABLE, insertable, deletable
FROM USER_UPDATABLE_COLUMNS
WHERE TABLE_NAME = 'wns_xtr_limits_v';
and remove all those column which are not updatble from my form after that also its throwing error of virtual column not allowed.
My view Query:
CREATE OR REPLACE FORCE EDITIONABLE VIEW "APPS"."WNS_XTR_LIMITS_V" (
"ROW_ID",
"LIMIT_ID",
"COMPANY_NAME",
"COMPANY_CODE",
"DEAL_TYPE",
"DEAL_TYPE_CODE",
"COUNTER_INTER",
"COUNTER_INTER_COMPANY_CODE",
"DEAL_SUBTYPE",
"DEAL_SUBTYPE_CODE",
"CURRENCY_CODE",
"LIMIT_CURRENCY",
"LIMIT_TYPE_CODE",
"LIMIT_TYPE_MEAN",
"LIMIT_CODE",
"EXCHANGE_RATE_TYPE",
"EXCHANGE_RATE_MEAN",
"AUTHORIZED_FLAG",
"AMOUNT",
"EXCEEDED_BY_AMOUNT",
"PARENT_GROUP",
"PARENT_GROUP_MEAN",
"DEALER",
"COMPANY_UTILIZED_AMOUNT",
"CPARTY_UTILIZED_AMOUNT",
"DEAL_TYPE_UTILIZED_AMOUNT",
"EXCEPTION_TYPE_CODE",
"CURRENCY_UTILIZED_AMOUNT",
"GROUP_UTILIZED_AMOUNT",
"DEALER_UTILIZED_AMOUNT",
"ATTRIBUTE1",
"ATTRIBUTE2",
"ATTRIBUTE3",
"ATTRIBUTE4",
"ATTRIBUTE5",
"ATTRIBUTE6",
"ATTRIBUTE7",
"ATTRIBUTE8",
"ATTRIBUTE9",
"ATTRIBUTE10",
"ATTRIBUTE11",
"ATTRIBUTE12",
"ATTRIBUTE13",
"ATTRIBUTE14",
"ATTRIBUTE15",
"CREATION_DATE",
"CREATED_BY",
"LAST_UPDATE_DATE",
"LAST_UPDATED_BY",
"LAST_UPDATE_LOGIN"
) AS
SELECT
wxl.rowid row_id,
wxl.limit_id,
(
SELECT
xpi.full_name
FROM
wns_xtr_party_info_b xpi
WHERE
xpi.party_type = 'C'
AND xpi.party_code = wxl.company_code
) company_name,
wxl.company_code,
(
SELECT
v.flex_value_meaning
FROM
fnd_flex_value_sets s,
fnd_flex_values_vl v
WHERE
flex_value_set_name = 'WNS_XTR_DEAL_TYPES'
AND s.flex_value_set_id = v.flex_value_set_id
AND v.enabled_flag = 'Y'
AND v.description = wxl.deal_type_code
) deal_type,
wxl.deal_type_code,
(
SELECT
xpi.full_name
FROM
wns_xtr_party_info_b xpi
WHERE
xpi.party_code = counter_inter_company_code
) counter_inter,
wxl.counter_inter_company_code,
(
SELECT
v.description tag
FROM
fnd_flex_value_sets s,
fnd_flex_values_vl v
WHERE
flex_value_set_name = 'WNS_XTR_DEAL_SUBTYPES'
AND s.flex_value_set_id = v.flex_value_set_id
AND v.enabled_flag = 'Y'
AND v.flex_value_meaning = wxl.deal_subtype_code
) deal_subtype,
wxl.deal_subtype_code,
wxl.currency_code,
wxl.limit_currency,
wxl.limit_type_code,
(
SELECT
meaning
FROM
fnd_lookup_values_vl
WHERE
lookup_type = 'WNS_XTR_LIMIT_TYPES'
AND lookup_code = wxl.limit_type_code
) limit_type_mean,
wxl.limit_code,
wxl.exchange_rate_type,
(
SELECT
user_conversion_type
FROM
gl_daily_conversion_types
WHERE
conversion_type = wxl.exchange_rate_type
) exchange_rate_mean,
wxl.authorized_flag,
wxl.amount,
wxl.exceeded_by_amount,
wxl.parent_group,
(
SELECT
description
FROM
fnd_lookup_values_vl
WHERE
lookup_type = 'WNS_XTR_CP_PARENT_GROUP'
AND meaning = wxl.parent_group
) parent_group_mean,
wxl.dealer, -- dealer code of the dealer
wxl.company_utilized_amount,
wxl.cparty_utilized_amount,
wxl.deal_type_utilized_amount,
wxl.exception_type_code,
wxl.currency_utilized_amount,
wxl.group_utilized_amount,
wxl.dealer_utilized_amount,
wxl.attribute1,
wxl.attribute2,
wxl.attribute3,
wxl.attribute4,
wxl.attribute5,
wxl.attribute6,
wxl.attribute7,
wxl.attribute8,
wxl.attribute9,
wxl.attribute10,
wxl.attribute11,
wxl.attribute12,
wxl.attribute13,
wxl.attribute14,
wxl.attribute15,
wxl.creation_date,
wxl.created_by,
wxl.last_update_date,
wxl.last_updated_by,
wxl.last_update_login
FROM
wns_xtr_limits wxl
ORDER BY
wxl.company_code,
wxl.deal_type_code;