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 AUGUST 31, 2023

Applies to:

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.

Purchasing Documents Open Interface/Import Price Catalog also do 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
+---------------------------------------------------------------------------+

_______________________________________________________________________

Purchasing Document Open Interface/Import Price Catalog show these errors -

Concurrent Request Log:

POXPDOI: Import Price Catalogs
+---------------------------------------------------------------------------+

Current system time is 28-MAR-2022 16:25:17

+---------------------------------------------------------------------------+

[28-MAR-2022 16:25:17]: **Starts**
[28-MAR-2022 16:25:17]: **SQL error and free**
[28-MAR-2022 16:25:17]: ORACLE error 6510 in FDPSTP

Cause: FDPSTP failed due to ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "APPS.PO_PDOI_GRP", line 398
ORA-06512: at line 1

_______________________________________________________________________

FND Logging:

Start of subprogram.
End of subprogram.
Start of subprogram.
Start of subprogram.
;SQLERRM = ORA-01403: no data found
ORA-01403: no data found in Package po.plsql.PO_PDOI_PVT. Procedure init_sys_parameters.0;SQLERRM = ORA-01403: no data found
ORA-01403: no data found in Package po.plsql.PO_PDOI_PVT. Procedure init_startup_values.10;SQLERRM = ORA-01403: no data found
ORA-01403: no data found in Package po.plsql.PO_PDOI_PVT. Procedure start_process.50;SQLERRM = ORA-01403: no data found
Start of subprogram.
Start of subprogram.
Start of subprogram.
End of subprogram.
End of subprogram.
Timing Stat: PDOI_ALL-1: Start=16:25:17.796, End=16:25:17.805, Duration=+00 00:00:00.008985
End of subprogram.
x_return_status = U
User-Defined Exception in Package po.plsql.PO_PDOI_GRP. Procedure start_process.20;SQLERRM = User-Defined Exception
**SQL error and free**
"ORACLE error 6510 in FDPSTP

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.