目的：使用程序动态创建账户组合。如果账户组合存在的话，返回存在的id，不存在的话就动态创建账户组合并返回id。 实现步骤： 1. 得到账簿的chart_of_accounts_id 2. 得到账户弹性域分隔符 3. 调用标准的api得到账户组合id 具体实现如下： 1. 得到账簿的char
目的：使用程序动态创建账户组合。如果账户组合存在的话，返回存在的id，不存在的话就动态创建账户组合并返回id。
实现步骤：
1. 得到账簿的chart_of_accounts_id
2. 得到账户弹性域分隔符
3. 调用标准的api得到账户组合id
具体实现如下：
1. 得到账簿的chart_of_accounts_id实现code：
select sob.chart_of_accounts_id into l_id_flex_num from financials_system_params_all fsp, gl_sets_of_books sob where org_id = p_org_id and sob.set_of_books_id = fsp.set_of_books_id;
2. 得到账户弹性域分隔符实现code：
select concatenated_segment_delimiter into l_segment_delimiter from fnd_id_flex_structures where application_id = 101 and id_flex_code = 'gl#' and id_flex_num = l_id_flex_num;
3. 调用标准的api得到账户组合id实现code：
l_concatenated_segments := l_segment1 || l_segment_delimiter || p_segment2 || l_segment_delimiter || p_segment3 || l_segment_delimiter || l_segment4 || l_segment_delimiter || l_segment5 || l_segment_delimiter || l_segment6 || l_segment_delimiter || l_segment7 || l_segment_delimiter || l_segment8 || l_segment_delimiter || l_segment9 || l_segment_delimiter || l_segment10 || l_segment_delimiter || l_segment11 || l_segment_delimiter || l_segment12 || l_segment_delimiter || l_segment13 || l_segment_delimiter || l_segment14 || l_segment_delimiter || l_segment15 || l_segment_delimiter || l_segment16 || l_segment_delimiter || l_segment17 || l_segment_delimiter || l_segment18 || l_segment_delimiter || l_segment19 || l_segment_delimiter || l_segment20 || l_segment_delimiter || l_segment21 || l_segment_delimiter || l_segment22 || l_segment_delimiter || l_segment23 || l_segment_delimiter || l_segment24 || l_segment_delimiter || l_segment25 || l_segment_delimiter || l_segment26 || l_segment_delimiter || l_segment27 || l_segment_delimiter || l_segment28 || l_segment_delimiter || l_segment29 || l_segment_delimiter || l_segment30 || l_segment_delimiter; l_gcc_account_id := apps.fnd_flex_ext.get_ccid(application_short_name => 'sqlgl', key_flex_code => 'gl#', structure_number => l_id_flex_num, validation_date => to_char(sysdate, apps.fnd_flex_ext.date_format), concatenated_segments => x_concatenated_seg); fnd_file.put_line(fnd_file.log, 'l_gcc_account_id:' || l_gcc_account_id); if l_gcc_account_id = 0 then return null; end if;
注意 ：如果账户id返回0，表示没有创建成功。错误原因：传入的参数不正确或者账户组合没有通过验证。