Syed Saad Ali

Oracle ACE Pro

Oracle Solution Architect

Oracle E-Business Suite

Oracle Cloud Infrastructure

Oracle Fusion Middleware

Oracle Database Administration

Oracle Weblogic Administration

Syed Saad Ali

Oracle ACE Pro

Oracle Solution Architect

Oracle E-Business Suite

Oracle Cloud Infrastructure

Oracle Fusion Middleware

Oracle Database Administration

Oracle Weblogic Administration

Errors/Workarounds-Applications

June 23, 2017 APP-PAY-06882: Assertion failure detected at location py3vntsetup:2
Accounts PayablesAPPS DBAErrors/Workarounds-APErrors/Workarounds-ApplicationsOracle Functional

ERROR

Error while Payroll processing:-

HR_6882_HRPROC_ASSERT
LOCATION py3vntsetup:2
APP-PAY-06882: Assertion failure detected at location py3vntsetup:2.

(more…)

June 20, 2017 java.io.IOException: ORA-01691: unable to extend lob segment
Errors/Workarounds-ApplicationsOracle APPS DBA

ERROR

Start uploading…
Target file: SAF654_XML.rtf
Creating a new record in XDO_LOBS: SAF645_XML.rtf
java.io.IOException: ORA-01691: unable to extend lob segment XDO.SYS_LOB00001312564V00010$$ by 16 in tablespace APPS_TS_TX_DATA   

(more…)

June 17, 2017 APP-FND-01542: This Applications Server is not authorized to access this database
Errors/Workarounds-ApplicationsOracle APPS DBA

ERROR

APP-FND-01542 : This Application Server is not authorized to access this system. Please contact your System Administrator.

SOLUTION

Step 1.  Backup context file .

Step 2. Update the context variable:

s_appserverid_authentication

By default in 11.5.10, this is set to SECURE.

In previous 11i versions, this was set to OFF.
For debug purposes, you can use ON or OFF.

Modes:

– ON : Partial
– SECURE : activates full server security (SECURE mode)
– OFF : deactivates server security

Step 3. Run Autoconfig to instantiate the change.

 

 

June 12, 2017 Unable to locate ‘make’ utility in path
APPS DBAErrors/Workarounds-Applications

ERROR

Unable to locate ‘make’ utility in path

Issue :

bash-3.2$ perl adcfgclone.pl dbTechStack

                     Copyright (c) 2011 Oracle Corporation
                        Redwood Shores, California, USA

                        Oracle E-Business Suite Rapid Clone

                                 Version 12.2

                      adcfgclone Version 120.63.12020000.7.1202010.2

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 = /u01/apps/Test/11.2.0/appsutil/clone/bin/../jre/bin:/usr/bin:/bin
WARNING: Could not find all the required OS utilities in the $PATH. Please review the checks above

 

 

SOLUTION

1.export PATH=/usr/ccs/bin:$PATH

2. Now, Run perl adcfgclone.pl dbTechStack