workflow purchasing error

 workflow purchasing error..

Event Error Name: WFE_DISPATCH_GEN_ERR

Event Error Message: 3835: Error '-20002 - ORA-20002: 2018: Unable to generate the notification XML. Caused

by: 2020: Error when getting notification content. Caused by: ORA-20002: 3240: Error '-4061 - ORA-04061:

existing state of has been invalidated

ORA-04061: existing state of package body "APPS.POS_GET" has been invalidated

ORA-04065: not executed, altered or dropped package body "APPS.POS_GET"

' in 'PLSQLCLOB' API 'PO_WF_PO_NOTIFICATION.GET_PO_LINES_DETAILS'

Wf_Notification.GetAttrClob(5084773, PO_LINES_DETAILS, text/html)

Wf_Notification.old' encountered during execution of Generate function 'WF_XML.Generate' for event

'oracle.apps.wf.notification.send'.

Event Error Stack:

WF_MAIL.GetLOBMessage4(5084773, WFMAIL, 2020: Error when getting notification content. Caused by: ORA20002: 3240: Error '-4061 - ORA-04061: existing state of has been invalidated

ORA-04061: existing state of package body "APPS.POS_GET" has been invalidated

ORA-04065: not executed, altered or dropped package body "APPS.POS_GET"

Solution:

We need to perform below and check if still we are getting issue..

1. Shutdown workflow along with container..

2. Recompile the APPS schema through ADADMIN

3. Start the workflow mailer..

If still issue after above action plan then, we need to stop and start whole applications...

Not able to start the DG listener.

While starting the DG listener , getting below error.

-bash-3.2$ lsnrctl start LISTENER_DG_TEST

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on xxxxxxxxxx 03:46:21

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

Starting /oracle/product/11.2.0.3/TEST/bin/tnslsnr: please wait...

TNS-12537: TNS:connection closed
TNS-12560: TNS:protocol adapter error
TNS-00507: Connection closed
Linux Error: 29: Illegal seek
-bash-3.2$ 

SOlution:  Copied the lsnrctl & tnslsnr binaries from good server to bad server. and  It started working.

R12.1.1 Maintenance Pack(7303030) failing EGOEXTDROP.sql ORA-20001: Drop Index: ORA-00955: Name Is Already Us

Recently our environment , we were facing the below error while applying the R12.1.1 Maintenance Pack(7303030).

EGOEXTDROP.sql ORA-20001: Drop Index: ORA-00955: Name Is Already Us

There is a DOC ID1370221.1 saying to rename the EGO_MSIB_EXT_B and EGO_MSIB_EXT_TL tables to backup, new names then rerun the script or Raise the SR.

Rasied the SR: 3-8458158891,performed the below Action plan provided by Oracle Developement.

drop public synonym EGO_MSIB_EXT_B;
drop public synonym EGO_MSIB_EXT_TL;
drop table ego.ego_msib_ext_b;
drop table ego.ego_msib_ext_tl;

and finally patch started running..

RMAN Backup Catalog issues after Database migrated to new Host.

Recently we has faced Rman Catalog issue . Even if backup went fine, but the catalog is not giving the correct info  and getting the below error..

RMAN> list backup;

starting full resync of recovery catalog
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of list command at 10/14/2013 02:05:57
RMAN-03014: implicit resync of recovery catalog failed
RMAN-03009: failure of full resync command on default channel at 10/14/2013 02:05:57
RMAN-20052: invalid datafile create SCN

Steps to reproduce :

1. We take rman backup from primary database to a proxy server and from that server it goes to tape.
2. When ever we run the backup , the catalog does not work properly in primary database.
3. we tried to unregister and re - register the catalog .
4. The catalog and resync works before the backup begins .
5.After the backup the catalog throws the error mentioned in the catalog .

Finally we raised the P1 SR 3-7947905791 with Oracle Support, they have suggested that it's a bug known defect in our software related to databases with plugged in tablespaces.

You can verify using the steps in the following note. 
RMAN-20052: invalid datafile create SCN During Resync or Backup using Recovery Catalog 11.2.0.3 (Doc ID 1411883.1)

1. Run RMAN command RESYNC CATALOG in debug mode:
DEBUG ON;
RESYNC CATALOG;
DEBUG OFF;

2. Find the failing filenumber.
In the tracefile, search for ORA--20052 which is the error. A few lines up you will see 
DBGRESYNC: channel default: Calling checkDataFile for fileno 15 size 655360 [09:09:16.974] (resync) =============> checkDataFile for fileno 15 when error occured

3. Run the queries in the note (TARGET database)
SQL> select file#, ts# from v$datafile where file# =<fileno from debug trace>;
Make a note of the TS# for use in step 4. 
SQL> select fetsn, fenum, feplus, fecrc_scn, fepdi from x$kccfe where fetsn in (select ts# from v$datafile where file# =<fileno>);
SQL> select foreign_dbid, plugin_change#, plugged_in from v$datafile where ts# in (select ts# from v$datafile where file# =<fileno>);

4. Run the queries in the note (CATALOG database)
select ts#, file#, PLUGIN_SCN from df where ts# = 13;

If the symptoms of the note continues to match, download and apply the patch for defect 13000553 - RMAN BACKUP FAILS WITH RMAN-20999 ERROR AT STANDBY DATABASE 

Forms Launching Error, After Fresh R12.1.1 Installations on Linux x86 32 bit

I faced issue while launching forms on newly installed R12.1.1 Oracle Applications.

FRM-92101:  formsweb: Forms session <1> aborted: runtime process failed during startup with errors /apps/apps/tech_st/10.1.2/bin/frmweb: error while loading shared libraries: libXm.so.2: cannot open shared object file: No such file or directory

While chekcing the Web Forms log file. in $LOG_HOME/ora/10.1.3/j2ee/<forms>/<forms>_<default_group_1>/application.log
 formsweb: Forms session <1> exception stack trace:

oracle.forms.engine.RunformException: Forms session <1> failed during startup: no response from runtime process
        at oracle.forms.servlet.RunformProcess.connect(Unknown Source)
        at oracle.forms.servlet.RunformProcess.dataToRunform(Unknown Source)
        at oracle.forms.servlet.RunformSession.dataToRunform(Unknown Source)
        at oracle.forms.servlet.ListenerServlet.doPost(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
        at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:713)
        at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370)
        at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:871)
        at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453)
        at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.AJPRequestHandler.run(AJPRequestHandler.java:313)
        at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.AJPRequestHandler.run(AJPRequestHandler.java:199)
        at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
        at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
        at java.lang.Thread.run(Thread.java:619)

Cause:

The issue is caused by the openmotif21 package which is missing from the system.
For example, for Oracle Enterprise Linux 5 or Red Hat Enterprise Linux 5 the missing package is:
openmotif21-2.1.30-11.EL5.i386.rpm.

Solution:

1. Install package openmotif rpm.
For example, for Oracle Enterprise Linux 5 or Red Hat Enterprise Linux 5 the missing package is:
openmotif21-2.1.30-11.EL5.i386.rpm.
2. Bounce the services.(both Apps+DB)
3. now able to launch the forms.

Ref Doc: FRM-92101: Forms Server [ID 1192205.1]

Error in Installing R12.1.1 Oracle Applications in Final Step 5

Recently faced the issue while installing R12.1.1 installtion. After final steps of R12.1.1 installations, Faced the below error in Final Screenshot.

HTTP
-----
   checking URL = http://localhost.localdomain:8000
   RW-50015: Error: - HTTP Listener is not responding. The service might not have started on the port yet. Please check the service and use the retry button.
Help Page
----------
checking URL = http://localhost.localdomain:8000/OA_HTML/help
   RW-50015: Error: - Help Page is not responding. The service might not have started on the port yet. Please check the service and use the retry button.
Virtual Directory
------------------
   RW-50015: Error: - Http Server Virtual Directories is not responding. The service might not have started on the port yet. Please check the service and use the retry button.
JSP
----
   checking URL = http://localhost.localdomain:8000/OA_HTML/jtfTestCookie.jsp
   RW-50015: Error: - JSP is not responding. The service might not have started on the port yet. Please check the service and use the retry button.
Login Page
-----------
   RW-50015: Error: - Login Page is not responding. The service might not have started on the port yet. Please check the service and use the retry button.

I checked the application installation log file(/apps/inst/apps/TEST_localhost/logs/05030038.log).the above error was there.. while again investing the log file, observed that
the autoconfig was failing. So checked the autoconfig logfile (/apps/inst/apps/TEST_localhost/admin/log/05030620/adconfig.log), The below error was found.

[CVM Error Report]
The following report lists errors encountered during CVM Phase
      <filename>  <return code where appropriate>
  /apps/apps/apps_st/appl/ad/12.0.0/bin/adgentns.pl  -1
No of scripts failed in CVM phase: 1
AutoConfig is exiting with status 1

I didn't find the exact hit on support.oracle.com , so plan to run the perl scripts manually which was failing..SO ran the perl scripts and it autoconfig got successful.and click the
retry button of R12 Installtion screen, it got successful.

[applmgr@localhost bin]$ perl adgentns.pl contextfile=/apps/inst/apps/TEST_localhost/appl/admin/TEST_localhost.xml  appspass=apps
##########################################################################
                   Generate Tns Names
##########################################################################
Logfile:  /apps/inst/apps/TEST_localhost/admin/log/05030918/NetServiceHandler.log
        Classpath                   : /apps/apps/apps_st/comn/java/lib/appsborg2.zip:/apps/apps/apps_st/comn/java/classes
Updating s_tnsmode to 'generateTNS'
UpdateContext exited with status: 0
adgentns.pl exiting with status 0
ERRORCODE = 0 ERRORCODE_END

Issue with running catupgrd.sql while Database upgrade from 10.2.0.4 to 11.2.0.3:

Getting below error while running catupgrd.sql scripts while DB upgrade.

SELECT TO_NUMBER('MUST_HAVE_RUN_PRE-UPGRADE_TOOL_FOR_TIMEZONE')
                *
ERROR at line 1:
ORA-01722: invalid number

Cause:
------------
The Pre-Upgrade Script is not creating the registry$database table & inserting the Platform DST Patch Information.The error may also appear if the the registry$database table exists,  but does not contain the required information.

Solution:
-----------------

SQL> select * from sys.registry$database;

PLATFORM_ID PLATFORM_NAME        EDITION                        TZ_VERSION
----------- -------------------- ------------------------------ ----------
         13 Linux x86 64-bit

SQL> create table registry$database_b as select * from registry$database;

Table created.

select * from sys.registry$database;

PLATFORM_ID PLATFORM_NAME        EDITION                        TZ_VERSION
----------- -------------------- ------------------------------ ----------
         13 Linux x86 64-bit

SQL> INSERT into registry$database
  2                      (platform_id, platform_name, edition, tz_version)
  3                 VALUES ((select platform_id from v$database),
  4                         (select platform_name from v$database),
  5                          NULL,
  6                         (select version from v$timezone_file));

1 row created.

SQL> select * from sys.registry$database;

PLATFORM_ID PLATFORM_NAME        EDITION                        TZ_VERSION
----------- -------------------- ------------------------------ ----------
         13 Linux x86 64-bit
         13 Linux x86 64-bit                                             4

SQL> commit;

Commit complete.

SQL> delete from sys.registry$database where TZ_VERSION is NULL;

1 row deleted.

SQL> commit;

Commit complete.

SQL> select * from sys.registry$database;

PLATFORM_ID PLATFORM_NAME        EDITION                        TZ_VERSION
----------- -------------------- ------------------------------ ----------
         13 Linux x86 64-bit                                             4

Ref Doc: catupgrd.sql fails With ORA-01722 Invalid Number after running the Pre-Upgrade Script [ID 1466464.1]