Oracle Application Blog

Installing Oracle Enterprise Command Center Framework, Release 12.2.8

Installing Oracle Enterprise Command Center Framework, Release 12.2.8 Oracle Database version: 12.2.0.2 Oracle EBS version : 12.2.8 Oracle Enterprise Command Center Framework: 6.0 Oracle WebLogic Server: 12.2.1.4 1.1 Download the…

Read More

Invalid objects due to multiple database editions

There are around 1000 plus invalid objects, while looking further observed that this object do not exist in current run edition and there are duplicate/multiple entries observed for RUN and…

Read More

Oracle Invisible Columns

Oracle allows columns to be hidden from application. Columns can be made invisible in the CREATE TABLE statement or using an ALTER TABLE statement.By default columns are visible. Invisible columns…

Read More

How to check Oracle Application Modules Licensed or Not

Below script to find Oracle Application Modules are Licensed or Not. Script: SELECT fat.application_name ,fa.application_id ,fpi.patch_level ,decode(fpi.STATUS,’I’,’Licensed’, ‘N’,’Not Licensed’,’S’,’Shared’,’Undetermined’) STATUS ,fpi.* FROM fnd_product_installations fpi ,fnd_application fa ,fnd_application_tl fat WHERE fpi.application_id…

Read More

How to find the OPP log file location in oracle application 11i/R12.1 and R12.2

Below script to find the OPP log file location in oracle E-Business Suite. Script: SELECT fcpp.concurrent_request_id req_id, fcp.node_name, fcp.logfile_name FROM fnd_conc_pp_actions fcpp, fnd_concurrent_processes fcp WHERE fcpp.processor_id = fcp.concurrent_process_id AND fcpp.action_type…

Read More

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