R12: Requisition Import and Purchasing Document Open Interface Do Not Select Records When Using fnd_request.submit_request

(Doc ID 1558416.1)

Last updated on APRIL 04, 2017

Applies to:

Oracle Purchasing - Version 12.1.3 and later
Information in this document applies to any platform.
POCIRM: Requisition Import
PDOI: Purchasing Document Open Interface

Symptoms

Requisition Import is failing with error messages POCIRM-001: ORA-01403: no data found when submitted from the custom concurrent program using fnd_request.submit_request API with the below parameters,
however, the Requisition Import with the same parameters is working fine when submitted from Standard Request Submission form.

PDOI also does not process records when submitted from the custom concurrent program using fnd_request.submit_request API

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

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

Requisition Import request Log:
+---------------------------------------------------------------------------+

Concurrent program POCIRM returned error

Cause: POCIRM encountered an internal error. Parameters: REQIMPORT,ORDER ENTRY,,ALL,,N,Y,

Action: Note both this error number and the actions you are trying to perform. Contact you
POCIRM-001: ORA-01403: no data found


Cause: A SQL error has occurred in POCIRM. The SQL error is &LSQL_ERR.

Action: Take note of both this error number and the actions you were
+---------------------------------------------------------------------------+

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms