ITExperts4u Blog’s

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

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.
XXQN_TOP="//ebsdev/devappl/cus/11.5.0" export XXQN_TOP
Now Bounce the concurrent
Reference Note ID : 1050646.1

The following is the solution .

The spfile parameter LOG_ARCHIVE_DEST was set to LOG_ARCHIVE_DEST=” !
So "SHOW PARAMETER" is showing nothing but in the spfile you can see the difference!
ALTER SYSTEM RESET LOG_ARCHIVE_DEST SCOPE=BOTH SID=’*';

or

Change in init.ora

I hit the error below during startup of my 10.2.0.4  installation running on Solaris 64 on

ORA-00600: internal error code, arguments: [kcratr1_lastbwr], [], [], [], [],[], [], []

Basically none of the instances start-up with srvctl command and log this error to alert log.

Tried to run manual startup of instances but no chance same error.

Quick search on MOS (yes it was working ) take me to the note 393984.1 (no bug number)

It says this is a bug on Enterprise Edition – Version: 10.2.0.1 to 11.1.0.6.0

Solution is manual recovery.

SQL> startup;
        ORACLE instance started.

Total System Global Area  369098752 bytes
Fixed Size                  2020864 bytes
Variable Size             138414592 bytes
Database Buffers          226492416 bytes
Redo Buffers                2170880 bytes
Database mounted.
ORA-00600: internal error code, arguments: [kcratr1_lastbwr], [], [], [], [],
[], [], []

SQL> recover database;
Media recovery complete.
SQL> alter database open;

Database altered.