How to terminate instance number in Install Base
Using below script we can terminate instance number in Install Base. UPDATE csi_item_instances SET active_end_date = SYSDATE WHERE instance_id = l_instance_id;
Read MoreJava script validation in OAF
By using below java script in OAF. we can validate based on field value and can throw error. var colspt2 = ‘quoteValidate’.split(\”^\”); for (var k = 0; k < colspt2.length…
Read MoreIn EBS R12.2 ‘adop phase=fs_clone’ session may appear to hang (or) Following Exception thrown “Thread-1” java.lang.OutOfMemoryError: Java heap space (or) Fails with “[UNEXPECTED]Error running adadminsrvctl command.
CAUSE: The issue is caused by lack of Java heap resources to run the process. SOLUTION: To implement the solution, please execute the following steps: 1. Issue the following command…
Read MoreHow to fix INVALID status for RAC component in dba_registry
Before upgrade or after upgrade, database may show INVALID status for component Real Application Clusters in dba_registry as below . SQL> select comp_name,version,status from dba_registry; … Oracle Real Application…
Read MoreShell script to check and test printer.
Description Below script is used to check the printer, IP status and testing the printer. Script : #!/bin/bash con() { if [ $choice -eq 1 ] then echo “Give ip…
Read MoreCalendar creation
Path: General ledger super user > Setup > Financials > Calendars > Types Step 1: Creating calendar type S1: while entering into types it will open automatically S2: Enter period…
Read MoreHow to Create the boot.properties in IDCS Asserter
Problem: When you are running the weblogic in production mode and when you try to start the weblogic using nohup then there is no chance to enter the username and…
Read MoreWorking Efficiently with Oracle Support
As an Oracle consultant, there will be many times you will need to raise Oracle support for multiple issues. When there is tight schedule, you will look for quicker responses…
Read MoreEBS R12.2 Weblogic Managed Servers are crashing frequently
ISSUE ====== EBS R12.2 Weblogic Managed Servers are crashing frequently . Weblogic Managed Servers crashing frequently due to “weblogic.socket.MaxMessageSizeExceededException” error Admin Server Log file has the below error message. ===================================================…
Read MoreOutput Post Processor (FNDOPP) is not Staring
The Output Post Processor (FNDOPP) Manager is not starting, process status is shown as Actual with 0 and the Target is 1 The OPP logfile shows the following exceptions: [UNEXPECTED] java.sql.SQLException:…
Read More