Identify Memory Requirement.Following queries show you how to display the relevant memory information and how to combine with a single statement to calculate the required values.-- Individual values.COLUMN name FORMAT A30COLUMN value FORMAT A10SELECT name, valueFROM v$parameterWHERE name IN ('pga_aggregate_target', 'sga_target')UNIONSELECT...
Oracle FNDLOAD Scripts
FNDLOADTips and Examples Using FNDLOAD (Doc ID 735338.1) Download Script Upload Script 1. LookupsFNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/aflvmlu.lct XX_CUSTOM_LKP.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME="XXCUST" LOOKUP_TYPE="XX_LOOKUP_TYPE" FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/aflvmlu.lct XX_CUSTOM_LKP.ldt...
Running ADOP Fails With Error "ETCC Not Run In The Database Node"
Error: ETCC not run in the database node [Node Name] The EBS Technology Codelevel Checker needs to be run on the database node. It is available as...
ETL Phases
Oracle BI Applications ETL processes includes three main phases: SDE, SIL, and PLP.SDE stands for Source Dependent Extract. In this phase, SDE tasks extract data from the source system and SDS and stage it in staging tables. SDE tasks are source specific.SIL stands for Source Independent Load. Load tasks transform and port the data from staging tables...
Customizing the WebLogic JVM heap size
How to customize Java Virtual Machine Settings in Oracle WebLogic ServerTo achieve the best performance of the application and avoid performance bottlenecks problems ( “OutOfMemory”) you need to tune your Java Virtual Machine.After fresh install of WebLogic Server and create a Domain (WebLogic or SOA or Forms or OBIEE etc.) you may set some...
"Create or Replace view" execution fails with "ORA-01720: grant option does not exist"
Developer complains that he can't run CREATE OR REPLACE VIEW for a particular view. He is getting error "ORA-01720: Grant Option Does Not Exist"I searched online and didn’t find solution that fix my issue. Everyone was getting this error with a GRANT statement. I turned to My Oracle Support and found excellent note which saved my time.Cause: view...
How to switch RUN File System and Patch File System in R12.2
The existence of the dual file system has implications for patches that change the system configuration. Depending on the specific situation, configuration changes can be made to either the run file system or the patch file system.Sourcing Environment for run File system:....
How to Synchronize FND_NODES, ADOP_VALID_NODES, and FND_OAM_CONTEXT_FILES in 12.2 When ADOP Phase=Prepare Fails with Error
How to Synchronize FND_NODES, ADOP_VALID_NODES, and FND_OAM_CONTEXT_FILES in 12.2 When ADOP Phase=Prepare Fails with ErrorAfter a recent change or addition to the 12.2 E-Business Suite application tiers, adop phase=prepare fails with the following error:Error$ adop phase=prepareEnter the APPS password:Enter the SYSTEM password:Enter the WLSADMIN password:Validating...
