1 Reply Latest reply on Mar 12, 2015 7:48 PM by rioman

    FRM-40212 invalid value for field FLEX VALUE_SET_NAME

    AjithPathiyil

      Hi,

       

      I am manually downloading value set from a source instance(R12.2.4) and uploading it in target instance (R12.1.4) using FNDLOAD command, But When querying the value set i receive "FRM-40212 invalid value for field FLEX VALUE_SET_NAME" message.

       

       

       

       

      1) Download command & Log

       

      ============================================================================================================

      $FND_TOP/bin/FNDLOAD apps/******** 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct MYVALUESET_values.ldt VALUE_SET_VALUE FLEX_VALUE_SET_NAME=MYVALUESET

       

      Log filename : L1165255.log


      cat L1165255.log

       

      +---------------------------------------------------------------------------+

       

      Application Object Library: Version : 12.2

       

      Copyright (c) 1998, 2013, Oracle and/or its affiliates. All rights reserved.

       

      FNDLOAD: Generic Loader

       

      +---------------------------------------------------------------------------+

       

      Current system time is 12-MAR-2015 06:38:44

       

      +---------------------------------------------------------------------------+

       

      Downloading VALUE_SET_VALUE to the data file MYVALUESET_values.ldt

       

      +---------------------------------------------------------------------------+

       

      Concurrent request completed successfully

       

      Current system time is 12-MAR-2015 06:38:44

       

      +---------------------------------------------------------------------------+

       

      ============================================================================================================

       

      2) Upload Command & Log

       

      ============================================================================================================

       

      $FND_TOP/bin/FNDLOAD apps/********** 0 Y UPLOAD $FND_TOP/patch/115/import/afffload.lct MYVALUESET_values.ldt -WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

       

      Log filename : L201710.log

       

      cat L201710.log

       

      +---------------------------------------------------------------------------+

       

      Application Object Library: Version : 12.2

       

      Copyright (c) 1998, 2013, Oracle and/or its affiliates. All rights reserved.

       

      FNDLOAD: Generic Loader

       

      +---------------------------------------------------------------------------+

       

      Current system time is 12-MAR-2015 06:43:53

       

      +---------------------------------------------------------------------------+

       

      Uploading from the data file MYVALUESET_values.ldt

       

      Altering database NLS_LANGUAGE environment to AMERICAN

       

      Dump from LCT/LDT files $FND_TOP/patch/115/import/afffload.lct(120.19.12020000.5), MYVALUESET_values.ldt) to stage tables

       

      Dump LCT file $FND_TOP/patch/115/import/afffload.lct(120.19.12020000.5) into FND_SEED_STAGE_CONFIG

       

      Dump LDT file MYVALUESET_values.ldt into FND_SEED_STAGE_ENTITY

       

      No data found for upload

       

      +---------------------------------------------------------------------------+

       

      Concurrent request completed successfully

       

      Current system time is 12-MAR-2015 06:43:53

       

      +---------------------------------------------------------------------------+

       

      Thanks in advance