Wednesday 12 February 2020

Concurrent program POCIRM returned error ( POCIRM-001: ORA-01403: no data found)


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


No comments:

Post a Comment