Tuesday, July 19, 2011

APP-FND-00362: Routine afpbep cannot execute request &REQUEST for program &PROGRAM

Error:
=====

APP-FND-00362: Routine afpbep cannot execute request &REQUEST for program &PROGRAM, because the environment variable &BASEPATH is not set for the application
to which the concurrent program executable &EXECUTABLE belongs.
Shut down the concurrent managers. Set the basepath environment variable for the application. Restart the concurrent managers. (VARIABLE=)Routine AFPEOT cannot construct the name of an executable file for your concurrent request 6945444.
Check that the file name components are correct and valid on your system. Check that the environment for the person who started the concurrent manager

+Executing request completion options... -- 1) PUBLISH -------------+Beginning post-processing of request 6945444 on node TESTSERVER at 19-JUL-2011 15:23:24.Post-processing of request 6988838 failed at 19-JUL-2011 15:33:24 with the error message:The Output Post-processor is running but has not picked up this request. No further attempts will be made to post-process this request, and the request will be marked with Warning status.Setting the profile option Concurrent: OPP Response Timeout to a higher value may be necessary.+--------------------------------------+

Scenario:
=======

There is a Custom Top registered and that top is not set in the ENV while starting the conc.


Request Name :

XXTEST Daily Stock of PRODUCTS

Query to Check whether the Env is set for the Particular request :
===============================================

select variable_name,value from fnd_env_context e ,fnd_concurrent_processes p ,fnd_concurrent_requests r where p.concurrent_process_id =
e.concurrent_process_id and p.concurrent_process_id = r.controlling_manager and e.variable_name like '%CUSTOM_TOP%' and r.request_id = &request_id;

Solution :
=======


Add the respective Top in env file

ie) APPL_TOP/admin/adovars.env

so that while running autoconfig it wont remove every time.

XXTEST_TOP="/u01/apps/apps_st/appl/XXTEST/1.0.0" export XXTEST_TOP

Now Bounce the concurrent

Reference Note ID : 1050646.1

2 comments:

chaitanya Oracle DBA said...

After this, i am getting new error pls look into this...

Template code: XXFILIX_ON_HAND
Template app: XXCNS
Language: en
Territory: IN
Output type: EXCEL
[8/11/12 12:13:41 PM] [UNEXPECTED] [42790:RT21582073] java.io.FileNotFoundException: /oraapps/prodcomn/admin/out/TEST_dev/o21582073.out (No such file or directory (errno:2))
at java.io.FileInputStream.open(Native Method)
at java.io.FileInputStream.(FileInputStream.java:106)
at oracle.apps.fnd.cp.opp.XMLPublisherProcessor.process(XMLPublisherProcessor.java:215)
at oracle.apps.fnd.cp.opp.OPPRequestThread.run(OPPRequestThread.java:153)

Mohammed Imran said...

Thalaiva.. kalakitainga,,, HOOOO HOOO