Yearly Archives: 2021

ASM Fails to Start with ORA-4031: unable to allocate 16416 bytes of shared memory (“shared pool”,”unknown object”,”sga heap(1,0)”,”dbktb: trace buffer”)

APPLIES TO: Oracle Database - Enterprise Edition - Version 11.2.0.1 and later Oracle Database Cloud Schema Service - Version N/A and later Oracle Database Exadata Cloud Machine - Version N/A…

Read More

OPatch Cannot Continue Because it Would not be Able to Load OUI Platform Dependent Library from the Directory “$ORACLE_HOME/oui/lib/linux”

APPLIES TO: Oracle Database - Enterprise Edition - Version 11.2.0.4 and later Oracle Database Cloud Schema Service - Version N/A and later Oracle Database Exadata Express Cloud Service - Version…

Read More

RMAN DUPLICATE without TARGET fails with RMAN-03002 / RMAN-06171

APPLIES TO: Oracle Database - Enterprise Edition - Version 11.2.0.1 and later SYMPTOMS: Database Names: UAT RMAN DUPLICATE without TARGET fails with RMAN-03002 / RMAN-06171 : $ rman auxiliary /…

Read More

R12 E-Business Suite Applications Manager Clone Process Fails With Error ‘AC-50006: Could not assign any APPL_TOP name to this instance’ When Running Adcfgclone.pl AppsTier On An Environment

APPLIES TO: Oracle Applications Manager - Version 12.1.3 and later SYMPTOMS: E-Business Suite R12 Applications Manager, Rapidclone related issues java.lang.Exception: AC-50006: Could not assign any APPL_TOP name to this instance.…

Read More

FNDLOAD SYSNTAX FOR ALL APPLICATION OBJECTS IN EBS R12.2

Description: Following steps are used to upload the application objects using FNDLOAD. FNDLOAD Syntax These are the extensive list which can be done through FNDLOAD — Concurrent Programs, Executables —…

Read More

FORMS COMPILATION IN EBS R12

Description: Following steps are used to compile the forms in EBS R.12. Steps: Step 1: Login to application user in application server through winscp and go to $AU_TOP/forms/US step 2:…

Read More

perl adcfgclone.pl appsTier dualfs ERRORS and SOLUTION

1) perl adcfgclone.pl appsTier dualfs ERRORS and SOLUTION ============================================ ERROR 1 ========= StackTrace: java.lang.Exception: oracle.apps.ad.autoconfig.oam.InDbCtxFileException: Exception : Error executng BEGIN fnd_gsm_util.upload_context_ file(:1,:2,:3,:4,:5); END;: 1; Oracle error -1552: ORA-01552: cannot use…

Read More

ORACLE GOLDEN GATE INSTALLATION IN 19c DATABASE

Environment Details Server Name                         : primegg.localdomain OS Version                           : Oracle Linux Server release 7 Database Version                 : 19.0.0.0 GoldenGate Version             : 19.1.0.0.4 for oracle Oracle Home                        : /u01/app/oracle/product/19.0.0/dbhome_1 GoldenGate…

Read More

Display the multiple errors in OAF

import com.sun.java.util.collections.ArrayList; import oracle.apps.fnd.framework.OAException; import oracle.apps.fnd.common.MessageToken; ArrayList errorMsg= new ArrayList(); for (int i=0; i< hMember.size(); i++) { MessageToken[] token = {new MessageToken(“USER”, getOADBTransaction().getUserName()),new MessageToken(“NUM”,hMember.getChildNumber())}; errorMsg.add(new OAException((String)(getOADBTransaction().getMessage(“XXFKI”,”XXFKI_ERRORS”,token)))); } OAException.raiseBundledOAException(errorMsg);

Read More

How to change the column header dynamically in advance table.

To change the column of a header dynamically use the following code in your controller. import oracle.apps.fnd.framework.webui.beans.table.OAAdvancedTableBean; import oracle.apps.fnd.framework.webui.beans.table.OAColumnBean; import oracle.apps.fnd.framework.webui.beans.table.OASortableHeaderBean; OAAdvancedTableBean tableBean = (OAAdvancedTableBean)webBean.findIndexedChildRecursive(“VendordtlRN”); OAColumnBean columnBean = (OAColumnBean)tableBean.findIndexedChildRecursive(“SupplierID”); OASortableHeaderBean…

Read More