The Requisition
Import Program is failing, while we are submitting from back end - but it has
failed from concurrent request submission as well.
Error:
POCIRM-001: ORA-01403: no data found
The issue is caused by the fnd loosing its org context or not having the org context set at all - meaning MO: Operating Unit - or MO: Security Profile are not setup.
If the concurrent request from the back end then add FND_REQUEST.SET_ORG_ID(ORG_ID) command.
fnd_global.APPS_INITIALIZE (l_user_id, l_resp_id, l_appl_id);
MO_GLOBAL.init('PO');
mo_global.set_policy_context('S',p_org_id);
FND_REQUEST.SET_ORG_ID(ORG_ID);
l_request_id :=
fnd_request.submit_request (application =>
'PO',
program => 'REQIMPORT',
description => 'Requisition Import',
start_time => SYSDATE,
sub_request => FALSE,
argument1 => 'ORDER ENTRY',
argument2 => l_req_batch_id,
argument3 => 'ALL',
argument4 => NULL,
argument5 => 'N',
argument6 => 'Y'
);