Introduction: This script will provide all Requisitions Details from backend for without Po’s. Script: SELECT (SELECT NVL (short_code, NAME) FROM apps.hr_operating_units WHERE organization_id = r.org_id) org_code, r.segment1 “Req number”, r.authorization_status…
Read MoreAdcfgclone failing with Error: AFTER PASTE BINARY COMMENV.SH FILE IS POPULATED WITH INCORRECT JAVA_HOME PATH in EBS 12.2 Oracle Support notes: ===================== 12.2 E-Business Suite Applications Manager Rapidclone Fails With…
Read MorePrerequisite: Make sure you have applied the patch 23315889(fast offline conversion patch) if you are on Oracle 11g Database or latest CPU patches are applied which already include all the…
Read MoreDatabase Configuration Assistant was not showing the database and Configure Database Options and it was greyed out(disabled). We tried setting up ORACLE_SID and ORACLE_HOME and ran dbca but it was…
Read MoreOracle E-Business Suite Release 12 uses cost–based optimization in order to choose the most efficient execution plan for SQL statements.Gather Schema Statistics is the favourite one among Apps DBA’s and…
Read MoreAn *.out file is a compiled executable file created by various source code compilers in Unix-like operating systems, such as Linux and AIX. *.out files are most commonly seen as…
Read MoreI managed to create the ACFS Mount Point after resolving the issue “ACFS-9459: ASVM/ACFS is not supported on this os version”. But, after creating the ACFS Mount Point, I’m unable…
Read MoreIssue : Concurrent request failed with the following error password verify function error Error: java.sql.SQLException: ORA-28001: the password has expired applmgr@of200:/FINOECD1/inst/apps/FINOECD1_of200/appl/fnd/12.0.0/secure $ FNDCPASS apps/apps4doyen 0 Y system/manager SYSTEM APPLSYSPUB PUB…
Read MoreIssue: ADCFGCLONE fails in Autoconfig with gentns error in DB node. Error : StackTrace: java.lang.NullPointerException at oracle.apps.ad.tools.configuration.DataModelHandler.getDBName(DataModelHandler.java:912) at oracle.apps.ad.tools.configuration.NetServiceHandler.registerDbNode(NetServiceHandler.java:981) at oracle.apps.ad.tools.configuration.NetServiceHandler.registerNode(NetServiceHandler.java:1208) at oracle.apps.ad.tools.configuration.NetServiceHandler.processNode(NetServiceHandler.java:2307) at oracle.apps.ad.tools.configuration.NetServiceHandler.main(NetServiceHandler.java:3182) Closing connection Connection Closed instantiate…
Read MoreISSUE:XML reports complete in warning. Error: ORA-24067: exceeded maximum number of subscribers for queue APPLSYS.FND_CP_GSM_OPP_AQ ORA-06512: at “APPS.FND_CP_OPP_IPC”, line 85 This is a freshly cloned instance and all managers and…
Read More