31 March 2017

Relink of module "UMX_ENDECA_RBACMigration.sh" failed

Relink of module "UMX_ENDECA_RBACMigration.sh" failed

Error:

Relink of module "UMX_ENDECA_RBACAuto.sh" failed.
See error messages above (also recorded in log file) for possible
reasons for the failure.  Also, please check that the Unix userid
running adrelink has read, write, and execute permissions
on the directory /u03/appltest/apps/apps_st/appl/fnd/12.0.0/bin,
and that there is sufficient space remaining on the disk partition
containing your Oracle Applications installation.

Relink of module "UMX_ENDECA_RBACMigration.sh" failed.
See error messages above (also recorded in log file) for possible
reasons for the failure.  Also, please check that the Unix userid
running adrelink has read, write, and execute permissions
on the directory /u03/appltest/apps/apps_st/appl/fnd/12.0.0/bin,
and that there is sufficient space remaining on the disk partition
containing your Oracle Applications installation.

Cause: above files are missing.

$ ls $FND_TOP/bin/UMX_ENDECA_RBACAuto.sh
ls: 0653-341 The file /u03/appltest/apps/apps_st/appl/fnd/12.0.0/bin/UMX_ENDECA_RBACAuto.sh does not exist.
$ ls $FND_TOP/bin/UMX_ENDECA_RBACMigration.sh
ls: 0653-341 The file /u03/appltest/apps/apps_st/appl/fnd/12.0.0/bin/UMX_ENDECA_RBACMigration.sh does not exist.

Solution:

Apply Patch 17797381 on your test instance then execute relink.

$ ls $FND_TOP/bin/UMX_ENDECA_RBACAuto.sh
/u03/appltest/apps/apps_st/appl/fnd/12.0.0/bin/UMX_ENDECA_RBACAuto.sh
$ ls $FND_TOP/bin/UMX_ENDECA_RBACMigration.sh
/u03/appltest/apps/apps_st/appl/fnd/12.0.0/bin/UMX_ENDECA_RBACMigration.sh
$

Reference: Relink Fails On 12.1.3+ With "UMX_ENDECA_RBACMigration.sh" & "UMX_ENDECA_RBACAuto.sh" (Doc ID 1680871.1)

23 March 2017

Step by Step to change all FND_USER password using Pl/sql

Step by Step to change all  FND_USER  password without old password using pl/sql

 DECLARE
   x   BOOLEAN;
   CURSOR c_user
   IS
      SELECT *
  FROM fnd_user
 WHERE     NVL (end_date, SYSDATE + 1) > SYSDATE
       AND user_name NOT IN
              ('ANONYMOUS',
               'AUTOINSTALL',
               'CONCURRENT MANAGER',
               'FEEDER SYSTEM',
               'GUEST',
               'INITIAL SETUP',
               'APPSMGR',
               'SYSADMIN',
               'WIZARD',
               'IEXADMIN',
               'ASGADM',
               'MOBILEADM',
               'IBE_GUEST',
               'OP_SYSADMIN',
               'OP_CUST_CARE_ADMIN',
               'PORTAL30',
               'PORTAL30_SSO',
               'ASGUEST',
               'IBE_ADMIN',
               'IBEGUEST',
               'IRC_EXT_GUEST',
               'IRC_EMP_GUEST',
               'INDUSTRY DATA',
               'ASADMIN',
               'XML_USER',
               'ORACLE12.0.0',
               'ORACLE12.1.0',
               'ORACLE12.2.0',
               'ORACLE12.3.0',
               'ORACLE12.4.0',
               'ORACLE12.5.0',
               'ORACLE12.6.0',
               'ORACLE12.7.0',
               'ORACLE12.8.0',
               'ORACLE12.9.0',
               'AME_INVALID_APPROVER');
BEGIN
   FOR i IN c_user
   LOOP
      BEGIN
         x  := fnd_user_pkg.ChangePassword ( username      => i.user_name,
                                             newpassword   => 'welcome'   );
                                            
      --  dbms_output.put_line('password sucessfully changed for' || i.user_name);
      EXCEPTION
         WHEN OTHERS THEN
        DBMS_OUTPUT.put_line ( 'Error encountered while restting password for users and the Error Detail is ' || SQLERRM);
      END;
   END LOOP;
END;

07 February 2017

Compile JSP in Oracle Application R12

1. Login with application unix user and source the environment

. <APPL_TOP>/APPS<@TWO_TASK>_<Hostname>.env

2. Unix based Plateforms

$ perl $FND_TOP/patch/115/bin/ojspCompile.pl --compile --flush -p 2
logfile set: /u03/appltest/inst/apps/$TWO_TASK_hostname/logs/appl/rgf/ojsp/ojspc_error.log
starting...(compiling all)
using 10i internal ojsp ver: 10
synchronizing dependency file:
  loading deplist...8096
  enumerating jsps...8096
  updating dependency...0
initializing compilation:
  eliminating children...6025 (-2071)
translating and compiling:
  translating jsps...6025/6025 in 3m2s
  compiling jsps...6025/6025 in 12m43s
Finished!

3. Restart the apache services.

$ cd $ADMIN_SCRIPTS_HOME
$ ./adopmnctl.sh stopall

You are running adopmnctl.sh version 120.6.12010000.5


adopmnctl.sh: exiting with status 0

adopmnctl.sh: check the logfile /u03/appltest/inst/apps/$TWO_TASK_hostname/logs/appl/admin/log/adopmnctl.txt for more information ...

$ ./adopmnctl.sh startall

You are running adopmnctl.sh version 120.6.12010000.5

Starting Apache...
Apache started successfully.


Starting OACORE oc4j...
OACORE oc4j started successfully.


Starting FORMS oc4j...
FORMS oc4j started successfully.


Starting OAFM oc4j...
OAFM oc4j started successfully.



adopmnctl.sh: exiting with status 0

adopmnctl.sh: check the logfile /u03/appltest/inst/apps/FMSTEST_fmdevap/logs/appl/admin/log/adopmnctl.txt for more information ...

$

27 January 2017

Unable to locate 'linkxlC' utility in path


$ adcfgclone.pl dbTechStack
                     Copyright (c) 2002 Oracle Corporation
                        Redwood Shores, California, USA
                        Oracle Applications Rapid Clone
                                 Version 12.0.0
                      adcfgclone Version 120.31.12010000.8
Enter the APPS password :
no linkxlC in /u01/oradev/fmsdevdb/11.2.0/appsutil/clone/bin/../jre/bin /usr/bin /etc /usr/sbin /usr/ucb /home/oradev/bin /usr/bin/X11 /sbin /u01/oradev/fmsdevdb/11.2.0/bin .
Checking for make...    found - /usr/bin/make
 Checking for ld...     found - /usr/bin/ld
 Checking for linkxlC...
 Unable to locate 'linkxlC' utility in path
 Checking for ar...     found - /usr/bin/ar
 Unable to locate all utilities with system path.
 PATH = /u01/oradev/fmsdevdb/11.2.0/appsutil/clone/bin/../jre/bin:/usr/bin:/etc:/usr/sbin:/usr/ucb:/home/oradev/bin:/usr/bin/X11:/sbin:/u01/oradev/fmsdevdb/11.2.0/bin:.

WARNING: Could not find all the required OS utilities in the $PATH. Please review the checks above
$

Solution :-

$ which linkxlC
/usr/vacpp/bin/linkxlC
$ export PATH=/usr/vacpp/bin:$PATH
$ adcfgclone.pl dbTechStack
                     Copyright (c) 2002 Oracle Corporation
                        Redwood Shores, California, USA
                        Oracle Applications Rapid Clone
                                 Version 12.0.0
                      adcfgclone Version 120.31.12010000.8
Enter the APPS password :
Running:
/u01/oradev/fmsdevdb/11.2.0/appsutil/clone/bin/../jre/bin/java -Xmx600M -cp /u01/oradev/fmsdevdb/11.2.0/appsutil/clone/jlib/java:/u01/oradev/fmsdevdb/11.2.0/appsutil/clone/jlib/xmlparserv2.jar:/u01/oradev/fmsdevdb/11.2.0/appsutil/clone/jlib/ojdbc5.jar oracle.apps.ad.context.CloneContext -e /u01/oradev/fmsdevdb/11.2.0/appsutil/clone/bin/../context/db/CTXORIG.xml -validate -pairsfile /tmp/adpairsfile_44171378.lst -stage /u01/oradev/fmsdevdb/11.2.0/appsutil/clone -dbTechStack 2> /tmp/adcfgclone_44171378.err; echo $? > /tmp/adcfgclone_44171378.res
Log file located at /u01/oradev/fmsdevdb/11.2.0/appsutil/clone/bin/CloneContext_0127105900.log
Provide the values required for creation of the new Database Context file.
Target System Hostname (virtual or normal) [fmdevdb] :
 

26 January 2017

REP-50125: Caught exception: java.lang.reflect.InvocationTargetException

When submitting concurrent requests they run for a very long time will not compete You are forced to kill the request.

Error: -

$ rwdiag.sh -findAll
Environment:Environment java.lang.UnsatisfiedLinkError: Can't find library rwu  (librwu.a or .so) in sun.boot.library.path or java.library.path
sun.boot.library.path=/u02/applgstR12/apps/tech_st/10.1.2/jdk/jre/bin
java.library.path=/u02/applgstR12/apps/tech_st/10.1.2/jdk/bin:/u02/applgstR12/apps/tech_st/10.1.2/jdk/jre/bin/classic:/u02/applgstR12/apps/tech_st/10.1.2/jdk/jre/bin:/u02/applgstR12/apps/tech_st/10.1.2/jdk/jre/bin:/u02/applgstR12/apps/tech_st/10.1.2/jdk/jre/bin/classic:/u02/applgstR12/apps/tech_st/10.1.2/lib32:/u02/applgstR12/apps/tech_st/10.1.2/lib:/usr/dt/lib:/u02/applgstR12/apps/tech_st/10.1.2/jdk/jre/bin:/u02/applgstR12/apps/tech_st/10.1.2/jdk/jre/bin/classic:/u02/applgstR12/apps/apps_st/appl/cz/12.0.0/bin:/u02/applgstR12/apps/tech_st/10.1.2/lib32:/u02/applgstR12/apps/tech_st/10.1.2/lib:/usr/dt/lib:/u02/applgstR12/apps/tech_st/10.1.2/jdk/jre/bin:/u02/applgstR12/apps/tech_st/10.1.2/jdk/jre/bin/classic:/u02/applgstR12/apps/apps_st/appl/sht/12.0.0/lib:/u02/applgstR12/apps/tech_st/10.1.2/jdk/jre/lib/ppc:/u02/applgstR12/apps/tech_st/10.1.2/jdk/jre/bin/sovvm:/usr/lib
Environment:getEnvironmentStrings java.lang.UnsatisfiedLinkError: Can't find library rwu  (librwu.a or .so) in sun.boot.library.path or java.library.path
sun.boot.library.path=/u02/applgstR12/apps/tech_st/10.1.2/jdk/jre/bin
java.library.path=/u02/applgstR12/apps/tech_st/10.1.2/jdk/bin:/u02/applgstR12/apps/tech_st/10.1.2/jdk/jre/bin/classic:/u02/applgstR12/apps/tech_st/10.1.2/jdk/jre/bin:/u02/applgstR12/apps/tech_st/10.1.2/jdk/jre/bin:/u02/applgstR12/apps/tech_st/10.1.2/jdk/jre/bin/classic:/u02/applgstR12/apps/tech_st/10.1.2/lib32:/u02/applgstR12/apps/tech_st/10.1.2/lib:/usr/dt/lib:/u02/applgstR12/apps/tech_st/10.1.2/jdk/jre/bin:/u02/applgstR12/apps/tech_st/10.1.2/jdk/jre/bin/classic:/u02/applgstR12/apps/apps_st/appl/cz/12.0.0/bin:/u02/applgstR12/apps/tech_st/10.1.2/lib32:/u02/applgstR12/apps/tech_st/10.1.2/lib:/usr/dt/lib:/u02/applgstR12/apps/tech_st/10.1.2/jdk/jre/bin:/u02/applgstR12/apps/tech_st/10.1.2/jdk/jre/bin/classic:/u02/applgstR12/apps/apps_st/appl/sht/12.0.0/lib:/u02/applgstR12/apps/tech_st/10.1.2/jdk/jre/lib/ppc:/u02/applgstR12/apps/tech_st/10.1.2/jdk/jre/bin/sovvm:/usr/lib
java.lang.reflect.InvocationTargetException
oracle.reports.RWException: IDL:oracle/reports/RWException:1.0

Broadcast mechanism used to locate servers
------------------------------------------
Channel address = 228.5.6.7
Channel port    = 14021

REP-50503 No server found in the network

$ rwrun help=yes
JVMCI200 - ERROR: User register saving is not enabled, Garbage Collection could be incorrect.
JVMCI200 - ERROR: because of this the JVM library is explicitly aborting the process
JVMCI200 - ERROR: You must either rebuild the executable using "-bM:UR"
JVMCI200 - ERROR: or run with "export LDR_CNTRL=USERREGS"
IOT/Abort trap(coredump)

$ $INST_TOP/ora/10.1.2/bin/appsrwrun.sh userid=apps/apps mode=character report=$FND_TOP/reports/US/FNDSCURS.rdf batch=yes destype=file desname=./ddr2.out desformat=$FND_TOP/reports/HPL pagesize=132x66 traceopts=trace_all tracefile=ddr2.trc tracemode=trace_replace
Environment:Environment java.lang.UnsatisfiedLinkError: Can't find library rwu  (librwu.a or .so) in sun.boot.library.path or java.library.path
sun.boot.library.path=/u02/applgstR12/apps/tech_st/10.1.2/jdk/jre/bin
java.library.path=/u02/applgstR12/apps/tech_st/10.1.2/jdk/jre/bin:/u02/applgstR12/apps/tech_st/10.1.2/jdk/jre/bin/classic:/u02/applgstR12/apps/tech_st/10.1.2/lib32:/u02/applgstR12/apps/tech_st/10.1.2/lib:/usr/dt/lib:/u02/applgstR12/apps/tech_st/10.1.2/jdk/jre/bin:/u02/applgstR12/apps/tech_st/10.1.2/jdk/jre/bin/classic:/u02/applgstR12/apps/apps_st/appl/cz/12.0.0/bin:/u02/applgstR12/apps/tech_st/10.1.2/lib32:/u02/applgstR12/apps/tech_st/10.1.2/lib:/usr/dt/lib:/u02/applgstR12/apps/tech_st/10.1.2/jdk/jre/bin:/u02/applgstR12/apps/tech_st/10.1.2/jdk/jre/bin/classic:/u02/applgstR12/apps/apps_st/appl/sht/12.0.0/lib:/u02/applgstR12/apps/tech_st/10.1.2/jdk/jre/lib/ppc:/u02/applgstR12/apps/tech_st/10.1.2/jdk/jre/bin/sovvm:/usr/lib
Environment:getEnvironmentStrings java.lang.UnsatisfiedLinkError: Can't find library rwu  (librwu.a or .so) in sun.boot.library.path or java.library.path
sun.boot.library.path=/u02/applgstR12/apps/tech_st/10.1.2/jdk/jre/bin
java.library.path=/u02/applgstR12/apps/tech_st/10.1.2/jdk/jre/bin:/u02/applgstR12/apps/tech_st/10.1.2/jdk/jre/bin/classic:/u02/applgstR12/apps/tech_st/10.1.2/lib32:/u02/applgstR12/apps/tech_st/10.1.2/lib:/usr/dt/lib:/u02/applgstR12/apps/tech_st/10.1.2/jdk/jre/bin:/u02/applgstR12/apps/tech_st/10.1.2/jdk/jre/bin/classic:/u02/applgstR12/apps/apps_st/appl/cz/12.0.0/bin:/u02/applgstR12/apps/tech_st/10.1.2/lib32:/u02/applgstR12/apps/tech_st/10.1.2/lib:/usr/dt/lib:/u02/applgstR12/apps/tech_st/10.1.2/jdk/jre/bin:/u02/applgstR12/apps/tech_st/10.1.2/jdk/jre/bin/classic:/u02/applgstR12/apps/apps_st/appl/sht/12.0.0/lib:/u02/applgstR12/apps/tech_st/10.1.2/jdk/jre/lib/ppc:/u02/applgstR12/apps/tech_st/10.1.2/jdk/jre/bin/sovvm:/usr/lib
REP-50125: Caught exception: java.lang.reflect.InvocationTargetException


Solution :

1. Take a backup and remove rwnetwork.conf from $ORACLE_HOME/reports/conf

  $ mv rwnetwork.conf rwnetwork.conf_orig

 2. Stop/restart Applications tier.

 3. You need to ensure rwnetwork.conf is created on its own. As rwnetwork.conf is removed , the system should generate new file automatically after the reports are run.

 4.Reproduce the issue and check the following commands work fine to ensure the issue is resolved.
 a) rwdiag.sh -findAll
 b) rwrun help=yes
 c) $INST_TOP/ora/10.1.2/bin/appsrwrun.sh userid=apps/apps mode=character report=$FND_TOP/reports/US/FNDSCURS.rdf batch=yes destype=file   desname=./ddr2.out desformat=$FND_TOP/reports/HPL pagesize=132x66 traceopts=trace_all tracefile=ddr2.trc tracemode=trace_replace

 5.Run the Concurrent Request

Reference : Concurrent Processing - R12 Concurrent Requests Run Forever, rwrun Errors with REP-50125 (Doc ID 737445.1)

If not resolved Follow below steps.

2. Relink the reports executables:

cd $ORACLE_HOME/reports/lib32
make -f ins_reports.mk install

Reference : Concurrent Reports UnsatisfiedLinkError (Doc ID 849369.1)

24 January 2017

R12 Error 'Function not available to this responsibility' When Trying to Access Custom Form

R12 Error 'Function not available to this responsibility' When Trying to Access Custom Form


The issue is caused by the following setup:

Missing entry for CUSTOM_TOP under default.env file

Ideally in such cases,CUSTOM_TOP should be defined under default.env in $INST_TOP/ora/10.1.2/forms/server directory to have your custom form work with R12.

Solution:-

To implement the solution, please execute the following steps:

1. Login to server with APPLMGR manager user access.

2. Go to $INST_TOP/ora/10.1.2/forms/server directory.

3. Ensure that your CUSTOM_TOP 's are registered in the default.env file.

This means that, you should create an entry for environment variable CUSTOM_TOP (which contains physical path to your custom directory) like below in default.env file present under location $INST_TOP/ora/10.1.2/forms/server directory.

For Example:
.....

APPL_TOP=/home/applmgr/PROD/apps/apps_st/appl
CUSTOM_TOP=/home/applmgr/PROD/apps/apps_st/custom

4. Restart the middle tier services.

5. Retest the issue.


Reference : R12 Error 'Function not available to this responsibility' When Trying to Access Custom Form. (Doc ID 553014.1)