The V_PROD_CODE Column Data Length Change From VARCHAR(20) To VARCHAR2(60) (Doc ID 3045598.1)

Last updated on SEPTEMBER 10, 2024

Applies to:

Goal

The product code [V_PRODUCT_CODE, V_PROD_CODE] with more than 20 characters from the source file. Currently, the data length for V_PROD_CODE is 20char.

Can we increase the data length from 20 to 60 characters for the V_PROD_CODE and V_PRODUCT_COLUMNS in all tables utilized by Insurance Allocation Manager [IAM] and Insurance Accounting Analyzer?

DIM_ACCOUNT V_PROD_CODE
DIM_FIXED_ASSETS V_PROD_CODE
DIM_POLICY V_PROD_CODE
DIM_POLICY_MLS V_PROD_CODE
DIM_PRODUCT V_PROD_CODE
DIM_PRODUCT_HIERARCHY V_PROD_CODE
DIM_PRODUCT_MLS V_PROD_CODE
DIM_PROD_DELINQ_STD V_PROD_CODE
DIM_REINS_PROGRESSIVE_SECTION V_PROD_CODE
DIM_RUN V_PROD_CODE
DIM_SOCIAL_MEDIA_POST V_PROD_CODE
DIM_UNDERLYING V_PROD_CODE
FCT_BANKRUPTCY V_PROD_CODE
FCT_GL_ADJUSTMENT_ENTRIES V_PROD_CODE
FCT_GL_CORRECTION_ENTRIES V_PROD_CODE
FCT_LLFP_OUTPUT V_PROD_CODE
FCT_RECONCILIATION_DIFFERENCE V_PROD_CODE
FCT_REINSURANCE_CNTRCTS_ISSUED V_PROD_CODE
FCT_REINSURANCE_CONTRACTS_HELD V_PROD_CODE
FSI_GL_THRESHOLD_BREACHES V_PROD_CODE
FSI_INS_GROUP_DIMENSION_MAP V_PRODUCT_CODE
FSI_PROD_STD_PROD_TYPE_MAP V_PROD_CODE
FSI_TMP_SOURCE_BALANCE V_PROD_CODE
FSI_TMP_TARGET_BALANCE V_PROD_CODE
OIDF_SET_UP_PRODUCT_PARAMETERS V_PROD_CODE
STG_ACCOUNTING_ENTRIES V_PROD_CODE
STG_ACCOUNT_CASH_FLOWS V_PROD_CODE
STG_ACCOUNT_POSITION_PAIR V_PROD_CODE
STG_ACCT_ENTRIES_AHCS_DISAGG V_PROD_CODE
STG_ACCT_FEATURE_MAP V_PROD_CODE
STG_ANNUITY_CONTRACTS V_PROD_CODE
STG_ANNUITY_TXNS_SUMMARY V_PROD_CODE
STG_APPLICATIONS V_PRODUCT_CODE
STG_ASSETS_SOLD V_PROD_CODE
STG_CAMPAIGN_PROFIT_MODEL V_PROD_CODE
STG_CAMPAIGN_PROSPECT V_PROD_CODE
STG_CAMPAIGN_SUMMARY V_PROD_CODE
STG_CAP_INSTR_TXNS V_PROD_CODE
STG_CLAIM_DETAILS V_PROD_CODE
STG_CLAIM_TXNS V_PROD_CODE
STG_COMMON_COA_MASTER V_PROD_CODE
STG_CREDIT_DERIVATIVES V_PROD_CODE
STG_CREDIT_LINES_TXNS_SUMMARY V_PROD_CODE
STG_CREDIT_LINE_DETAILS V_PROD_CODE
STG_CREDIT_LOSS V_PROD_CODE
STG_CREDIT_PARTCPN_DETAILS V_PROD_CODE
STG_CUSTODIAL_ACCOUNTS V_PROD_CODE
STG_CUSTOMER_PRODUCT_SCORE V_PROD_CODE
STG_CUSTSEG_PROD_LTV V_PROD_CODE
STG_DEP_BRRWNG_PARTCPN_DTLS V_PROD_CODE
STG_EXPOSURE_MASTER V_PROD_CODE
STG_FCAST_LIQUIDITY_BALANCES V_PRODUCT_CODE
STG_FIXED_ASSETS_MASTER V_PROD_CODE
STG_FORECAST_BALANCES V_PROD_CODE
STG_FORECAST_GL_DATA V_PROD_CODE
STG_FORWARDS V_PROD_CODE
STG_FUND_CIS_COMPOSITION V_PROD_CODE
STG_FUND_UNDERLYNG_COMPOSITION V_PROD_CODE
STG_FUTURES V_PRODUCT_CODE
STG_FX_CONTRACTS V_PRODUCT_CODE
STG_GL_ACCOUNTS V_PROD_CODE
STG_GL_DATA V_PROD_CODE
STG_HEALTH_INS_CONTRACTS V_PROD_CODE
STG_INSURANCE_QUOTES V_PROD_CODE
STG_INS_GROUP_DIMENSION_MAP V_PRODUCT_CODE
STG_INS_PRODUCT_DTLS V_PROD_CODE
STG_INT_OPERATIONAL_RISK_LOSS V_PROD_CODE
STG_INVESTMENTS V_PROD_CODE
STG_INVESTMENTS_V V_PROD_CODE
STG_INVESTMENT_TXNS_SUMMARY V_PROD_CODE
STG_LIFE_INS_CONTRACTS V_PROD_CODE
STG_LIFE_INS_POL_TXN_SUMMARY V_PROD_CODE
STG_LIF_INS_CONTRACTS V_PROD_CODE
STG_LOAN_CONTRACTS V_PROD_CODE
STG_LOAN_CONTRACT_TXNS_SUMMARY V_PROD_CODE
STG_MANAGED_INV_ADV V_PROD_CODE
STG_MANAGEMENT_LEDGER V_PROD_CODE
STG_MGMT_FORECAST V_PROD_CODE
STG_MM_CONTRACTS V_PROD_CODE
STG_MM_CONTRACT_TXNS_SUMMARY V_PROD_CODE
STG_MUTUAL_FUNDS V_PROD_CODE
STG_MUTUAL_FUNDS_TXNS V_PROD_CODE
STG_MUTUAL_FUNDS_TXNS_SUMMARY V_PROD_CODE
STG_NEW_BUSINESS_PLAN_DATA V_PROD_CODE
STG_NON_CONTRACTUAL_OBLIGS V_PROD_CODE
STG_OFFER_MASTER V_PROD_CODE
STG_OFFER_MASTER_MLS V_PROD_CODE
STG_OPPORTUNITY V_PROD_CODE
STG_OPPORTUNITY_ACTIVITY V_PROD_CODE
STG_OPPORTUNITY_MLS V_PROD_CODE
STG_OPTION_CONTRACTS V_PRODUCT_CODE
STG_OPTION_CONTRACTS_V V_PRODUCT_CODE
STG_PARTY_ACCOUNT_ROLE_MAP V_PROD_CODE
STG_PLACED_COLLATERAL V_PROD_CODE
STG_POLICY_COMMISSION_DETAILS V_PROD_CODE
STG_PPMT_CALC_PARAMS V_PRODUCT_CODE
STG_PRDCR_INS_DISTRBTION_DTLS V_PROD_CODE
STG_PRODUCER_CONTRACTS V_PROD_CODE
STG_PRODUCTS_B_INTF V_PROD_CODE
STG_PRODUCT_MASTER V_PROD_CODE
STG_PRODUCT_MASTER_MLS V_PROD_CODE
STG_PRODUCT_RIDER_DETAILS V_PROD_CODE
STG_PROP_CASUALTY_CONTRACTS V_PROD_CODE
STG_PROP_CAS_POL_TXN_SUMMARY V_PROD_CODE
STG_REINSURANCE_CNTRCTS_ISSUED V_PROD_CODE
STG_REINSURANCE_CONTRACTS_HELD V_PROD_CODE
STG_REINS_PROGR_SECTION_MASTER V_PROD_CODE
STG_REPO_CONTRACTS V_PROD_CODE
STG_RESPONSE V_PROD_CODE
STG_RETIREMENT_ACCOUNTS V_PROD_CODE
STG_RETIREMNT_ACT_TXNS_SUMMARY V_PROD_CODE
STG_RLA_ALLOC_FACTOR V_PROD_CODE
STG_RLA_GL_DATA_AHCS V_PROD_CODE

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.