How to submit the GL Journal Batch Posting(GLPPOSS) Program from Backend/Workflow/PL/SQL?
How to submit the GL Journal Batch Posting(GLPPOSS) Program from Backend/Workflow/PL/SQL?
Actually I am trying to run the below script but posting program says "PPOS0154: There are no batches to post - posting completed ". Posting: Single Ledger is completed with Warning.
DECLARE
L_REQUEST_ID NUMBER;
posting_run_id NUMBER;
BEGIN
Fnd_global.apps_initialize( user_id => 1396, resp_id => 50950, resp_appl_id => 101);
-- mo_global.init ('SQLGL');
mo_global.set_policy_context ('S', fnd_profile.VALUE ('ORG_ID'));
posting_run_id := GL_JE_POSTING_S.NEXTVAL;
L_REQUEST_ID:=fnd_request.submit_request(
'SQLGL',
'GLPPOSS',
NULL,
Actually I am trying to run the below script but posting program says "PPOS0154: There are no batches to post - posting completed ". Posting: Single Ledger is completed with Warning.
DECLARE
L_REQUEST_ID NUMBER;
posting_run_id NUMBER;
BEGIN
Fnd_global.apps_initialize( user_id => 1396, resp_id => 50950, resp_appl_id => 101);
-- mo_global.init ('SQLGL');
mo_global.set_policy_context ('S', fnd_profile.VALUE ('ORG_ID'));
posting_run_id := GL_JE_POSTING_S.NEXTVAL;
L_REQUEST_ID:=fnd_request.submit_request(
'SQLGL',
'GLPPOSS',
NULL,
0