ITPub博客

首页 > 数据库 > Oracle > EBS GL 凭证相关功能

EBS GL 凭证相关功能

原创 Oracle 作者:chenshm329 时间:2019-01-10 14:27:06 0 删除 编辑

过账

     过账只能按批过账,不能按凭证过账

     Oracle® General Ledger User's Guide Release 12.1 Part No. E13627-04->1-188 Posting Journal Batches

      Posting single ledger is used to post the batch which has journals of single ledger, so executable GLPPOSS is called with ledger_id parameter.
      Posting is used to post the batch of journals of multiple ledgers, so executable GLPPOS is called with ledger_id parameter -99.

The ledger_id parameters are passed from the journals enter form .


以下摘录至官方文档ID 1995324.1

Case4: Incomplete Custom Codes:

It is learnt that in some cases, users submit posting program(GLPPOS) using a custom program/custom code. While this is not supported normally, it is suggested to please ensure that Column REQUEST_ID of Table GL_JE_BATCHES is updated with the right value as soon as the Posting program is submitted.
Below sample code shows on how to update REQUEST_ID column of GL_JE_BATCHES table after posting program is submitted.

 

v_request_id := fnd_request.submit_request( 'SQLGL', 'GLPPOSS', '', '', FALSE, To_Char(v_single_ledger_id), To_Char(X_access_set_id), To_Char(v_chart_of_accounts_id), To_Char(v_posting_run_id), 
chr(0), '','','','','','','','','','','','','','','','','','','','', '','','','','','','','','','','','','','','','','','','','', 
'','','','','','','','','','','','','','','','','','','','', '','','','','','','','','','','','','','','','','','','','', '','','','','','','','','','','','','','','');


UPDATE GL_JE_BATCHES

B SET B.request_id = v_request_id

WHERE B.je_batch_id IN (SELECT je_batch_id FROM gl_je_batches WHERE posting_run_id = v_posting_run_id AND status = 'S');

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/17087603/viewspace-2375406/,如需转载,请注明出处,否则将追究法律责任。

上一篇: EBS客户创建
请登录后发表评论 登录
全部评论

注册时间:2009-08-09

  • 博文量
    177
  • 访问量
    98651