Oracle系统GL打印凭证,EBS GL 凭证相关功能

过账

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

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');