EBS动态创建账户组合实现

最新推荐文章于 2023-05-18 10:27:23 发布

cunxiyuan108

最新推荐文章于 2023-05-18 10:27:23 发布

阅读量5.6k

点赞数

CC 4.0 BY-SA版权

分类专栏： EBS标准API应用 Oracle EBS 业务流程文章标签： flex books application validation gcc structure

本文链接：https://blog.youkuaiyun.com/cunxiyuan108/article/details/6006881

Oracle EBS 业务流程同时被 2 个专栏收录

24 篇文章

订阅专栏

EBS标准API应用

5 篇文章

订阅专栏

本文介绍了一种使用程序动态创建账户组合的方法。首先获取账簿的CHART_OF_ACCOUNTS_ID及账户弹性域分隔符，然后调用API获取账户组合ID。若ID为0，则创建失败。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

目的：使用程序动态创建账户组合。如果账户组合存在的话，返回存在的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：

--added by cxy 2010-11-12 begin 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，表示没有创建成功。

错误原因：传入的参数不正确或者账户组合没有通过验证。