Procurement application POCIRM-001: ORA-01403: No data found

My colleague asked me to check the problem. An error was reported when I submitted a purchase order in the sales module to generate a purchase order.

View request logs

+ --------------------------------------------------------------------------- + Procurement management system: Version: 12.0.0copyright (c) 1979,199 9, Oracle Corporation. all rights reserved. reqimport module: Import Application + pipeline + current system time: 12:42:35 + pipeline + concurrent program pocirm returned error cause: pocirm encountered internal Error. Parameter: reqimport, order entry auto, all, N, Y. Measure: record the error number and the activity you are trying. Contact the system administrator for help. POCIRM-001: ORA-01403: No data reason found: SQL error in pocirm. The SQL error is & lsql_err. Measure: record the error number and the activity you are trying. Contact the system administrator for more help. + Begin + PLSQL program log information start + begin + end of PLSQL program log information + begin ++ -------------------------------------------------------------- ------------- + Execution request completion option... output file size: 0: the output file is not printed, because: the print option of this report has been disabled. Completed execution request completion option. + The current system time for completed concurrent requests is 08-08-2014 12:42:35 + --------------------------------------------------------------------------------- +

The analysis found that no data was found in the standard request "Import Application". After reading this, the data has been written to the interface table, and there are no problems with the request parameters, ou, and so on. The guess is that the request should be submitted under the sales responsibility. It is estimated that no init is Po, so the data security control cannot be married. Add the following at the beginning of the program:

-- Add by Xingyun. cai @ hand -- when a request is submitted under Mo's responsibility, it must be set to mo_global.init ('po') under po; mo_global.set_policy_context ('s ', p_org_id); fnd_request.set_org_id (p_org_id );

Resubmit request

Normal completion. Problem Solving