'Function not available to this responsibility...' Error when navigate to Help->Diagnostic->Examine

Problem

When navigate to Help->Diagnostic->Examine then below error occur

Solution

Enable Diagnostic for Application User

Set 'Yes' for User level of profile option  'Utilities:Diagnostics' and logout from application and login again with respective user. Now you enable diagnostic and you can able to view now.

ORA-06508 PL/SQL Could Not Find Program When Open Sales Order Form

Problem

The issue can be reproduced following

1. Login to R12 Application with respective user

2. Responsibility- Order Management Super User

3. Navigate to  Orders->Returns ->Order Organizer

4. Open Sales Order form and see error:

ORA-06508: PL/SQL: could not find program unit being called In Package ONT_HEADER_Def_Hdlr Procedure Default_Record: REQUEST_DATE 1

Solution

Shared pool memory is too low or high causing a resource utilization

Please update following parameter with given minimum value

sqlplus / as sysdba 
sql> alter system set shared_pool_size=600M scope=spfile; 
sql> alter system reset shared_pool_reserved_size scope=spfile; 
sql> alter system set db_cache_size=400M scope=spfile; 
sql> shutdown immediate 
sql> startup

Reference : Open Sales Order Screen Generates Error ORA-06508 PL/SQL Could Not Find Program Unit Being Called (Doc ID 841870.1)

ORA-00845: MEMORY_TARGET not supported on this system

Problem

SQL> show parameter memory

NAME                                 TYPE        VALUE
------------------------------------ ----------- --------
hi_shared_memory_address             integer     0
memory_max_target                    big integer 3152M
memory_target                        big integer 3152M
shared_memory_address                integer     0

SQL> alter system set memory_max_target=8G scope=spfile;

System altered.

SQL> alter system set memory_target=8G scope=spfile;

System altered.

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> startup
ORA-00845: MEMORY_TARGET not supported on this system

Solution

[root@prod ~]# df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/sda1             754G   42G  674G   6% /
tmpfs                 3.9G   88K  3.9G   1% /dev/shm

/dev/shm mount point size must be greater than or equal to value of MEMORY_TARGET parameter

So Increase the size of /dev/shm mount point

[root@prod ~]# umount -l /dev/shm/

[root@prod ~]# mount -t tmpfs shmfs -o size=8g /dev/shm

[root@prod ~]# df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/sda1             754G   42G  674G   6% /
shmfs                 8.0G     0  8.0G   0% /dev/shm

SQL> startup
ORACLE instance started.

Total System Global Area 8551575552 bytes
Fixed Size                  2215064 bytes
Variable Size            4093641576 bytes
Database Buffers         4429185024 bytes
Redo Buffers               26533888 bytes
Database mounted.
Database opened.

SQL> show parameter memory

NAME                                 TYPE        VALUE
------------------------------------ ----------- ---------
hi_shared_memory_address             integer     0
memory_max_target                    big integer 8G
memory_target                        big integer 8G

shared_memory_address                integer     0                

'An unexpected error has been detected by HotSpot Virtual Machine:' While launching Oracle Universal Installer

Problem

[oracle@prod database]$ ./runInstaller 
dirname: invalid option -- 'b'
Try `dirname --help' for more information.
Starting Oracle Universal Installer...

Checking Temp space: must be greater than 120 MB.   Actual 712409 MB    Passed
Checking swap space: must be greater than 150 MB.   Actual 24575 MB    Passed
Checking monitor: must be configured to display at least 256 colors.    Actual 16777216    Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2014-10-13_03-28-11PM. Please wait ...[oracle@prod database]$ #
# An unexpected error has been detected by HotSpot Virtual Machine:
#
#  SIGSEGV (0xb) at pc=0x0000003315e14d70, pid=3286, tid=139755847370512
#
# Java VM: Java HotSpot(TM) 64-Bit Server VM (1.5.0_17-b03 mixed mode)
# Problematic frame:
# C  [ld-linux-x86-64.so.2+0x14d70]
#
# An error report file with more information is saved as hs_err_pid3286.log
#
# If you would like to submit a bug report, please visit:
#   http://java.sun.com/webapps/bugreport/crash.jsp             integer     0                

Solution

Set 'LD_BIND_NOW' environment variable to value '1' and launch again.

[oracle@prod database]$ export LD_BIND_NOW=1
[oracle@prod database]$ ./runInstaller 
dirname: invalid option -- 'b'
Try `dirname --help' for more information.
Starting Oracle Universal Installer...

Checking Temp space: must be greater than 120 MB.   Actual 712019 MB    Passed
Checking swap space: must be greater than 150 MB.   Actual 24575 MB    Passed
Checking monitor: must be configured to display at least 256 colors.    Actual 16777216    Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2014-10-13_03
-33-18PM. Please wait ...[oracle@prod database]$ You can find the log of this install session at:

 /u01/app/oraInventory/logs/installActions2014-10-13_03-33-18PM.log

Upgrade EBS 12.1.1 to 12.1.3

To apply Oracle E-Business Suite Release 12.1.3, follow these steps

Apply below patches

1. Patch 9239089
2. Patch 9239090 
3. Patch 9239095 
4. Patch 9817770 
5. Patch 9966055 

Post Update Steps

Update all database tier nodes with the code level, provided by Oracle E-Business Suite Release 12.1.3 (Create Appsutil Directory using admkappsutil.pl)

Reference

Oracle E-Business Suite Release 12.1.3 Readme (Doc ID 1080973.1)

Re-Create Appsutil and sub directories for DB Tier

Problem

Appsutil directory or sub directories of appsutil are missing


Solution

Re-create the Appsutil  directory

Steps

 On the Application Tier (From Application binary owner)

1. Source the environment variables for Oracle Applications

. $APPL_TOP/APPS.env

2. Run AutoConfig on the APPL_TOP

. $ADMIN_SCRIPT_HOME/adautocfg.sh

3. Execute admkappsutil.pl utility to create the file appsutil.zip

perl $AD_TOP/bin/admkappsutil.pl

This will create appsutil.zip in $INST_TOP/admin/out

     
 On the Database Tier (From DB binary owner)

1. Source the environment variables for RDBMS ORACLE_HOME

. /$ORACLE_HOME/.env

2. Copy the created appsutil.zip file from $INST_TOP/admin/out to the <RDBMS ORACLE_HOME>

3. Uncompress appsutil.zip under the <RDBMS ORACLE_HOME>

cd $ORACLE_HOME
unzip -o appsutil.zip

4. Create Contextfile

cd $ORACLE_HOME/appsutil/bin
perl adbldxml.pl appsuser=apps

5. Create Script directory

cd $ORACLE_HOME/appsutil/bin
sh adconfig.sh contextfile=<contextfile path>

6. Run AutoConfig on the <RDBMS ORACLE_HOME>

sh $ORACLE_HOME/appsutil/scripts/<context_name>/adautocfg.sh

References :

Using AutoConfig to Manage System Configurations in Oracle E-Business Suite Release 12 (Doc ID 387859.1)

Cloning Oracle Applications Release 12 with Rapid Clone (Doc ID 406982.1)

Printer Issue: APP-FND-00314: Invalid printer (noprint) and print style (LANDWIDE240) combination

Problem

The printer defined and does not have combinations of styles and drivers that use by concurrent program.

Solution

Add combination of styles and drivers

1. Login to system and navigate to System Administrator responsibility

    Install -> Printer -> Register

2. Query for 'noprint' and note the value in the Type column (For example: HPLJ4SI )

3. Click Printer Types button

4. Query for value returned from Register screen

5. Add a new row with Style = 'LANDWIDE240' , Driver = 'PASTA_LANDWIDE_240'

6. Save the form

Generate HTML/Excel Reports from SQL*Plus

HTML

1. Generate HTML/Excel page for each spooled file

SQL> set feed off markup html on spool on;

2. Create spool file

SQL> spool <file_name.html>;

3. Execute Query that need to export

SQL> select * from <your_table>;

4. Close the created spooled file

SQL> spool off;

5. Close HTML/Excel Page

SQL> set markup html off spool off;

Excel

1. Create spool file

SQL> spool <file_name.xls>;

2. Make following setting

SQL> set colsep,     --separate columns with a comma
SQL> set headsep off --separator character for the header row
SQL> set pagesize 0  --No header rows
SQL> set trimspool on --remove trailing blanks

3. Execute sql script

SQL> select * from <your_table>;

4. Close the created spooled file

SQL> spool off;