Unable Post the Journa using "Posting" program from Back end
Hi
I am calling a Journal "Posting" program from PL/SQL then it is throwing a error message like 'No Journal to Process'.
Could you please suggest how to submit a Posting program from Back End.
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,
NULL,
FALSE,
2167,
1128,--to_char(gl_access_set.access_set_id),
I am calling a Journal "Posting" program from PL/SQL then it is throwing a error message like 'No Journal to Process'.
Could you please suggest how to submit a Posting program from Back End.
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,
NULL,
FALSE,
2167,
1128,--to_char(gl_access_set.access_set_id),
0