Skip to main content

Posts

Oracle Passing array elements as input parameters.

 set serveroutput on ; CREATE OR REPLACE TYPE MyType AS VARRAY(200) OF VARCHAR2(50); \ CREATE OR REPLACE PROCEDURE testing(t_in MyType, v_type in varchar) IS   ret varchar2(100):='';  BEGIN    FOR i IN 1..t_in.count LOOP     dbms_output.put_line(t_in(i));     IF i < t_in.count THEN      ret:=ret||' '''||t_in(i)||''',  ';     ELSE      ret:=ret||' '''||t_in(i)||'''  ';     END IF ;     END LOOP;   dbms_output.put_line(ret);   dbms_output.put_line(v_type);  END; \  DECLARE       v_t MyType;     BEGIN       v_t := MyType();       v_t.EXTEND(3);       v_t(1) := 'WAPPR';       v_t(2) := 'APPR';       v_t(3) := 'INPRG';       testing(v_t,'Test');     END;

Maximo heap dump analysis

 Often we see in our environment particularly non prod we saw memory leak or heap dumps. There can be chance of this due to memory leakage and often require analysis too found root cause. There are different tools commercial as well as opersource to analys these heap dumps We will see why heap dumps created and how to identify issue.

Maximo Reorder not generating PR

 If Reorder is not generating PR  1. Check for vendor order unit has a conversion exists with item issue unit? 2. Check for ITem is active at org and inventory level? 3. Check any field is mandatory in PR which is not fullfilled while PR is getting generated from Reorder? 4. Check calculation for Quantity to reorder matches with calculation? 5. Check exchange rate is defined for Currency specified for vendor? 6. Check GL account is  valid?

Maximo Technical Consultant Course Syllabus

DB config Application Designer Escalation Crontask Workflow Designer Automation Script Migration Manager Object Structure Message Tracking Import export via CSV Mximo Integration Framework Maximo Webservice SOAP Maximo Webservice Rest Call a Webserver from Mbo Class or Bean Class Integration Automation Script

Unix/Linux Important Commands

Main Linux commands ls -lrt == list of files order by date ascending ls -lrt | tail - 10  == list of files order by date ascending Top 10 wc -l == line count in file grep -i === Match pattern ignoring case grep -i Test00 == Find word  Test00  ignoring case and give the list of words containing  Test00 grep -i  Test00  | wc -l === Gives count of number of words wc -l Test.txt == this will give line count in text.txt grep -i "Maximo" | wc -l = Give the count of lines which contains word Maximo pwd === Print working directory. cd == to go into directory cd .. == to go out of directory df -H == This is used to check disk file system space available and used. rm file.txt == to remove file ls heap* == to list all files with heap* name.. TOP == see all process kill -9 IDOFPROCESSTOKILL