16
Aug

Reports Completing With Warning as TemplateNotYetValidException: START_DATE is still not coming yet in OPP

Author: Shakeeb Petkar | Category: EBS 12.2.x, TroubleshootingComments Off on Reports Completing With Warning as TemplateNotYetValidException: START_DATE is still not coming yet in OPP | Tags: , , , , , , , , , ,

Symptoms:

Concurrent request completing with Warning status.

 

Error:

The Concurrent Request logfile show the following error:

-- PUBLISH:
oracle.apps.fnd.cp.opp.PostProcessorException: oracle.apps.fnd.cp.opp.PostProcessorException: oracle.apps.xdo.oa.schema.server.TemplateNotYetValidException: START_DATE is still not coming yet.

 

Cause:

Having different date/time values on EBS nodes causes the run time error.
Make sure that all the EBS nodes have the same date/time settings.

In our case, the year was incorrect on the application server.
Read more...

3
Jul

With AD-TXK Delta.9 and higher, Autoconfig Fails On PatchFS with error "ORA-12514: TNS:listener does not currently know of service requested

Author: Shakeeb Petkar | Category: EBS 12.2.x, TroubleshootingComments Off on With AD-TXK Delta.9 and higher, Autoconfig Fails On PatchFS with error "ORA-12514: TNS:listener does not currently know of service requested | Tags: , , , , , , , , , , , , ,

Symptoms:

 

When attempting to run autoconfig on patch fs the following error occurs.


ERROR
-----------------------
Enter value for 1: Enter value for 2: Enter value for 3: ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor

ERRORCODE = 1 ERRORCODE_END
.end std out.

.end err out.

 
Read more...

5
Jun

Change APPS password in EBS R12.2.x Delta 7 or above

Author: Shakeeb Petkar | Category: EBS 12.2.x, TroubleshootingComments Off on Change APPS password in EBS R12.2.x Delta 7 or above | Tags: , , , , , , , , , , , ,

Important: These steps must be carried out on the run file system. The FND_USER and FND_ORACLE_USERID tables should be backed up before any passwords are changed. Remove the backups after you have confirmed that the changes are successfully completed. Passwords for all the 3 schemas, APPS, APPLSYS and APPS_NE will be changed together while changing APPLSYS password.

1. Shut down the application tier services using the below script:

$INST_TOP/admin/scripts/adstpall.sh

2. Change the APPLSYS password using

 
There are 2 ways to change the APPLSYS password:
Read more...

3
May

Change APPS password in EBS R12.2.x Delta 6 or below

Author: Shakeeb Petkar | Category: EBS 12.2.x, TroubleshootingComments Off on Change APPS password in EBS R12.2.x Delta 6 or below | Tags: , , , , , , , , , , , , ,

Important: These steps must be carried out on the run file system. The FND_USER and FND_ORACLE_USERID tables should be backed up before any passwords are changed. Remove the backups after you have confirmed that the changes are successfully completed. Passwords for all the 3 schemas, APPS, APPLSYS and APPS_NE will be changed together while changing APPLSYS password.

1. Shut down the application tier services using the below script:

$INST_TOP/admin/scripts/adstpall.sh

2. Change the APPLSYS password using

 
There are 2 ways to change the APPLSYS password:
Read more...

16
Apr

Login to internal node gets redirected to external node after adding new DMZ node in EBS R12.2.x

Author: Shakeeb Petkar | Category: EBS 12.2.x, TroubleshootingComments Off on Login to internal node gets redirected to external node after adding new DMZ node in EBS R12.2.x | Tags: , , , , , , , , , , ,

Symptoms:

For some users, login to internal node gets redirected to external node.

 

Cause:

In $IAS_ORACLE_HOME/instances/EBS_web_SID_OHS1/config/OHS/EBS_web_SID/mod_wl_ohs.conf and apps.conf files, the cluster includes the external node external.domain.com.

 

Solution:

 

To fix this issue, make the following changes to the run file system of the internal node:
Remove any reference to external.domain.com from both the files i.e. mod_wl_ohs.conf and apps.conf.
 
Node 1: /u02/oracle/EBSPROD/fs1/FMW_Home/webtier/instances/EBS_web_EBSPROD_OHS1/config/OHS/EBS_web_EBSPROD
 
Node 2: /u02/oracle/EBSPROD/fs1/FMW_Home/webtier/instances/EBS_web_EBSPROD_OHS3/config/OHS/EBS_web_EBSPROD
 
DMZ Node: /u02/oracle/EBSPROD/fs2/FMW_Home/webtier/instances/EBS_web_EBSPROD_OHS2/config/OHS/EBS_web_EBSPROD
 
Read more...

« Previous Page Next Page »

Back to Top