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 MoreThere 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 MoreOracle 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 MoreBelow 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 MoreBelow 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 MoreEdition 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 MoreWe 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 MoreOracle 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 MoreWe 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 MoreAfter 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