Gather Schema Statistics fails with “ORA-20005: Object Statistics Are Locked (Stattype = ALL)” Log file shows the following error, ORACLE error 20005 in FDPSTP Cause: FDPSTP failed due to ORA-20005:…
Read MoreBy using following script we can get parameter value in page level. Based on value we can set rendered property for the fields as follows: public void processRequest(OAPageContext pageContext, OAWebBean…
Read MoreUsing 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 MoreBy 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 MoreCAUSE: 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 MoreBefore 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 MoreDescription 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 MorePath: 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 MoreProblem: 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 MoreAs 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 More