OUTPUT POST PROCESS FAIL DURING REPORT

ERROR:

Error Log file for Run Report HDFC Approval loan:

Beginning post-processing of request 410194 on node HDFC at 24-DEC-2014 14:09:40.

Post-processing of request 410194 failed at 24-DEC-2014 14:09:40 with the error message:

One or more post-processing actions failed. Consult the OPP service log for details.

SOLUTION:

Concurrent  OPP Process Timeout  300 à 600

Concurrent  OPP Response Timeout     120 à 400

Then restart only application services.

Apply AD R12.2 and CPU Upgrade patches

  -Download all ad patches

Patch# p18303441_R12.AD.C_R12_LINUX.zip
Patch# p17197279_R12.AD.C_R12_LINUX.zip
Patch# p10117518_R12_LINUX.zip

Merge all AD patches at /u02/nitin/ebs_upgrade_12_2/AD_source/merge_adall

1) Run environment file . APPSVISION_VIS.env
2) Go to /u02/nitin/ebs_upgrade_12_2/AD_source /merge_adall
3) $ adpatch options=nocopyportion, nogenerateportion

Run the American English upgrade patch driver

1) Run environment file of fs1 file system.
2) Go to $AU_TOP/patch/115/driver
3) adpatch options=nocopyportion, nogenerateportion

Note: this step is take too long time for apply.

Disable Maintenance mode.

1) Run environment file of application file system.
2) $adadmin
3) Select Change maintenance mode
4) Select disable maintenance mode.
5) Exit


Source:Internet

OPMN port conflict on Sun Solaris

by default, the OPMN service of the Application Server listens on port 6000 and this can conflict with X11 port used for the graphics on UNIX machine.

To avoid this issue:

1) check port 6000 is active

bash-3.00$ netstat -an | grep 6000
      *.6000               *.*                0      0 49152      0 LISTEN
      *.6000               *.*                0      0 49152      0 LISTEN
      *.6000                            *.*                             0      0 49152      0 LISTEN
bash-3.00$

2) Shutdown the dtlogin process with the command "/usr/dt/bin/dtconfig -kill"
3) Confirm that nothing is listening at port 6000 ("netstat -a | grep 6000")
4) Disable the local X console for dtlogin with command "/usr/dt/bin/dtconfig -d"
5) Restart dtlogin with command "/usr/dt/bin/dtconfig -e"

bash-3.00# cd /
bash-3.00# /usr/dt/bin/dtconfig -kill
done
dtlogin kill complete.
bash-3.00# netstat -a | grep 6000
bash-3.00# /usr/dt/bin/dtconfig -d
done
desktop auto-start disabled.
bash-3.00# /usr/dt/bin/dtconfig -e
done
desktop auto-start enabled.
bash-3.00#

Source: Internet

Packing Installation on Sun Solaris 10

# pkginfo -i SUNWi1cs SUNWi15cs

# pkgadd -d /cdrom/sol_10_910_x86/Solaris_10/Product SUNWi1cs SUNWi15cs

Processing package instance <SUNWi1cs> from </cdrom/sol_10_106_x86/Solaris_10/Product>

X11 ISO8859-1 Codeset Support (i386) 2.0, REV=2004.10.17.15.04

Copyright 2004 Sun Microsystems, Inc.  All rights reserved.

Use is subject to license terms.

This appears to be an attempt to install the same architecture and

Version of a package which is already installed.  This installation

Will attempt to overwrite this package.

Using </> as the package base directory.

## Processing package information.

## Processing system information.

   16 package pathnames are already properly installed.

## Verifying package dependencies.

## Verifying disk space requirements.

## Checking for conflicts with packages already installed.

## Checking for setuid/setgid programs.

This package contains scripts which will be executed with super-user

permission during the process of installing this package.

Do you want to continue with the installation of <SUNWi1cs> [y,n,?] y

Installing X11 ISO8859-1 Codeset Support as <SUNWi1cs>

## Installing part 1 of 1.

Installation of <SUNWi1cs> was successful.

Processing package instance <SUNWi15cs> from </cdrom/sol_10_106_x86/Solaris_10/Product>

X11 ISO8859-15 Codeset Support (i386) 2.0, REV=2004.10.17.15.04

Copyright 2004 Sun Microsystems, Inc.  All rights reserved.

Use is subject to license terms.

This appears to be an attempt to install the same architecture and

Version of a package which is already installed.  This installation

Will attempt to overwrite this package.

Using </> as the package base directory.

## Processing package information.

## Processing system information.

   21 package pathnames are already properly installed.

## Verifying package dependencies.

## Verifying disk space requirements.

## Checking for conflicts with packages already installed.

## Checking for setuid/setgid programs.

This package contains scripts which will be executed with super-user

permission during the process of installing this package.

Do you want to continue with the installation of <SUNWi15cs> [y,n,?] y

Installing X11 ISO8859-15 Codeset Support as <SUNWi15cs>

## Installing part 1 of 1.

Installation of <SUNWi15cs> was successful.

#

Source: Internet

Unlocking Schema in EBS 11i,R12

-bash-3.2$ Source Application Enviromenet
-bash-3.2$  sqlplus apps/apps

SQL> select owner, table_name, stattype_locked
  2  from dba_tab_statistics
  3  where stattype_locked is not null;

OWNER                          TABLE_NAME                     STATT                                                               ------------------------------ -----------------------------------                                                                          SYS                            SYS$SERVICE_METRICS_TAB    ALL                                                         SYS                            KUPC$DATAPUMP_QUETAB          ALL                                                         SYS                            AQ_PROP_TABLE                ALL                                                                       SYS                            AQ$_MEM_MC                     ALL                                                                       SYS                            ALERT_QT                      ALL                                                                             SYS                            SCHEDULER_FILEWATCHER_QT       ALL                                                     SYS                            SCHEDULER$_REMDB_JOBQTAB       ALL                                                   SYS                            SCHEDULER$_EVENT_QTAB          ALL                                              
SYS                            AQ_EVENT_TABLE                 ALL                                                                   SYSTEM                         TBLMIG_MSG_QTAB                ALL                                                           SYSTEM                         DEF$_AQERROR                   ALL                                                                 SYSTEM                         DEF$_AQCALL                    ALL                                                                   AMV                            AMV_MATCHING_QUEUE_TBL         ALL                                                   APPLSYS                        AQ$_WF_CONTROL_P               ALL                                                           APPLSYS                        FND_CP_TM_AQTBL                ALL                                                             APPLSYS                        WF_NOTIFICATION_OUT            ALL                                                        
79 rows selected.

SQL> spool /u01/unlock_schema.sql
SQL> set lines 500 pages 5000
SQL> run
  1  select 'exec dbms_stats.unlock_table_stats('||''''||owner||''''||','||''''||table_name||''''||')'||';'
  2* from  dba_tab_statistics where stattype_locked is not null

'EXECDBMS_STATS.UNLOCK_TABLE_STATS('||''''||OWNER||''''||','||''''||TABLE_NAME||''''||')'||';'     ------------------------------------------------------------------------------------------------------                           exec dbms_stats.unlock_table_stats('SYS','SYS$SERVICE_METRICS_TAB');                                     exec dbms_stats.unlock_table_stats('SYS','KUPC$DATAPUMP_QUETAB');                                       exec dbms_stats.unlock_table_stats('SYS','AQ_PROP_TABLE');                                                           exec dbms_stats.unlock_table_stats('SYS','AQ$_MEM_MC');                                                               exec dbms_stats.unlock_table_stats('SYS','ALERT_QT');                                                                     exec dbms_stats.unlock_table_stats('SYS','SCHEDULER_FILEWATCHER_QT');                           exec dbms_stats.unlock_table_stats('SYS','SCHEDULER$_REMDB_JOBQTAB');                             exec dbms_stats.unlock_table_stats('SYS','SCHEDULER$_EVENT_QTAB');                                     exec dbms_stats.unlock_table_stats('SYS','AQ_EVENT_TABLE');                                                     exec dbms_stats.unlock_table_stats('SYSTEM','TBLMIG_MSG_QTAB');                                           exec dbms_stats.unlock_table_stats('SYSTEM','DEF$_AQERROR');                                                    
SQL> spool off
79 rows selected.

-bash-3.2$ cd /u01
-bash-3.2$ pwd
/u01
-bash-3.2$ ls *.sql
unlock_schema.sql
-bash-3.2$
-bash-3.2$ sqlplus apps/apps @unlock_schema.sql

SQL> commit;

Commit complete.

                                                                                                                                                                                                                                                                                                                                                                                              
                                                                                                                                               

Run Gether Statistics On EBS 11i,R12 Background

bash3.2# Source Application Environment
bash3.2# sqlplus apps/appps

SQL>
*/
FND_STATS.GATHER_SCHEMA_STATS (
    schemaname        VARCHAR2,
    estimate_percent  NUMBER DEFAULT NULL,
    degree            NUMBER DEFAULT NULL,
    internal_flag     NUMBER DEFAULT NULL,
    Errors OUT Error_Out,
    request_id   NUMBER default null,
    hmode        VARCHAR2 default 'LASTRUN',
    options in   VARCHAR2 default 'GATHER',
    modpercent   NUMBER default 10,
    invalidate   VARCHAR2 default 'Y'
);
/*

SQL> exec FND_STATS.GATHER_SCHEMA_STATISTICS('ALL', 10,32,'NOBACKUP', NULL,'LASTRUN','GATHER AUTO', 10, 'N');

How to Check Installed Modules In EBS 11i,R12

bash3.2# Source Application Enviroment
bash3.2# sqlplus apps/apps
SQL>SELECT a.application_name,a.product_code,
DECODE (b.status, 'I', 'Installed', 'S', 'Shared', 'N/A') status,
 patch_level  FROM apps.fnd_application_vl a,
 apps.fnd_product_installations b
 WHERE a.application_id = b.application_id
  and b.status='I'
  order by product_code asc;


Source:Internet