Config Error Cannot add duplicate collection entry of type 'mimeMap' with unique key attribute 'fileExtension' set to '.docx' for UPK

this error receive when try to open http://localhost/KContent and educations after installition upk.

PROBLEM

HTTP Error 500.19 - Internal Server Error
The requested page cannot be accessed because the related configuration data for the page is invalid.
Module CustomErrorModule
Notification SendResponse
Handler StaticFile
Error Code 0x800700b7
Config Error Cannot add duplicate collection entry of type 'mimeMap' with unique key attribute 'fileExtension' set to '.docx'
Config File \\?\C:\KContent\web.config

Config Source

  163:       <mimeMap fileExtension=".ex~" mimeType="application/octet-stream" />
  164:       <mimeMap fileExtension=".docx" mimeType="application/vnd.openxmlformats-officedocument.wordprocessingml.document" />
  165:       <mimeMap fileExtension=".flv" mimeType="video/x-flv" />

SOLUTION

1.open the C:\KContent\web.config

2.add below lines between <staticContent>  tags.

 <remove fileExtension=".flv" />
 <remove fileExtension=".docx" />
 <remove fileExtension=".ex~" />

3.saved the web.config


ref:UPK: Importing a Title into Knowledge Center Fails with HTTP Error 500.19 Internal Server Error (Doc ID 1521720.1)

how to find running concurrent process id in operation system for R12,R11

execute below sql definition in sqlplus with apps user.

SELECT a.request_id, d.sid, d.serial# ,d.osuser,d.process , c.SPID
FROM apps.fnd_concurrent_requests a,
apps.fnd_concurrent_processes b,
v$process c,
v$session d
WHERE a.controlling_manager = b.concurrent_process_id
AND c.pid = b.oracle_process_id
AND b.session_id=d.audsid
AND a.request_id = &Request_ID
AND a.phase_code = 'R';

it will want concurrent no,

after find out process id, you can list.

ps -ef | grep process_id

how to start / stop netbackup services in unix

Stop:
/usr/openv/netbackup/bin/goodies/netbackup stop

Start:
/usr/openv/netbackup/bin/goodies/netbackup start

deleted xml definition in CONTEXT_FILE after adautocfg.sh for R12

i write xml definition for custom top in CONTEX_FILE, but it is deleted after run adautocfg.sh.

xml syntax:
<XXXXX_TOP oa_var="s_xxxxx_top" oa_type="PROD_TOP" oa_enabled="FALSE">$APPL_TOP/xxxxx/12.0.0</XXXXX_TOP>

SOLUTİON:

write in topfile.txt and run  adautocfg.sh. ($APPL_TOP/admin/topfile.txt)
synatx:
xxxxx    $APPL_TOP

how to count EBS users

query:

SELECT user_id, user_name, full_name
    FROM fnd_user fu, per_all_people_f papf
   WHERE papf.person_id = fu.employee_id
         AND SYSDATE BETWEEN fu.start_date AND NVL (fu.end_date, SYSDATE)
         AND SYSDATE BETWEEN papf.effective_start_date
                         AND NVL (papf.effective_end_date, SYSDATE ) ORDER BY 2;

TNS-01151: Missing listener name, APPS_database-SID, in LISTENER.ORA for 11g

PROBLEM:

i have problem (below) when run adstrtal.sh after  Perl adcfgclone.pl appsTier.

TNS-01101: Could not find service name libociei.so

TNS-01101: Could not find service name libociei.so
03/01/14-22:17:48 :: adalnctl.sh: Starting listener process APPS_SID.

LSNRCTL for Solaris: Version 10.1.0.5.0 - Production on 01-MAR-2014 22:17:48

Copyright (c) 1991, 2004, Oracle.  All rights reserved.

Starting $ORACLE_HOME/bin/tnslsnr: please wait...

TNSLSNR for Solaris: Version 10.1.0.5.0 - Production
Log messages written to $ORACLE_HOME/network/log/apps_mesakl04.log
TNS-01151: Missing listener name, APPS_database-SID, in LISTENER.ORA

Listener failed to start. See the error message(s) above...


SOLUTION:

cd  $INST_TOP/ora/10.1.2/network/admin/

if listener.ora is not found under path

cd $ADMIN_SCRIPTS_HOME
./adautocfg.sh


it will solve.
go to $INST_TOP/ora/10.1.2/network/admin/ for test.

Could not find all the required OS utilities in the $PATH' Error for solaris when run perl adcfgclone.pl appsTier for R12

PROBLEM:

cd $COMMON_TOP/clone/bin  and  run perl adcfgclone.pl appsTier :

bash-3.2$ perl adcfgclone.pl appsTier

                     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 :

Checking for make...
 Unable to locate 'make' utility in path
 Checking for ld...
 Unable to locate 'ld' utility in path
 Checking for ar...
 Unable to locate 'ar' utility in path
 Unable to locate all utilities with system path.
 PATH = $COMMON_TOP/clone/bin/../jre/bin:/bin:/usr/bin:/usr/bin:/bin:/opt/openv/pdde/pdopensource/bin:/usr/X11/bin:/usr/openwin/bin


WARNING:  could not find all the required os utilities in the $path. please review the checks above                                                                                        w the checks above


SOLUTION:

To implement the solution, please execute the following steps:

1. Locate the missing utilities. On most releases of unix, they are in /usr/ccs/bin
2. Include a reference to the utilities path in the $PATH environment variable for the applmgr user used to manage the instance. Remember to export the PATH for changes to take effect.
3. Rerun the command 'perl adcfgclone.pl appsTier'

ref:   adcfgclone.pl is Unable to Locate All Utilities in the System Path - 'Could not find all the required OS utilities in the $PATH' Error (Doc ID 397742.1)

ERROR: OPatch failed during prerequisite check. Interim Patch yyyyyyy is holding the lock from this patch xxxxxxx for R12

PROBLEM:
i have problem when try to apply patch:9044638

ERROR:
bash-4.2$ opatch apply

Oracle Interim Patch Installer version 1.0.0.0.64
Copyright (c) 2011 Oracle Corporation. All Rights Reserved..

Oracle recommends you to use the latest OPatch version
and read the OPatch documentation available in the OPatch/docs
directory for usage. For information about the latest OPatch and
other support-related issues, refer to document ID 293369.1
available on My Oracle Support (https://myoraclesupport.oracle.com)

Oracle Home : /appdata/data_appl/apps/tech_st/10.1.2
Oracle Home Inventory : /appdata/data_appl/apps/tech_st/10.1.2/inventory
Central Inventory : /appdata/cloneap2/inst/apps/burklon_testburlaapp/admin/oraInventory
from : /etc/oraInst.loc
OUI location : /appdata/data_appl/apps/tech_st/10.1.2/oui
OUI shared library : /appdata/data_appl/apps/tech_st/10.1.2/oui/lib/ibm_aix/liboraInstaller.so
Java location : /appdata/data_appl/apps/tech_st/10.1.2/jre/1.4.2/bin/java
Log file location : /appdata/data_appl/apps/tech_st/10.1.2/.patch_storage/<patch ID>/*.log

Problems with the lock file
Lock file exists, details are:
Interim Patch 9593176 is holding the lock from this patch 9044638,
probably due to previous unsuccessful operation

ERROR: OPatch failed during prerequisite check.

SOLUTION:

1.remove patch_locked file.
mv $ORACLE_HOME\.patch_storage\patch_locked $ORACLE_HOME\.patch_storage\patch_locked_backup
2. apply patch again.

When navigating from one field to another field in Receipts Workbench (ARXRWMAI) using mouse, the cursor will not navigate to the desired field. Users are hard forced to use Tab key on the keyboard for R12

PROBLEM:

When navigating from one field to another field in Receipts Workbench (ARXRWMAI) using mouse, the cursor will not navigate to the desired field. Users are hard forced to use Tab key on the keyboard

SOLUTION:

Responsibility: Receivables Manager

Navigation: Help > About Oracle Applications

Check for Forms Server > Oracle Forms Version

Alternatively, you can get the forms version using the following at the command line prompt:

$ORACLE_HOME/bin/frmcmp_batch | grep Forms | grep Version

If the Forms version is 10.1.2.2,

1. Refer to Note 750359.1 to make sure patches listed under "Forms - Java Patch" in Step 2.1.2 are applied.

If the the issue occurs even after the patches in Note 750359.1 are applied, then it is suggested that the Forms version is upgraded to 10.1.2.3 please refer to Note 437878.1 for more information on the latest patches available.

If the Forms version is 10.1.2.3, then

1. Please download and review the read me for Patch 9044638

2. Then apply Patch 9044638 in a test environment.

3. After applying patch, please regenerate jar files via ADADMIN.

4. Retest the issue.

5. If the issue is resolved, please migrate the solution as appropriate to other environments.