EBS GL 凭证相关功能

来源：这里教程网时间：2026-03-03 12:50:38 作者：

过账 过账只能按批过账，不能按凭证过账 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');