Oracle Application Blog

What is Edition Based Redefinition (EBR) in Oracle?

Edition Based Redefinition (EBR) is a new feature introduced from Oracle Software Version 11g R2.Edition-based redefinition allows multiple versions of PL/SQL objects, views and synonyms in a single schema.This feature…

Read More

Finding the Weblogic URL and Port from R12.2 Context File

We can find the weblogic URL and port from the CONTEXT_FILE by using the below variable. Steps: 1. Go to Application Tier 2. Set the RUN file system environment. 3.…

Read More

Oracle data fix remove unposted receipts and Full Merge events

Oracle data fix remove unposted receipts and Full Merge events     We have follow the below script. Step:1 Create back up table Create table scratch.AR_RECEIPTS_BACKUP_MAY201 as select * from…

Read More

utlrp hangs after upgrade to 12c ERP database

We were performing database upgrade from oracle 11g to oracle 12c with Oracle Apps 12.1.3. We faced an issue where database upgrade took < 30 mins. However, it made huge…

Read More

SOA webservices not working after 12c ERP db upgrade

After upgrading  database from oracle 11g to 12c in Oracle Apps R12.1.3,  got a strange issue where SOA webservices- SOAP, REST  stopped. The following url showed 404 http://host.domain:8000/webservices/SOAProvider/?testquery The issue…

Read More

Oracle apps adpatch fails

Many times , when applying patch using adpatch in oracle apps, the patch session session gets terminated because of network problems. The best way to continue the patch is to…

Read More

FRM-92102 Errors when Accessing a Forms Module

When attempting to access E-Business Suite Forms on a cloned E-Business Suite instance the following error occurs: FRM-92102 A network Error has occurred. The Forms Client has attempted to reestablish its…

Read More

Sometimes the Formsapp.ear deployment fails on Application startup after applying Patches

Error while executing the perl script txkChkFormsDeployment.pl We have determined that you need to redeploy Forms (using txkChkFormsDeployment.pl). But could not do it automatically for you, due to some issues.…

Read More

To Re-build database tier context file in r12.2

adbldxml.pl perl command used to re-create database tier context file. To re-create database tier context file follow the below steps. STEPS : 1. Run adbldxml.pl on <RDBMS ORACLE_HOME> perl <RDBMS…

Read More

BI Publisher program failed due to opp

Error: “Post-processing of request 4667897 failed at 30-Apr-2021 15:54:50 with the error message: One or more post-processing actions failed. Consult the OPP service log for details.” … oracle.apps.fnd.cp.opp.PostProcessorException: oracle.apps.fnd.cp.opp.PostProcessorException: oracle.apps.xdo.XDOException”…

Read More