EBS：导入弹性域关键字的值（FND_FLEX_LOADER_APIS.up_value_set_value）

 

EBS R12.1 导入 弹性域 关键字的值

第一步：创建一个临时表 

?

1	CUX.CUX_FND_FLEX_VALUE_TEMP ，其表结构同 FND_FLEX_LOADER_APIS.up_value_set_value（） 过程的参数一致。 <br>导入临时表内容。<br><br>第二步： 执行导入FND_FLEX_LOADER_APIS.up_value_set_value过程程序<br>-- N: GL>>SETUP（设置）>>财务系统>>关键字>>值

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183

-- Created on 2022/10/21 by 44060 declare   -- Local variables here   i integer;    v_upload_phase                varchar2(150);    v_upload_mode                 varchar2(150);    v_custom_mode                 varchar2(150);    v_flex_value_set_name         varchar2(150);    v_parent_flex_value_low       varchar2(150);    v_flex_value                  varchar2(150);    v_owner                       varchar2(150);    v_last_update_date            varchar2(150);    v_enabled_flag                varchar2(150);    v_summary_flag                varchar2(150);    v_start_date_active           varchar2(150);    v_end_date_active             varchar2(150);    v_parent_flex_value_high      varchar2(150);    v_rolluv_flex_value_set_name  varchar2(150);    v_rolluv_hierarchy_code       varchar2(150);    v_hierarchy_level             varchar2(150);    v_compiled_value_attributes   varchar2(150);    v_value_category              varchar2(150);    v_attribute1                  varchar2(150);    v_attribute2                  varchar2(150);    v_attribute3                  varchar2(150);    v_attribute4                  varchar2(150);    v_attribute5                  varchar2(150);    v_attribute6                  varchar2(150);    v_attribute7                  varchar2(150);    v_attribute8                  varchar2(150);    v_attribute9                  varchar2(150);    v_attribute10                 varchar2(150);    v_attribute11                 varchar2(150);    v_attribute12                 varchar2(150);    v_attribute13                 varchar2(150);    v_attribute14                 varchar2(150);    v_attribute15                 varchar2(150);    v_attribute16                 varchar2(150);    v_attribute17                 varchar2(150);    v_attribute18                 varchar2(150);    v_attribute19                 varchar2(150);    v_attribute20                 varchar2(150);    v_attribute21                 varchar2(150);    v_attribute22                 varchar2(150);    v_attribute23                 varchar2(150);    v_attribute24                 varchar2(150);    v_attribute25                 varchar2(150);    v_attribute26                 varchar2(150);    v_attribute27                 varchar2(150);    v_attribute28                 varchar2(150);    v_attribute29                 varchar2(150);    v_attribute30                 varchar2(150);    v_attribute31                 varchar2(150);    v_attribute32                 varchar2(150);    v_attribute33                 varchar2(150);    v_attribute34                 varchar2(150);    v_attribute35                 varchar2(150);    v_attribute36                 varchar2(150);    v_attribute37                 varchar2(150);    v_attribute38                 varchar2(150);    v_attribute39                 varchar2(150);    v_attribute40                 varchar2(150);    v_attribute41                 varchar2(150);    v_attribute42                 varchar2(150);    v_attribute43                 varchar2(150);    v_attribute44                 varchar2(150);    v_attribute45                 varchar2(150);    v_attribute46                 varchar2(150);    v_attribute47                 varchar2(150);    v_attribute48                 varchar2(150);    v_attribute49                 varchar2(150);    v_attribute50                 varchar2(150);    v_flex_value_meaning          varchar2(150);    v_description                 varchar2(150);   cursor c1 is       select TMP.* from CUX.CUX_FND_FLEX_VALUE_TEMP  TMP    WHERE 1=1     AND  EXISTS ( SELECT 1 FROM FND_FLEX_VALUES_VL FFV      WHERE FFV.FLEX_VALUE_MEANING = TMP.FLEX_VALUE_MEANING       AND FFV.FLEX_VALUE_SET_ID = TMP.FLEX_VALUE_SET_ID       AND NVL(FFV.PARENT_FLEX_VALUE_LOW,'#') = NVL(TMP.PARENT_FLEX_VALUE_LOW,'#')       )     --  AND TMP.FLEX_VALUE ='611108'      AND TMP.FLEX_VALUE_SET_NAME NOT IN ('CUX_OTHER_PARTY')       ; begin   -- Test statements here   FOR R1 IN C1 LOOP    v_upload_phase := 'BEGIN';  -- 步骤    v_upload_mode :='';    v_custom_mode :='FORCE'; -- 强制    v_flex_value_set_name := R1.flex_value_set_name; --'CUX_SUBACC'; 关键字值集的名称=子科目   -- v_rolluv_flex_value_set_name := R1.rolluv_flex_value_set_name;    v_parent_flex_value_low := R1.parent_flex_value_low; -- 父值    v_flex_value := R1.flex_value;    v_owner :='IT01';  -- 用户         v_hierarchy_level := R1.hierarchy_level;    v_last_update_date := TO_CHAR(SYSDATE,'YYYY/MM/DD'); -- 格式： YYYY/MM/DD HH24:MI:SS    v_enabled_flag := R1.ENABLED_FLAG ; --  'Y';    v_summary_flag := R1.SUMMARY_FLAG;  -- 'N'    v_compiled_value_attributes := R1.compiled_value_attributes; -- 'Y'||CHR(10)||'Y';  -- 限定词：是 是    v_value_category := R1.value_category;    v_flex_value_meaning := R1.flex_value_meaning ; -- 一般与 v_flex_value 相同值    v_description := R1.DESCRIPTION; -- 描述         APPS.FND_FLEX_LOADER_APIS.up_value_set_value(    p_upload_phase                =>   v_upload_phase                ,    p_upload_mode                 =>   v_upload_mode                 ,    p_custom_mode                 =>   v_custom_mode                 ,    p_flex_value_set_name         =>   v_flex_value_set_name         ,    p_parent_flex_value_low       =>   v_parent_flex_value_low       ,    p_flex_value                  =>   v_flex_value                  ,    p_owner                       =>   v_owner                       ,    p_last_update_date            =>   v_last_update_date            ,    p_enabled_flag                =>   v_enabled_flag                ,    p_summary_flag                =>   v_summary_flag                ,    p_start_date_active           =>   v_start_date_active           ,    p_end_date_active             =>   v_end_date_active             ,    p_parent_flex_value_high      =>   v_parent_flex_value_high      ,    p_rollup_flex_value_set_name  =>   v_rolluv_flex_value_set_name  ,    p_rollup_hierarchy_code       =>   v_rolluv_hierarchy_code       ,    p_hierarchy_level             =>   v_hierarchy_level             ,    p_compiled_value_attributes   =>   v_compiled_value_attributes   ,    p_value_category              =>   v_value_category              ,    p_attribute1                  =>   v_attribute1                  ,    p_attribute2                  =>   v_attribute2                  ,    p_attribute3                  =>   v_attribute3                  ,    p_attribute4                  =>   v_attribute4                  ,    p_attribute5                  =>   v_attribute5                  ,    p_attribute6                  =>   v_attribute6                  ,    p_attribute7                  =>   v_attribute7                  ,    p_attribute8                  =>   v_attribute8                  ,    p_attribute9                  =>   v_attribute9                  ,    p_attribute10                 =>   v_attribute10                 ,    p_attribute11                 =>   v_attribute11                 ,    p_attribute12                 =>   v_attribute12                 ,    p_attribute13                 =>   v_attribute13                 ,    p_attribute14                 =>   v_attribute14                 ,    p_attribute15                 =>   v_attribute15                 ,    p_attribute16                 =>   v_attribute16                 ,    p_attribute17                 =>   v_attribute17                 ,    p_attribute18                 =>   v_attribute18                 ,    p_attribute19                 =>   v_attribute19                 ,    p_attribute20                 =>   v_attribute20                 ,    p_attribute21                 =>   v_attribute21                 ,    p_attribute22                 =>   v_attribute22                 ,    p_attribute23                 =>   v_attribute23                 ,    p_attribute24                 =>   v_attribute24                 ,    p_attribute25                 =>   v_attribute25                 ,    p_attribute26                 =>   v_attribute26                 ,    p_attribute27                 =>   v_attribute27                 ,    p_attribute28                 =>   v_attribute28                 ,    p_attribute29                 =>   v_attribute29                 ,    p_attribute30                 =>   v_attribute30                 ,    p_attribute31                 =>   v_attribute31                 ,    p_attribute32                 =>   v_attribute32                 ,    p_attribute33                 =>   v_attribute33                 ,    p_attribute34                 =>   v_attribute34                 ,    p_attribute35                 =>   v_attribute35                 ,    p_attribute36                 =>   v_attribute36                 ,    p_attribute37                 =>   v_attribute37                 ,    p_attribute38                 =>   v_attribute38                 ,    p_attribute39                 =>   v_attribute39                 ,    p_attribute40                 =>   v_attribute40                 ,    p_attribute41                 =>   v_attribute41                 ,    p_attribute42                 =>   v_attribute42                 ,    p_attribute43                 =>   v_attribute43                 ,    p_attribute44                 =>   v_attribute44                 ,    p_attribute45                 =>   v_attribute45                 ,    p_attribute46                 =>   v_attribute46                 ,    p_attribute47                 =>   v_attribute47                 ,    p_attribute48                 =>   v_attribute48                 ,    p_attribute49                 =>   v_attribute49                 ,    p_attribute50                 =>   v_attribute50                 ,    p_flex_value_meaning          =>   v_flex_value_meaning          ,    p_description                 =>   v_description                   );    --DBMS_OUTPUT.put_line('FLEX_VALUE = ' || R1.FLEX_VALUE);     DBMS_OUTPUT.put_line('PARENT_FLEX_VALUE= '|| v_parent_flex_value_low ||'; FLEX_VALUE = ' || V_FLEX_VALUE);   END LOOP;     end;

　　

另一个 导入 无限定词的值集的值

 

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38

-- Created on 2022/10/21 by 4060 declare   -- Local variables here   i integer;    v_flex_value_set_name         VARCHAR2(250);    v_parent_flex_value          VARCHAR2(250);    v_flex_value                 VARCHAR2(250);    v_description                VARCHAR2(250);    v_enabled_flag               VARCHAR2(2):='Y';    v_start_date_active          DATE;    v_end_date_active            DATE;    v_hierarchy_level            VARCHAR2(250);    v_storage_value              VARCHAR2(250); begin   -- 导入 从属值集值   --  说明性--> 值    v_flex_value_set_name   :='CUX_SUBACC';    v_parent_flex_value     :='239101';    v_flex_value            :='001';    v_description           :='水电费';    v_enabled_flag          :='Y';    v_start_date_active     :=NULL;    v_end_date_active       :=NULL;    v_hierarchy_level       :='';    v_storage_value         :='';        fnd_flex_val_api.create_dependent_vset_value   (p_flex_value_set_name   => v_flex_value_set_name,--    IN VARCHAR2,    p_parent_flex_value     => v_parent_flex_value,--    IN VARCHAR2,    p_flex_value            => v_flex_value,--    IN VARCHAR2,    p_description           => v_description,--    IN VARCHAR2 DEFAULT NULL,    p_enabled_flag          => v_enabled_flag,--    IN VARCHAR2 DEFAULT 'Y',    p_start_date_active     => v_start_date_active,--   IN DATE DEFAULT NULL,    p_end_date_active       => v_end_date_active ,--    IN DATE DEFAULT NULL,    p_hierarchy_level       => v_hierarchy_level,--     IN VARCHAR2 DEFAULT NULL,    x_storage_value         => v_storage_value --    OUT NOCOPY VARCHAR2    ); end;